xtrabackup备份mysql5.7_MySQL5.6下使用xtrabackup部分备份恢复到MySQL5.7

[root@mysql-bcc01 sql]# innobackupex --apply-log --export 2016-10-08_17-53-09

161008 17:53:50 innobackupex: Starting the apply-log operation

IMPORTANT: Please check that the apply-log run completes successfully.

At the end of a successful apply-log run innobackupex

prints"completed OK!".

innobackupex version2.4.4 based on MySQL server 5.7.13 Linux (x86_64) (revision id: df58cf2)

xtrabackup: auto-enabling --innodb-file-per-table due to the --export option

xtrabackup: cd to/data0/sql/2016-10-08_17-53-09xtrabackup: This target seems to be not prepared yet.

InnoDB: Number of pools:1xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(802528374)

xtrabackup: using the following InnoDB configurationforrecovery:

xtrabackup: innodb_data_home_dir=.

xtrabackup: innodb_data_file_path=ibdata1:512M:autoextend

xtrabackup: innodb_log_group_home_dir=.

xtrabackup: innodb_log_files_in_group= 1xtrabackup: innodb_log_file_size= 8388608xtrabackup: using the following InnoDB configurationforrecovery:

xtrabackup: innodb_data_home_dir=.

xtrabackup: innodb_data_file_path=ibdata1:512M:autoextend

xtrabackup: innodb_log_group_home_dir=.

xtrabackup: innodb_log_files_in_group= 1xtrabackup: innodb_log_file_size= 8388608xtrabackup: Starting InnoDB instanceforrecovery.

xtrabackup: Using104857600 bytes for buffer pool (set by --use-memory parameter)

InnoDB: PUNCH HOLE support not available

InnoDB: Mutexes and rw_locks use GCC atomic builtins

InnoDB: Uses event mutexes

InnoDB: GCC builtin __sync_synchronize() is usedformemory barrier

InnoDB: Compressed tables use zlib1.2.3InnoDB: Number of pools:1InnoDB: Using CPU crc32 instructions

InnoDB: Initializing buffer pool, total size= 100M, instances = 1, chunk size =100M

InnoDB: Completed initialization of buffer pool

InnoDB: page_cleaner coordinator priority:-20InnoDB: Highest supportedfileformat is Barracuda.

InnoDB: The log sequence number2342986 in the system tablespace does not match the log sequence number 802528374 in the ib_logfiles!InnoDB: Database was not shutdown normally!InnoDB: Starting crash recovery.

InnoDB: Doing recovery: scanned up to log sequence number802528374 (0%)

InnoDB: xtrabackup: Last MySQL binlogfile position 2987, file name mysql-bin.000003InnoDB: Creating shared tablespacefortemporary tables

InnoDB: Settingfile './ibtmp1' size to 12 MB. Physically writing the file full; Please wait...

InnoDB: File'./ibtmp1' size is now 12MB.

InnoDB:96 redo rollback segment(s) found. 1redo rollback segment(s) are active.

InnoDB:32 non-redo rollback segment(s) are active.

InnoDB:5.7.13 started; log sequence number 802528374xtrabackup: export option is specified.

xtrabackup: export metadata of table'test/t1' to file `./test/t1.exp` (1indexes)

xtrabackup: name=PRIMARY, id.low=32, page=3xtrabackup: export metadata of table'mysql/slave_relay_log_info' to file `./mysql/slave_relay_log_info.exp` (1indexes)

xtrabackup: name=PRIMARY, id.low=19, page=3xtrabackup: export metadata of table'mysql/innodb_index_stats' to file `./mysql/innodb_index_stats.exp` (1indexes)

xtrabackup: name=PRIMARY, id.low=18, page=3xtrabackup: export metadata of table'mysql/slave_worker_info' to file `./mysql/slave_worker_info.exp` (1indexes)

xtrabackup: name=PRIMARY, id.low=21, page=3xtrabackup: export metadata of table'mysql/innodb_table_stats' to file `./mysql/innodb_table_stats.exp` (1indexes)

xtrabackup: name=PRIMARY, id.low=17, page=3xtrabackup: export metadata of table'mysql/slave_master_info' to file `./mysql/slave_master_info.exp` (1indexes)

