RTANT: Please check that the backup runcompletes successfully.
Atthe end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using mysql server version 5.5.48
innobackupex: Created backup directory /backup/full_data/2017-04-04_13-28-58
170404 13:28:58 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-file="/etc/my.cnf" --defaults-group="mysqld" --backup--suspend-at-end --target-dir=/backup/full_data/2017-04-04_13-28-58 --tmpdir=/tmp
innobackupex: Waiting for ibbackup (pid=26398) tosuspend
innobackupex: Suspend file'/backup/full_data/2017-04-04_13-28-58/xtrabackup_suspended_2'
xtrabackup_55 version 2.1.9 for Percona Server5.5.35 Linux (x86_64) (revision id: 744)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /data/mysql/
xtrabackup: open files limit requested 65535, setto 65535
xtrabackup: using the following InnoDBconfiguration:
xtrabackup: innodb_data_home_dir = /usr/local/mysql/var
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = /usr/local/mysql/var
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 268435456
>> log scanned up to (619371504)
[01] Copying/usr/local/mysql/var/ibdata1 to /backup/full_data/2017-04-04_13-28-58/ibdata1
>> log scanned up to (619371504)
.......................
>> log scanned up to (619371544)
[01] ...done
>> log scanned up to (619371544)
xtrabackup: Creating suspend file'/backup/full_data/2017-04-04_13-28-58/xtrabackup_suspended_2' with pid '26398'
170404 13:29:13 innobackupex: Continuing after ibbackup has suspended
170404 13:29:13 innobackupex: Starting to lock all tables...
>> log scanned up to (619371544)
170404 13:29:13 innobackupex: All tables locked and flushed to disk
170404 13:29:13 innobackupex: Starting to backup non-InnoDB tables and files
innobackupex: in subdirectories of '/data/mysql/'
innobackupex: Backing up files'/data/mysql//mahtu/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'(747 files)
>> log scanned up to (619371544)
...............
>> log scanned up to (619371544)
170404 13:29:19 innobackupex: Finished backing up non-InnoDB tables and files
170404 13:29:19 innobackupex: Waiting for log copying to finish
xtrabackup: The latest check point (forincremental): '619371544'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (619371544)
xtrabackup: Creating suspend file'/backup/full_data/2017-04-04_13-28-58/xtrabackup_log_copied' with pid '26398'
xtrabackup: Transaction log of lsn (619371135) to(619371544) was copied.
170404 13:29:20 innobackupex: All tables unlocked
innobackupex: Backup created in directory'/backup/full_data/2017-04-04_13-28-58'
innobackupex: MySQL slave binlog position: masterhost '192.168.10.20', filename 'mysql-bin.000001', position 35593612
170404 13:29:20 innobackupex: Connection to database server closed
170404 13:29:20 innobackupex: completed OK!
real 0m25.738s
user 0m2.765s
sys 0m3.927s
备份数据恢复的报错提示:
[root@localhost 2017-04-04_16-04-46]#innobackupex --defaults-file=/etc/my.cnf --copy-back /backup/dk_data/2017-0