Using MySQL Enterprise Backup Tools-candon123

eddik

[root@mydb01 lib]# mysqlbackup --user=root --datadir=/var/lib/mysql --backup-dir=/u02/full/2018-06-27_11-00-05 copy-back　　MySQL Enterprise Backup version 4.1.1 Linux-4.1.12-61.1.16.el7uek.x86_64-x86_64 [2018/04/24 07:54:03]
　　Copyright (c) 2003, 2018, Oracle and/or its affiliates. All Rights Reserved.

　　[Build>
　　180627 12:32:19 MAIN    INFO: A thread created with>　　180627 12:32:19 MAIN    INFO: Starting with following command line ...
　　mysqlbackup --user=root --datadir=/var/lib/mysql
　　--backup-dir=/u02/full/2018-06-27_11-00-05 copy-back
　　180627 12:32:19 MAIN    INFO:
　　IMPORTANT: Please check that mysqlbackup run completes successfully.
　　At the end of a successful 'copy-back' run mysqlbackup
　　prints "mysqlbackup completed OK!".
　　180627 12:32:19 MAIN    INFO: MySQL server version is '5.7.22-log'
　　180627 12:32:19 MAIN    INFO: Restoring ...5.7.22-log version
　　180627 12:32:19 MAIN WARNING: If you restore to a server of a different version, the innodb_data_file_path parameter might have a different default. In that case you need to add 'innodb_data_file_path=ibdata1:12M:autoextend' to the target server configuration.
　　180627 12:32:19 MAIN WARNING: If you restore to a server of a different version, the innodb_log_files_in_group parameter might have a different default. In that case you need to add 'innodb_log_files_in_group=2' to the target server configuration.
　　180627 12:32:19 MAIN WARNING: If you restore to a server of a different version, the innodb_log_file_size parameter might have a different default. In that case you need to add 'innodb_log_file_size=50331648' to the target server configuration.
　　180627 12:32:19 MAIN    INFO: KEF source path:'/u02/full/2018-06-27_11-00-05/meta'
　　180627 12:32:19 MAIN    INFO: KEF target path:'/var/lib/mysql'
　　180627 12:32:19 MAIN    INFO: TDE Keyring service initialized.
　　180627 12:32:19 MAIN    INFO: MEB logfile created at /u02/full/2018-06-27_11-00-05/meta/MEB_2018-06-27.12-32-19_copy_back.log
　　--------------------------------------------------------------------
　　Server Repository Options:
　　--------------------------------------------------------------------
　　datadir                        = /var/lib/mysql
　　innodb_data_home_dir           = /var/lib/mysql
　　innodb_data_file_path          = ibdata1:12M:autoextend
　　innodb_log_group_home_dir      = /var/lib/mysql
　　innodb_log_files_in_group      = 2
　　innodb_log_file_size           = 50331648
　　innodb_buffer_pool_filename    = ib_buffer_pool
　　innodb_page_size               = Null
　　innodb_checksum_algorithm      = crc32
　　--------------------------------------------------------------------
　　Backup Config Options:
　　--------------------------------------------------------------------
　　datadir                        = /u02/full/2018-06-27_11-00-05/datadir
　　innodb_data_home_dir           = /u02/full/2018-06-27_11-00-05/datadir
　　innodb_data_file_path          = ibdata1:12M:autoextend
　　innodb_log_group_home_dir      = /u02/full/2018-06-27_11-00-05/datadir
　　innodb_log_files_in_group      = 2
　　innodb_log_file_size           = 50331648
　　innodb_buffer_pool_filename    = ib_buffer_pool
　　innodb_page_size               = 16384
　　innodb_checksum_algorithm      = crc32

　　180627 12:32:19 MAIN    INFO: Creating 14 buffers each of>　　180627 12:32:19 MAIN    INFO: Copy-back operation starts with following threads
　　1 read-threads    1 write-threads
　　180627 12:32:19 MAIN    INFO: Starting to copy all innodb files...

　　180627 12:32:19 RDR1    INFO: A thread created with>
　　180627 12:32:19 WTR1    INFO: A thread created with>　　180627 12:32:19 RDR1    INFO: Copying /u02/full/2018-06-27_11-00-05/datadir/ibdata1.
　　......
　　180627 12:41:55 RDR1    INFO: Copying /u02/full/2018-06-27_11-00-05/datadir/lepus/questions.ibd.
　　180627 12:41:55 RDR1    INFO: Copying /u02/full/2018-06-27_11-00-05/datadir/mysql/engine_cost.ibd.
　　180627 12:41:55 RDR1    INFO: Copying /u02/full/2018-06-27_11-00-05/datadir/mysql/gtid_executed.ibd.
　　180627 12:41:55 RDR1    INFO: Copying /u02/full/2018-06-27_11-00-05/datadir/mysql/innodb_index_stats.ibd.
　　180627 12:41:55 RDR1    INFO: Copying /u02/full/2018-06-27_11-00-05/datadir/mysql/innodb_table_stats.ibd.
　　180627 12:41:55 RDR1    INFO: Copying /u02/full/2018-06-27_11-00-05/datadir/mysql/server_cost.ibd.
　　180627 12:41:55 RDR1    INFO: Copying /u02/full/2018-06-27_11-00-05/datadir/mysql/slave_master_info.ibd.
　　180627 12:41:55 RDR1    INFO: Copying /u02/full/2018-06-27_11-00-05/datadir/mysql/slave_relay_log_info.ibd.
　　180627 12:41:55 RDR1    INFO: Copying /u02/full/2018-06-27_11-00-05/datadir/mysql/slave_worker_info.ibd.
　　180627 12:41:55 RDR1    INFO: Copying /u02/full/2018-06-27_11-00-05/datadir/sys/sys_config.ibd.
　　180627 12:41:55 RDR1    INFO: Could not find binlog index file. binlogs will not be copied for this backup.
　　Point-In-Time-Recovery will not be possible.
　　If this is online backup then server may not have started with --log-bin.
　　You may specify its location with --log-bin-index option.
　　180627 12:41:55 RDR1    INFO: Completed the copy of binlog files...
　　180627 12:41:55 RDR1    INFO: Copying the database directory '.oracle_jre_usage'
　　180627 12:41:55 RDR1    INFO: Copying the database directory 'hjy_zxzy'
　　180627 12:41:55 RDR1    INFO: Copying the database directory 'lepus'
　　180627 12:41:55 RDR1    INFO: Copying the database directory 'mysql'
　　180627 12:41:55 RDR1    INFO: Copying the database directory 'performance_schema'
　　180627 12:41:55 RDR1    INFO: Copying the database directory 'sys'
　　180627 12:41:55 RDR1    INFO: Completing the copy of all non-innodb files.
　　180627 12:41:55 RDR1    INFO: Copying the log file 'ib_logfile0'
　　180627 12:41:55 RDR1    INFO: Copying the log file 'ib_logfile1'
　　180627 12:41:55 MAIN    INFO: No Keyring file to process.
　　180627 12:41:55 MAIN    INFO: MySQL server version is '5.7.22-log'
　　180627 12:41:55 MAIN    INFO: MySQL server compile os version is 'Linux'
　　180627 12:41:55 MAIN    INFO: Writing config file for server '5.7.22-log'.
　　180627 12:41:55 MAIN    INFO: Creating server config files server-my.cnf and server-all.cnf in /var/lib/mysql
　　180627 12:41:55 MAIN    INFO: Variable 'datadir'='/var/lib/mysql/'->'/var/lib/mysql' option 'datadir' type 0
　　180627 12:41:55 MAIN    INFO: Variable 'datadir'='/var/lib/mysql/'->'/var/lib/mysql' option 'datadir' type 0
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_buffer_pool_filename'='ib_buffer_pool'->'ib_buffer_pool' option 'innodb_buffer_pool_filename' type 9
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_buffer_pool_filename'='ib_buffer_pool'->'ib_buffer_pool' option 'innodb_buffer_pool_filename' type 9
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_checksum_algorithm'='crc32'->'crc32' option 'innodb_checksum_algorithm' type 11
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_checksum_algorithm'='crc32'->'crc32' option 'innodb_checksum_algorithm' type 11
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_checksums'='ON'->'ON' option 'innodb_checksums' type 12
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_checksums'='ON'->'ON' option 'innodb_checksums' type 12
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_data_file_path'='ibdata1:12M:autoextend'->'ibdata1:12M:autoextend' option 'innodb_data_file_path' type 2
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_data_file_path'='ibdata1:12M:autoextend'->'ibdata1:12M:autoextend' option 'innodb_data_file_path' type 2
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_data_home_dir'=''->'/var/lib/mysql' option 'innodb_data_home_dir' type 1
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_log_file_size'='50331648'->'50331648' option 'innodb_log_file_size' type 5
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_log_file_size'='50331648'->'50331648' option 'innodb_log_file_size' type 5
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_log_files_in_group'='2'->'2' option 'innodb_log_files_in_group' type 4
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_log_files_in_group'='2'->'2' option 'innodb_log_files_in_group' type 4
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_log_group_home_dir'='./'->'/var/lib/mysql' option 'innodb_log_group_home_dir' type 3
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_log_group_home_dir'='./'->'/var/lib/mysql' option 'innodb_log_group_home_dir' type 3
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_page_size'='16384'->'16384' option 'innodb_page_size' type 10
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_page_size'='16384'->'16384' option 'innodb_page_size' type 10
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_undo_directory'='./'->'/var/lib/mysql' option 'innodb_undo_directory' type 6
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_undo_directory'='./'->'/var/lib/mysql' option 'innodb_undo_directory' type 6
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_undo_logs'='128'->'128' option 'innodb_undo_logs' type 8
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_undo_logs'='128'->'128' option 'innodb_undo_logs' type 8
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_undo_tablespaces'='0'->'0' option 'innodb_undo_tablespaces' type 7
　　180627 12:41:55 MAIN    INFO: Variable 'innodb_undo_tablespaces'='0'->'0' option 'innodb_undo_tablespaces' type 7
　　180627 12:41:55 MAIN    INFO: Copy-back operation completed successfully.
　　180627 12:41:55 MAIN    INFO: Finished copying backup files to '/var/lib/mysql'
　　mysqlbackup completed OK!