xtrabackup: name=PRIMARY, id.low=20, page=3InnoDB: xtrabackup: Last MySQL binlogfile position 2987, file name mysql-bin.000003xtrabackup: starting shutdown with innodb_fast_shutdown= 0InnoDB: FTS optimize thread exiting.

InnoDB: Starting shutdown...

InnoDB: Failed tofind tablespace for table `test`.`t2` in the cache. Attempting to load the tablespace with space id 113InnoDB: Operating system error number2 in a fileoperation.

InnoDB: The error means the system cannotfindthe path specified.

InnoDB: Cannot open datafilefor read-only: './test/t2.ibd' OS error: 71InnoDB: Operating system error number2 in a fileoperation.

InnoDB: The error means the system cannotfindthe path specified.

InnoDB: Could notfind a valid tablespace file for `test/t2`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.

InnoDB: Shutdown completed; log sequence number 802528393InnoDB: Number of pools:1xtrabackup: using the following InnoDB configurationforrecovery:

xtrabackup: innodb_data_home_dir=.

xtrabackup: innodb_data_file_path=ibdata1:512M:autoextend

xtrabackup: innodb_log_group_home_dir=.

xtrabackup: innodb_log_files_in_group= 3xtrabackup: innodb_log_file_size= 104857600InnoDB: PUNCH HOLE support not available

InnoDB: Mutexes and rw_locks use GCC atomic builtins

InnoDB: Uses event mutexes

InnoDB: GCC builtin __sync_synchronize() is usedformemory barrier

InnoDB: Compressed tables use zlib1.2.3InnoDB: Number of pools:1InnoDB: Using CPU crc32 instructions

InnoDB: Initializing buffer pool, total size= 100M, instances = 1, chunk size =100M

InnoDB: Completed initialization of buffer pool

InnoDB: page_cleaner coordinator priority:-20InnoDB: Setting logfile ./ib_logfile101 size to 100MB

InnoDB: ProgressinMB:100InnoDB: Setting logfile ./ib_logfile1 size to 100MB

InnoDB: ProgressinMB:100InnoDB: Setting logfile ./ib_logfile2 size to 100MB

InnoDB: ProgressinMB:100InnoDB: Renaming logfile ./ib_logfile101 to ./ib_logfile0

InnoDB: New log files created, LSN=802528393InnoDB: Highest supportedfileformat is Barracuda.

InnoDB: Log scan progressed past the checkpoint lsn802528780InnoDB: Doing recovery: scanned up to log sequence number802528789 (0%)

InnoDB: Doing recovery: scanned up to log sequence number802528789 (0%)

InnoDB: Database was not shutdown normally!InnoDB: Starting crash recovery.

InnoDB: xtrabackup: Last MySQL binlogfile position 2987, file name mysql-bin.000003InnoDB: Removed temporary tablespace datafile: "ibtmp1"InnoDB: Creating shared tablespacefortemporary tables

InnoDB: Settingfile './ibtmp1' size to 12 MB. Physically writing the file full; Please wait...

InnoDB: File'./ibtmp1' size is now 12MB.

InnoDB:96 redo rollback segment(s) found. 1redo rollback segment(s) are active.

InnoDB:32 non-redo rollback segment(s) are active.

InnoDB:5.7.13 started; log sequence number 802528789InnoDB: Failed tofind tablespace for table `test`.`t2` in the cache. Attempting to load the tablespace with space id 113InnoDB: Operating system error number2 in a fileoperation.

InnoDB: The error means the system cannotfindthe path specified.

InnoDB: Cannot open datafilefor read-only: './test/t2.ibd' OS error: 71InnoDB: Operating system error number2 in a fileoperation.

InnoDB: The error means the system cannotfindthe path specified.

InnoDB: Could notfind a valid tablespace file for `test/t2`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.

xtrabackup: starting shutdown with innodb_fast_shutdown = 0InnoDB: FTS optimize thread exiting.

InnoDB: Starting shutdown...

InnoDB: Shutdown completed; log sequence number802528808

161008 17:53:57 completed OK!