再次尝试备份master数据库
[root@master-qa ~]# /usr/bin/innobackupex --defaults-file=/etc/my.cnf --user=root --password=xxxxxxx /data/fullbackup/
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p
151012 15:24:06 innobackupex: Executing a version check against the server...
151012 15:24:06 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'root' (using password: YES).
151012 15:24:06 innobackupex: Connected to MySQL server
151012 15:24:06 innobackupex: Done.
151012 15:24:06 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'root' (using password: YES).
151012 15:24:06 innobackupex: Connected to MySQL server
151012 15:24:06 innobackupex: Starting the backup operation
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using server version 5.6.25-73.0-log
innobackupex: Created backup directory /data/fullbackup/2015-10-12_15-24-06
151012 15:24:06 innobackupex: Starting ibbackup with command: xtrabackup --defaults-file="/etc/my.cnf" --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/data/fullbackup/2015-10-12_15-24-06 --innodb_data_file_path="ibdata1:12M:autoextend" --tmpdir=/var/tmp --extra-lsndir='/var/tmp'
innobackupex: Waiting for ibbackup (pid=3577) to suspend
innobackupex: Suspend file '/data/fullbackup/2015-10-12_15-24-06/xtrabackup_suspended_2'
xtrabackup version 2.2.12 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 8726828)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: open files limit requested 0, set to 65536
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = /var/lib/mysql/
xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 134217728
xtrabackup: using O_DIRECT
>> log scanned up to (76232231155)
xtrabackup: Generating a list of tablespaces
[01] Copying /var/lib/mysql/ibdata1 to /data/fullbackup/2015-10-12_15-24-06/ibdata1
>> log scanned up to (76232231155)
>> log scanned up to (76232231155)
>> log scanned up to (76232231155)
>> log scanned up to (76232231155)
>> log scanned up to (76232231155)
>> log scanned up to (76232231155)
...
...
>> log scanned up to (76232238365)
>> log scanned up to (76232238365)
>> log scanned up to (76232238365)
>> log scanned up to (76232238365)
[01] ...done
[01] Copying ./food_qa/topic_pages.ibd to /data/fullbackup/2015-10-12_15-24-06/food_qa/topic_pages.ibd
[01] ...done
>> log scanned up to (76232238365)
[01] Copying ./food_qa/food_compares.ibd to /data/fullbackup/2015-10-12_15-24-06/food_qa/food_compares.ibd
[01] ...done
...
...
>> log scanned up to (76232242511)
151012 15:31:21 innobackupex: Finished backing up non-InnoDB tables and files
151012 15:31:21 innobackupex: Executing LOCK BINLOG FOR BACKUP...
151012 15:31:21 innobackupex: Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
151012 15:31:21 innobackupex: Waiting for log copying to finish
xtrabackup: The latest check point (for incremental): '76232242511'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (76232242511)
xtrabackup: Creating suspend file '/data/fullbackup/2015-10-12_15-24-06/xtrabackup_log_copied' with pid '3577'
xtrabackup: Transaction log of lsn (76232231155) to (76232242511) was copied.
151012 15:31:22 innobackupex: Executing UNLOCK BINLOG
151012 15:31:22 innobackupex: Executing UNLOCK TABLES
151012 15:31:22 innobackupex: All tables unlocked
innobackupex: Backup created in directory '/data/fullbackup/2015-10-12_15-24-06'
innobackupex: MySQL binlog position: filename 'mysql-bin.000009', position 1509223
151012 15:31:22 innobackupex: Connection to database server closed
151012 15:31:22 innobackupex: completed OK!
[root@master-qa ~]# echo $?
0
[root@master-qa ~]#
本文系转载,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。
本文系转载,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。