/usr/bin/innobackupex --defaults-file=/etc/mysql/3306.cnf /data0/sql  --include=‘test.t1|mysql.*|performance_schema.*‘ --user=root --socket=/tmp/mysql_3306.sock

/usr/bin/innobackupex --defaults-file=/etc/mysql/3306.cnf /data0/sql  --databases=‘test.t1 mysql performance_schema‘ --user=root --socket=/tmp/mysql_3306.sock

[root@mysql-bcc01 sql]# innobackupex --apply-log --export 2016-10-08_17-53-09161008 17:53:50 innobackupex: Starting the apply-log operationIMPORTANT: Please check that the apply-log run completes successfully.           At the end of a successful apply-log run innobackupex           prints "completed OK!".innobackupex version 2.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 optionxtrabackup: 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 configuration for recovery:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:512M:autoextendxtrabackup:   innodb_log_group_home_dir = .xtrabackup:   innodb_log_files_in_group = 1xtrabackup:   innodb_log_file_size = 8388608xtrabackup: using the following InnoDB configuration for recovery:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:512M:autoextendxtrabackup:   innodb_log_group_home_dir = .xtrabackup:   innodb_log_files_in_group = 1xtrabackup:   innodb_log_file_size = 8388608xtrabackup: Starting InnoDB instance for recovery.xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)InnoDB: PUNCH HOLE support not availableInnoDB: Mutexes and rw_locks use GCC atomic builtinsInnoDB: Uses event mutexesInnoDB: GCC builtin __sync_synchronize() is used for memory barrierInnoDB: Compressed tables use zlib 1.2.3InnoDB: Number of pools: 1InnoDB: Using CPU crc32 instructionsInnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100MInnoDB: Completed initialization of buffer poolInnoDB: page_cleaner coordinator priority: -20InnoDB: Highest supported file format is Barracuda.InnoDB: The log sequence number 2342986 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 number 802528374 (0%)InnoDB: xtrabackup: Last MySQL binlog file position 2987, file name mysql-bin.000003InnoDB: Creating shared tablespace for temporary tablesInnoDB: Setting file ‘./ibtmp1‘ size to 12 MB. Physically writing the file full; Please wait ...InnoDB: File ‘./ibtmp1‘ size is now 12 MB.InnoDB: 96 redo rollback segment(s) found. 1 redo 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` (1 indexes)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` (1 indexes)xtrabackup:     name=PRIMARY, id.low=19, page=3xtrabackup: export metadata of table ‘mysql/innodb_index_stats‘ to file `./mysql/innodb_index_stats.exp` (1 indexes)xtrabackup:     name=PRIMARY, id.low=18, page=3xtrabackup: export metadata of table ‘mysql/slave_worker_info‘ to file `./mysql/slave_worker_info.exp` (1 indexes)xtrabackup:     name=PRIMARY, id.low=21, page=3xtrabackup: export metadata of table ‘mysql/innodb_table_stats‘ to file `./mysql/innodb_table_stats.exp` (1 indexes)xtrabackup:     name=PRIMARY, id.low=17, page=3xtrabackup: export metadata of table ‘mysql/slave_master_info‘ to file `./mysql/slave_master_info.exp` (1 indexes)xtrabackup:     name=PRIMARY, id.low=20, page=3InnoDB: xtrabackup: Last MySQL binlog file position 2987, file name mysql-bin.000003xtrabackup: starting shutdown with innodb_fast_shutdown = 0InnoDB: FTS optimize thread exiting.InnoDB: Starting shutdown...InnoDB: Failed to find tablespace for table `test`.`t2` in the cache. Attempting to load the tablespace with space id 113InnoDB: Operating system error number 2 in a file operation.InnoDB: The error means the system cannot find the path specified.InnoDB: Cannot open datafile for read-only: ‘./test/t2.ibd‘ OS error: 71InnoDB: Operating system error number 2 in a file operation.InnoDB: The error means the system cannot find the path specified.InnoDB: Could not find 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 configuration for recovery:xtrabackup:   innodb_data_home_dir = .xtrabackup:   innodb_data_file_path = ibdata1:512M:autoextendxtrabackup:   innodb_log_group_home_dir = .xtrabackup:   innodb_log_files_in_group = 3xtrabackup:   innodb_log_file_size = 104857600InnoDB: PUNCH HOLE support not availableInnoDB: Mutexes and rw_locks use GCC atomic builtinsInnoDB: Uses event mutexesInnoDB: GCC builtin __sync_synchronize() is used for memory barrierInnoDB: Compressed tables use zlib 1.2.3InnoDB: Number of pools: 1InnoDB: Using CPU crc32 instructionsInnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100MInnoDB: Completed initialization of buffer poolInnoDB: page_cleaner coordinator priority: -20InnoDB: Setting log file ./ib_logfile101 size to 100 MBInnoDB: Progress in MB: 100InnoDB: Setting log file ./ib_logfile1 size to 100 MBInnoDB: Progress in MB: 100InnoDB: Setting log file ./ib_logfile2 size to 100 MBInnoDB: Progress in MB: 100InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0InnoDB: New log files created, LSN=802528393InnoDB: Highest supported file format is Barracuda.InnoDB: Log scan progressed past the checkpoint lsn 802528780InnoDB: Doing recovery: scanned up to log sequence number 802528789 (0%)InnoDB: Doing recovery: scanned up to log sequence number 802528789 (0%)InnoDB: Database was not shutdown normally!InnoDB: Starting crash recovery.InnoDB: xtrabackup: Last MySQL binlog file position 2987, file name mysql-bin.000003InnoDB: Removed temporary tablespace data file: "ibtmp1"InnoDB: Creating shared tablespace for temporary tablesInnoDB: Setting file ‘./ibtmp1‘ size to 12 MB. Physically writing the file full; Please wait ...InnoDB: File ‘./ibtmp1‘ size is now 12 MB.InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active.InnoDB: 32 non-redo rollback segment(s) are active.InnoDB: 5.7.13 started; log sequence number 802528789InnoDB: Failed to find tablespace for table `test`.`t2` in the cache. Attempting to load the tablespace with space id 113InnoDB: Operating system error number 2 in a file operation.InnoDB: The error means the system cannot find the path specified.InnoDB: Cannot open datafile for read-only: ‘./test/t2.ibd‘ OS error: 71InnoDB: Operating system error number 2 in a file operation.InnoDB: The error means the system cannot find the path specified.InnoDB: Could not find 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 number 802528808161008 17:53:57 completed OK!

[root@mysql-bcc02 mysql]# mysql_upgrade --user=root --socket=/tmp/mysql_6666.sock