Mysql 数据库备份工具 xtrabackup
1、安装测试数据库mysql5.7
详细步骤
yum install -y gcc gcc-c++ cmake bison ncurses-devel tar xf mysql-boost-5.7.22.tar.gz cd mysql-5.7.22/ cmake \ -DCMAKE_INSTALL_PREFIX=/data/mysql5.7.22 \ -DSYSCONFDIR=/etc/my.cnf \ -DMYSQL_DATADIR=/data/mysql/data \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DMYSQL_TCP_PORT=3306 \ -DEFAULT_CHARSET=utf8 \ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \ -DWITH_PARTITION_STORAGE_ENGINE=1 \ -DEFAULT_COLLATION=utf8_general_ci \ -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \ -DWITH_BOOST=./boost #-DWITH_SYSTEMD=1 [root@test02 mysql-5.7.22]# make -j 2 [root@test02 mysql-5.7.22]# make install [root@test02 mysql-5.7.22]# ln -s /data/mysql5.7.22/ /data/mysql [root@test02 mysql-5.7.22]# useradd -M -s /sbin/nologin mysql [root@test02 mysql]# cp /server/tools/mysql-5.7.22/packaging/rpm-common/my.cnf /etc [mysqld] basedir=/data/mysql datadir=/data/mysql/data socket=/tmp/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 log-error=/var/log/mysqld.log #pid-file=/var/run/mysqld/mysqld.pid [mysql] socket=/tmp/mysql.sock [root@test02 mysql-5.7.22]# cd /data/mysql/ [root@test02 mysql]# ./bin/mysqld --initialize --basedir=/data/mysql/ --datadir=/data/mysql/data --user=mysql [root@test02 mysql]# cp /server/tools/mysql-5.7.22/support-files/mysql.server /etc/init.d/mysqld [root@test02 mysql]# chmod +x /etc/init.d/mysqld [root@test02 mysql]# ln -s /data/mysql/bin/mysql /usr/bin/ [root@test02 mysql]# grep 'temporary password' /var/log/mysqld.log 2018-06-01T09:47:22.852922Z 1 [Note] A temporary password is generated for root@localhost: ZxH,(-_wz09o mysql> update mysql.user set authentication_string = password("123456") where user="root" -> ; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. mysql> mysql> mysql> SET PASSWORD = PASSWORD('123456'); Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)
准备测试数据
mysql> create database ops; Query OK, 1 row affected (0.00 sec) mysql> use ops; Database changed mysql> create table test (id int(4) not null auto_increment,name char(20) not null,primary key (id)); Query OK, 0 rows affected (0.03 sec) mysql> insert into test(id,name) values(1,'martin'); Query OK, 1 row affected (0.02 sec) mysql> insert into test(id,name) values(2,'jacky'); Query OK, 1 row affected (0.01 sec) mysql> insert into test(id,name) values(3,'marry'); Query OK, 1 row affected (0.01 sec) mysql> select * from test; +----+--------+ | id | name | +----+--------+ | 1 | martin | | 2 | jacky | | 3 | marry | +----+--------+ 3 rows in set (0.00 sec)
xtrabackup工具介绍
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm -y
[root@lnmp01 mysql]# yum install percona-xtrabackup-24 #安装工具
通过 innobackupex 备份数据库连接到服务: innobackupex 或者 xtrabackup 通过--user和--password 连接到数据库服务,--defaults-file 指定 mysql 配置文件目录
备份数据
[root@lnmp01 mysql]# innobackupex --defaults-file=/etc/my.cnf --user=root --password=123456 --socket=/tmp/mysql.sock /mnt/ 180602 09:29:38 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!". 180602 09:29:38 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/tmp/mysql.sock' as 'root' (using password: YES). 180602 09:29:38 version_check Connected to MySQL server 180602 09:29:38 version_check Executing a version check against the server... 180602 09:29:38 version_check Done. 180602 09:29:38 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: /tmp/mysql.sock Using server version 5.7.20 innobackupex version 2.4.11 based on MySQL server 5.7.19 Linux (x86_64) (revision id: b4e0db5) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /data/mysql/data xtrabackup: open files limit requested 0, set to 102400 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . 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 = 50331648 InnoDB: Number of pools: 1 180602 09:29:38 >> log scanned up to (2572994) xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 24 for ops/test, old maximum was 0 180602 09:29:38 [01] Copying ./ibdata1 to /mnt/2018-06-02_09-29-38/ibdata1 180602 09:29:38 [01] ...done 180602 09:29:38 [01] Copying ./ops/test.ibd to /mnt/2018-06-02_09-29-38/ops/test.ibd 180602 09:29:38 [01] ...done 180602 09:29:38 [01] Copying ./mysql/servers.ibd to /mnt/2018-06-02_09-29-38/mysql/servers.ibd 180602 09:29:38 [01] ...done 180602 09:29:38 [01] Copying ./mysql/innodb_index_stats.ibd to /mnt/2018-06-02_09-29-38/mysql/innodb_index_stats.ibd 180602 09:29:38 [01] ...done 180602 09:29:38 [01] Copying ./mysql/time_zone.ibd to /mnt/2018-06-02_09-29-38/mysql/time_zone.ibd 180602 09:29:38 [01] ...done 180602 09:29:38 [01] Copying ./mysql/time_zone_transition_type.ibd to /mnt/2018-06-02_09-29-38/mysql/time_zone_transition_type.ibd 180602 09:29:38 [01] ...done 180602 09:29:38 [01] Copying ./mysql/slave_worker_info.ibd to /mnt/2018-06-02_09-29-38/mysql/slave_worker_info.ibd 180602 09:29:38 [01] ...done 180602 09:29:38 [01] Copying ./mysql/help_keyword.ibd to /mnt/2018-06-02_09-29-38/mysql/help_keyword.ibd 180602 09:29:38 [01] ...done 180602 09:29:38 [01] Copying ./mysql/server_cost.ibd to /mnt/2018-06-02_09-29-38/mysql/server_cost.ibd 180602 09:29:38 [01] ...done 180602 09:29:38 [01] Copying ./mysql/help_topic.ibd to /mnt/2018-06-02_09-29-38/mysql/help_topic.ibd 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./mysql/time_zone_leap_second.ibd to /mnt/2018-06-02_09-29-38/mysql/time_zone_leap_second.ibd 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./mysql/slave_master_info.ibd to /mnt/2018-06-02_09-29-38/mysql/slave_master_info.ibd 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./mysql/help_category.ibd to /mnt/2018-06-02_09-29-38/mysql/help_category.ibd 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./mysql/time_zone_transition.ibd to /mnt/2018-06-02_09-29-38/mysql/time_zone_transition.ibd 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./mysql/gtid_executed.ibd to /mnt/2018-06-02_09-29-38/mysql/gtid_executed.ibd 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./mysql/slave_relay_log_info.ibd to /mnt/2018-06-02_09-29-38/mysql/slave_relay_log_info.ibd 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./mysql/innodb_table_stats.ibd to /mnt/2018-06-02_09-29-38/mysql/innodb_table_stats.ibd 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./mysql/help_relation.ibd to /mnt/2018-06-02_09-29-38/mysql/help_relation.ibd 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./mysql/engine_cost.ibd to /mnt/2018-06-02_09-29-38/mysql/engine_cost.ibd 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./mysql/plugin.ibd to /mnt/2018-06-02_09-29-38/mysql/plugin.ibd 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./mysql/time_zone_name.ibd to /mnt/2018-06-02_09-29-38/mysql/time_zone_name.ibd 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./sys/sys_config.ibd to /mnt/2018-06-02_09-29-38/sys/sys_config.ibd 180602 09:29:39 [01] ...done 180602 09:29:39 >> log scanned up to (2572994) 180602 09:29:39 Executing FLUSH NO_WRITE_TO_BINLOG TABLES... #对于非inonodb引擎的会执行锁表操作 180602 09:29:39 Executing FLUSH TABLES WITH READ LOCK... 180602 09:29:39 Starting to backup non-InnoDB tables and files 180602 09:29:39 [01] Copying ./ops/db.opt to /mnt/2018-06-02_09-29-38/ops/db.opt 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./ops/test.frm to /mnt/2018-06-02_09-29-38/ops/test.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/replication_connection_configuration.frm to /mnt/2018-06-02_09-29-38/performance_schema/replication_connection_configuration.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /mnt/2018-06-02_09-29-38/performance_schema/socket_summary_by_instance.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/file_summary_by_event_name.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/users.frm to /mnt/2018-06-02_09-29-38/performance_schema/users.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_waits_summary_by_user_by_event_name.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/status_by_user.frm to /mnt/2018-06-02_09-29-38/performance_schema/status_by_user.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_statements_summary_by_digest.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/user_variables_by_thread.frm to /mnt/2018-06-02_09-29-38/performance_schema/user_variables_by_thread.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_statements_summary_global_by_event_name.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/setup_timers.frm to /mnt/2018-06-02_09-29-38/performance_schema/setup_timers.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/table_handles.frm to /mnt/2018-06-02_09-29-38/performance_schema/table_handles.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/events_statements_history_long.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_statements_history_long.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/global_variables.frm to /mnt/2018-06-02_09-29-38/performance_schema/global_variables.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/replication_applier_status.frm to /mnt/2018-06-02_09-29-38/performance_schema/replication_applier_status.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /mnt/2018-06-02_09-29-38/performance_schema/session_account_connect_attrs.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/replication_applier_configuration.frm to /mnt/2018-06-02_09-29-38/performance_schema/replication_applier_configuration.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/events_statements_history.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_statements_history.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /mnt/2018-06-02_09-29-38/performance_schema/table_lock_waits_summary_by_table.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/events_transactions_history.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_transactions_history.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/replication_group_members.frm to /mnt/2018-06-02_09-29-38/performance_schema/replication_group_members.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /mnt/2018-06-02_09-29-38/performance_schema/table_io_waits_summary_by_table.frm 180602 09:29:39 [01] ...done 180602 09:29:39 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_statements_summary_by_thread_by_event_name.frm 180602 09:29:39 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/memory_summary_global_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/db.opt to /mnt/2018-06-02_09-29-38/performance_schema/db.opt 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/mutex_instances.frm to /mnt/2018-06-02_09-29-38/performance_schema/mutex_instances.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_transactions_summary_by_user_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/session_connect_attrs.frm to /mnt/2018-06-02_09-29-38/performance_schema/session_connect_attrs.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/session_variables.frm to /mnt/2018-06-02_09-29-38/performance_schema/session_variables.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/status_by_host.frm to /mnt/2018-06-02_09-29-38/performance_schema/status_by_host.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/status_by_account.frm to /mnt/2018-06-02_09-29-38/performance_schema/status_by_account.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/setup_instruments.frm to /mnt/2018-06-02_09-29-38/performance_schema/setup_instruments.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_transactions_summary_by_host_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /mnt/2018-06-02_09-29-38/performance_schema/replication_applier_status_by_coordinator.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_stages_summary_by_thread_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /mnt/2018-06-02_09-29-38/performance_schema/objects_summary_global_by_type.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_transactions_history_long.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_transactions_history_long.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/setup_objects.frm to /mnt/2018-06-02_09-29-38/performance_schema/setup_objects.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/replication_connection_status.frm to /mnt/2018-06-02_09-29-38/performance_schema/replication_connection_status.frm 180602 09:29:40 [01] ...done 180602 09:29:40 >> log scanned up to (2572994) 180602 09:29:40 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/memory_summary_by_user_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_statements_summary_by_program.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/file_instances.frm to /mnt/2018-06-02_09-29-38/performance_schema/file_instances.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/hosts.frm to /mnt/2018-06-02_09-29-38/performance_schema/hosts.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/setup_consumers.frm to /mnt/2018-06-02_09-29-38/performance_schema/setup_consumers.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/replication_group_member_stats.frm to /mnt/2018-06-02_09-29-38/performance_schema/replication_group_member_stats.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/prepared_statements_instances.frm to /mnt/2018-06-02_09-29-38/performance_schema/prepared_statements_instances.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_statements_summary_by_host_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_waits_summary_by_account_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/variables_by_thread.frm to /mnt/2018-06-02_09-29-38/performance_schema/variables_by_thread.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/memory_summary_by_host_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_transactions_summary_by_account_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /mnt/2018-06-02_09-29-38/performance_schema/replication_applier_status_by_worker.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_waits_summary_by_thread_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_waits_current.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_waits_current.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/accounts.frm to /mnt/2018-06-02_09-29-38/performance_schema/accounts.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_transactions_summary_by_thread_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /mnt/2018-06-02_09-29-38/performance_schema/table_io_waits_summary_by_index_usage.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_statements_summary_by_account_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_transactions_current.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_transactions_current.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/metadata_locks.frm to /mnt/2018-06-02_09-29-38/performance_schema/metadata_locks.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_statements_current.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_statements_current.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_stages_summary_by_host_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/socket_instances.frm to /mnt/2018-06-02_09-29-38/performance_schema/socket_instances.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_stages_history_long.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_stages_history_long.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_statements_summary_by_user_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/socket_summary_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/setup_actors.frm to /mnt/2018-06-02_09-29-38/performance_schema/setup_actors.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/rwlock_instances.frm to /mnt/2018-06-02_09-29-38/performance_schema/rwlock_instances.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/host_cache.frm to /mnt/2018-06-02_09-29-38/performance_schema/host_cache.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_stages_current.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_stages_current.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_transactions_summary_global_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/status_by_thread.frm to /mnt/2018-06-02_09-29-38/performance_schema/status_by_thread.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_stages_history.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_stages_history.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_stages_summary_global_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/performance_timers.frm to /mnt/2018-06-02_09-29-38/performance_schema/performance_timers.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_waits_history_long.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_waits_history_long.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/file_summary_by_instance.frm to /mnt/2018-06-02_09-29-38/performance_schema/file_summary_by_instance.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/memory_summary_by_account_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/memory_summary_by_thread_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/cond_instances.frm to /mnt/2018-06-02_09-29-38/performance_schema/cond_instances.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_waits_summary_global_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_waits_summary_by_host_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_waits_summary_by_instance.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_stages_summary_by_user_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_waits_history.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_waits_history.frm 180602 09:29:40 [01] ...done 180602 09:29:40 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /mnt/2018-06-02_09-29-38/performance_schema/events_stages_summary_by_account_by_event_name.frm 180602 09:29:40 [01] ...done 180602 09:29:41 [01] Copying ./performance_schema/threads.frm to /mnt/2018-06-02_09-29-38/performance_schema/threads.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./performance_schema/session_status.frm to /mnt/2018-06-02_09-29-38/performance_schema/session_status.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./performance_schema/global_status.frm to /mnt/2018-06-02_09-29-38/performance_schema/global_status.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/slave_master_info.frm to /mnt/2018-06-02_09-29-38/mysql/slave_master_info.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/procs_priv.frm to /mnt/2018-06-02_09-29-38/mysql/procs_priv.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/columns_priv.MYD to /mnt/2018-06-02_09-29-38/mysql/columns_priv.MYD 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/slow_log.CSV to /mnt/2018-06-02_09-29-38/mysql/slow_log.CSV 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/general_log.CSV to /mnt/2018-06-02_09-29-38/mysql/general_log.CSV 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/db.MYI to /mnt/2018-06-02_09-29-38/mysql/db.MYI 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/proc.frm to /mnt/2018-06-02_09-29-38/mysql/proc.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/ndb_binlog_index.MYI to /mnt/2018-06-02_09-29-38/mysql/ndb_binlog_index.MYI 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/help_relation.frm to /mnt/2018-06-02_09-29-38/mysql/help_relation.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/db.MYD to /mnt/2018-06-02_09-29-38/mysql/db.MYD 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/help_topic.frm to /mnt/2018-06-02_09-29-38/mysql/help_topic.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/func.MYD to /mnt/2018-06-02_09-29-38/mysql/func.MYD 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/columns_priv.frm to /mnt/2018-06-02_09-29-38/mysql/columns_priv.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/proxies_priv.MYD to /mnt/2018-06-02_09-29-38/mysql/proxies_priv.MYD 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/tables_priv.MYI to /mnt/2018-06-02_09-29-38/mysql/tables_priv.MYI 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/time_zone_transition.frm to /mnt/2018-06-02_09-29-38/mysql/time_zone_transition.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/time_zone_leap_second.frm to /mnt/2018-06-02_09-29-38/mysql/time_zone_leap_second.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/help_category.frm to /mnt/2018-06-02_09-29-38/mysql/help_category.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/db.opt to /mnt/2018-06-02_09-29-38/mysql/db.opt 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/event.MYI to /mnt/2018-06-02_09-29-38/mysql/event.MYI 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/procs_priv.MYD to /mnt/2018-06-02_09-29-38/mysql/procs_priv.MYD 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/servers.frm to /mnt/2018-06-02_09-29-38/mysql/servers.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/ndb_binlog_index.MYD to /mnt/2018-06-02_09-29-38/mysql/ndb_binlog_index.MYD 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/tables_priv.MYD to /mnt/2018-06-02_09-29-38/mysql/tables_priv.MYD 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/innodb_index_stats.frm to /mnt/2018-06-02_09-29-38/mysql/innodb_index_stats.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/general_log.CSM to /mnt/2018-06-02_09-29-38/mysql/general_log.CSM 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/proxies_priv.MYI to /mnt/2018-06-02_09-29-38/mysql/proxies_priv.MYI 180602 09:29:41 [01] ...done 180602 09:29:41 >> log scanned up to (2572994) 180602 09:29:41 [01] Copying ./mysql/proc.MYD to /mnt/2018-06-02_09-29-38/mysql/proc.MYD 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/proc.MYI to /mnt/2018-06-02_09-29-38/mysql/proc.MYI 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/time_zone_transition_type.frm to /mnt/2018-06-02_09-29-38/mysql/time_zone_transition_type.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/proxies_priv.frm to /mnt/2018-06-02_09-29-38/mysql/proxies_priv.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/procs_priv.MYI to /mnt/2018-06-02_09-29-38/mysql/procs_priv.MYI 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/slave_worker_info.frm to /mnt/2018-06-02_09-29-38/mysql/slave_worker_info.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/slave_relay_log_info.frm to /mnt/2018-06-02_09-29-38/mysql/slave_relay_log_info.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/columns_priv.MYI to /mnt/2018-06-02_09-29-38/mysql/columns_priv.MYI 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/func.MYI to /mnt/2018-06-02_09-29-38/mysql/func.MYI 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/db.frm to /mnt/2018-06-02_09-29-38/mysql/db.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/tables_priv.frm to /mnt/2018-06-02_09-29-38/mysql/tables_priv.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/time_zone_name.frm to /mnt/2018-06-02_09-29-38/mysql/time_zone_name.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/plugin.frm to /mnt/2018-06-02_09-29-38/mysql/plugin.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/user.MYD to /mnt/2018-06-02_09-29-38/mysql/user.MYD 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/slow_log.frm to /mnt/2018-06-02_09-29-38/mysql/slow_log.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/func.frm to /mnt/2018-06-02_09-29-38/mysql/func.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/event.frm to /mnt/2018-06-02_09-29-38/mysql/event.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/innodb_table_stats.frm to /mnt/2018-06-02_09-29-38/mysql/innodb_table_stats.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/user.MYI to /mnt/2018-06-02_09-29-38/mysql/user.MYI 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/event.MYD to /mnt/2018-06-02_09-29-38/mysql/event.MYD 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/server_cost.frm to /mnt/2018-06-02_09-29-38/mysql/server_cost.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/slow_log.CSM to /mnt/2018-06-02_09-29-38/mysql/slow_log.CSM 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/gtid_executed.frm to /mnt/2018-06-02_09-29-38/mysql/gtid_executed.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/engine_cost.frm to /mnt/2018-06-02_09-29-38/mysql/engine_cost.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/help_keyword.frm to /mnt/2018-06-02_09-29-38/mysql/help_keyword.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/user.frm to /mnt/2018-06-02_09-29-38/mysql/user.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/time_zone.frm to /mnt/2018-06-02_09-29-38/mysql/time_zone.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/ndb_binlog_index.frm to /mnt/2018-06-02_09-29-38/mysql/ndb_binlog_index.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./mysql/general_log.frm to /mnt/2018-06-02_09-29-38/mysql/general_log.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/session_ssl_status.frm to /mnt/2018-06-02_09-29-38/sys/session_ssl_status.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/schema_object_overview.frm to /mnt/2018-06-02_09-29-38/sys/schema_object_overview.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/statements_with_temp_tables.frm to /mnt/2018-06-02_09-29-38/sys/statements_with_temp_tables.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/schema_auto_increment_columns.frm to /mnt/2018-06-02_09-29-38/sys/schema_auto_increment_columns.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /mnt/2018-06-02_09-29-38/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/schema_table_statistics.frm to /mnt/2018-06-02_09-29-38/sys/schema_table_statistics.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/processlist.frm to /mnt/2018-06-02_09-29-38/sys/processlist.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/memory_global_by_current_bytes.frm to /mnt/2018-06-02_09-29-38/sys/memory_global_by_current_bytes.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /mnt/2018-06-02_09-29-38/sys/x@0024host_summary_by_file_io.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/user_summary_by_statement_latency.frm to /mnt/2018-06-02_09-29-38/sys/user_summary_by_statement_latency.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/x@0024statement_analysis.frm to /mnt/2018-06-02_09-29-38/sys/x@0024statement_analysis.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/io_by_thread_by_latency.frm to /mnt/2018-06-02_09-29-38/sys/io_by_thread_by_latency.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/x@0024user_summary.frm to /mnt/2018-06-02_09-29-38/sys/x@0024user_summary.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /mnt/2018-06-02_09-29-38/sys/io_global_by_wait_by_latency.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/metrics.frm to /mnt/2018-06-02_09-29-38/sys/metrics.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /mnt/2018-06-02_09-29-38/sys/x@0024innodb_lock_waits.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /mnt/2018-06-02_09-29-38/sys/x@0024schema_table_lock_waits.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/sys_config_insert_set_user.TRN to /mnt/2018-06-02_09-29-38/sys/sys_config_insert_set_user.TRN 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /mnt/2018-06-02_09-29-38/sys/x@0024memory_global_by_current_bytes.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/x@0024latest_file_io.frm to /mnt/2018-06-02_09-29-38/sys/x@0024latest_file_io.frm 180602 09:29:41 [01] ...done 180602 09:29:41 [01] Copying ./sys/version.frm to /mnt/2018-06-02_09-29-38/sys/version.frm 180602 09:29:41 [01] ...done 180602 09:29:42 [01] Copying ./sys/sys_config.TRG to /mnt/2018-06-02_09-29-38/sys/sys_config.TRG 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /mnt/2018-06-02_09-29-38/sys/x@0024memory_by_host_by_current_bytes.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /mnt/2018-06-02_09-29-38/sys/x@0024waits_global_by_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/host_summary_by_stages.frm to /mnt/2018-06-02_09-29-38/sys/host_summary_by_stages.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /mnt/2018-06-02_09-29-38/sys/x@0024wait_classes_global_by_avg_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/db.opt to /mnt/2018-06-02_09-29-38/sys/db.opt 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/waits_by_user_by_latency.frm to /mnt/2018-06-02_09-29-38/sys/waits_by_user_by_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024statements_with_sorting.frm to /mnt/2018-06-02_09-29-38/sys/x@0024statements_with_sorting.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /mnt/2018-06-02_09-29-38/sys/x@0024user_summary_by_file_io_type.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/host_summary_by_file_io_type.frm to /mnt/2018-06-02_09-29-38/sys/host_summary_by_file_io_type.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /mnt/2018-06-02_09-29-38/sys/x@0024io_global_by_file_by_bytes.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /mnt/2018-06-02_09-29-38/sys/x@0024statements_with_full_table_scans.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/statements_with_full_table_scans.frm to /mnt/2018-06-02_09-29-38/sys/statements_with_full_table_scans.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /mnt/2018-06-02_09-29-38/sys/x@0024host_summary_by_stages.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /mnt/2018-06-02_09-29-38/sys/x@0024host_summary_by_file_io_type.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024schema_index_statistics.frm to /mnt/2018-06-02_09-29-38/sys/x@0024schema_index_statistics.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/waits_by_host_by_latency.frm to /mnt/2018-06-02_09-29-38/sys/waits_by_host_by_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/schema_table_lock_waits.frm to /mnt/2018-06-02_09-29-38/sys/schema_table_lock_waits.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /mnt/2018-06-02_09-29-38/sys/innodb_buffer_stats_by_schema.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/host_summary_by_file_io.frm to /mnt/2018-06-02_09-29-38/sys/host_summary_by_file_io.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/user_summary_by_statement_type.frm to /mnt/2018-06-02_09-29-38/sys/user_summary_by_statement_type.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /mnt/2018-06-02_09-29-38/sys/x@0024ps_digest_avg_latency_distribution.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /mnt/2018-06-02_09-29-38/sys/x@0024user_summary_by_stages.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /mnt/2018-06-02_09-29-38/sys/x@0024statements_with_errors_or_warnings.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /mnt/2018-06-02_09-29-38/sys/x@0024memory_by_user_by_current_bytes.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /mnt/2018-06-02_09-29-38/sys/x@0024statements_with_temp_tables.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/host_summary_by_statement_type.frm to /mnt/2018-06-02_09-29-38/sys/host_summary_by_statement_type.frm 180602 09:29:42 [01] ...done 180602 09:29:42 >> log scanned up to (2572994) 180602 09:29:42 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /mnt/2018-06-02_09-29-38/sys/x@0024host_summary_by_statement_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /mnt/2018-06-02_09-29-38/sys/wait_classes_global_by_avg_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /mnt/2018-06-02_09-29-38/sys/x@0024memory_by_thread_by_current_bytes.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /mnt/2018-06-02_09-29-38/sys/io_global_by_file_by_bytes.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/statements_with_sorting.frm to /mnt/2018-06-02_09-29-38/sys/statements_with_sorting.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/session.frm to /mnt/2018-06-02_09-29-38/sys/session.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/user_summary.frm to /mnt/2018-06-02_09-29-38/sys/user_summary.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/schema_index_statistics.frm to /mnt/2018-06-02_09-29-38/sys/schema_index_statistics.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /mnt/2018-06-02_09-29-38/sys/x@0024user_summary_by_statement_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024host_summary.frm to /mnt/2018-06-02_09-29-38/sys/x@0024host_summary.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/statement_analysis.frm to /mnt/2018-06-02_09-29-38/sys/statement_analysis.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /mnt/2018-06-02_09-29-38/sys/x@0024io_global_by_wait_by_bytes.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /mnt/2018-06-02_09-29-38/sys/io_global_by_wait_by_bytes.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /mnt/2018-06-02_09-29-38/sys/x@0024innodb_buffer_stats_by_schema.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /mnt/2018-06-02_09-29-38/sys/x@0024io_global_by_wait_by_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/io_global_by_file_by_latency.frm to /mnt/2018-06-02_09-29-38/sys/io_global_by_file_by_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /mnt/2018-06-02_09-29-38/sys/x@0024schema_tables_with_full_table_scans.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/wait_classes_global_by_latency.frm to /mnt/2018-06-02_09-29-38/sys/wait_classes_global_by_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /mnt/2018-06-02_09-29-38/sys/memory_by_host_by_current_bytes.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/schema_unused_indexes.frm to /mnt/2018-06-02_09-29-38/sys/schema_unused_indexes.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /mnt/2018-06-02_09-29-38/sys/innodb_buffer_stats_by_table.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /mnt/2018-06-02_09-29-38/sys/x@0024schema_flattened_keys.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/latest_file_io.frm to /mnt/2018-06-02_09-29-38/sys/latest_file_io.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /mnt/2018-06-02_09-29-38/sys/x@0024io_by_thread_by_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/host_summary.frm to /mnt/2018-06-02_09-29-38/sys/host_summary.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /mnt/2018-06-02_09-29-38/sys/schema_table_statistics_with_buffer.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /mnt/2018-06-02_09-29-38/sys/memory_by_thread_by_current_bytes.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /mnt/2018-06-02_09-29-38/sys/statements_with_errors_or_warnings.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /mnt/2018-06-02_09-29-38/sys/x@0024waits_by_host_by_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/schema_redundant_indexes.frm to /mnt/2018-06-02_09-29-38/sys/schema_redundant_indexes.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /mnt/2018-06-02_09-29-38/sys/x@0024schema_table_statistics_with_buffer.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/memory_global_total.frm to /mnt/2018-06-02_09-29-38/sys/memory_global_total.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/user_summary_by_file_io.frm to /mnt/2018-06-02_09-29-38/sys/user_summary_by_file_io.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /mnt/2018-06-02_09-29-38/sys/statements_with_runtimes_in_95th_percentile.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /mnt/2018-06-02_09-29-38/sys/memory_by_user_by_current_bytes.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /mnt/2018-06-02_09-29-38/sys/x@0024ps_schema_table_statistics_io.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/innodb_lock_waits.frm to /mnt/2018-06-02_09-29-38/sys/innodb_lock_waits.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024session.frm to /mnt/2018-06-02_09-29-38/sys/x@0024session.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/sys_config_update_set_user.TRN to /mnt/2018-06-02_09-29-38/sys/sys_config_update_set_user.TRN 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024memory_global_total.frm to /mnt/2018-06-02_09-29-38/sys/x@0024memory_global_total.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /mnt/2018-06-02_09-29-38/sys/ps_check_lost_instrumentation.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/user_summary_by_file_io_type.frm to /mnt/2018-06-02_09-29-38/sys/user_summary_by_file_io_type.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/host_summary_by_statement_latency.frm to /mnt/2018-06-02_09-29-38/sys/host_summary_by_statement_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/sys_config.frm to /mnt/2018-06-02_09-29-38/sys/sys_config.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/user_summary_by_stages.frm to /mnt/2018-06-02_09-29-38/sys/user_summary_by_stages.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /mnt/2018-06-02_09-29-38/sys/x@0024statements_with_runtimes_in_95th_percentile.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /mnt/2018-06-02_09-29-38/sys/x@0024io_global_by_file_by_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /mnt/2018-06-02_09-29-38/sys/x@0024wait_classes_global_by_latency.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024schema_table_statistics.frm to /mnt/2018-06-02_09-29-38/sys/x@0024schema_table_statistics.frm 180602 09:29:42 [01] ...done 180602 09:29:42 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /mnt/2018-06-02_09-29-38/sys/x@0024host_summary_by_statement_type.frm 180602 09:29:42 [01] ...done 180602 09:29:43 [01] Copying ./sys/waits_global_by_latency.frm to /mnt/2018-06-02_09-29-38/sys/waits_global_by_latency.frm 180602 09:29:43 [01] ...done 180602 09:29:43 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /mnt/2018-06-02_09-29-38/sys/x@0024innodb_buffer_stats_by_table.frm 180602 09:29:43 [01] ...done 180602 09:29:43 [01] Copying ./sys/x@0024processlist.frm to /mnt/2018-06-02_09-29-38/sys/x@0024processlist.frm 180602 09:29:43 [01] ...done 180602 09:29:43 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /mnt/2018-06-02_09-29-38/sys/x@0024user_summary_by_file_io.frm 180602 09:29:43 [01] ...done 180602 09:29:43 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /mnt/2018-06-02_09-29-38/sys/schema_tables_with_full_table_scans.frm 180602 09:29:43 [01] ...done 180602 09:29:43 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /mnt/2018-06-02_09-29-38/sys/x@0024user_summary_by_statement_type.frm 180602 09:29:43 [01] ...done 180602 09:29:43 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /mnt/2018-06-02_09-29-38/sys/x@0024waits_by_user_by_latency.frm 180602 09:29:43 [01] ...done 180602 09:29:43 Finished backing up non-InnoDB tables and files 180602 09:29:43 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... xtrabackup: The latest check point (for incremental): '2572985' xtrabackup: Stopping log copying thread. .180602 09:29:43 >> log scanned up to (2572994) 180602 09:29:43 Executing UNLOCK TABLES #解锁操作 180602 09:29:43 All tables unlocked 180602 09:29:43 [00] Copying ib_buffer_pool to /mnt/2018-06-02_09-29-38/ib_buffer_pool 180602 09:29:43 [00] ...done 180602 09:29:43 Backup created in directory '/mnt/2018-06-02_09-29-38/' 180602 09:29:43 [00] Writing /mnt/2018-06-02_09-29-38/backup-my.cnf 180602 09:29:43 [00] ...done 180602 09:29:43 [00] Writing /mnt/2018-06-02_09-29-38/xtrabackup_info 180602 09:29:43 [00] ...done xtrabackup: Transaction log of lsn (2572985) to (2572994) was copied. 180602 09:29:43 completed OK! #看到这个代表备份成功
看看生成的备份
[root@lnmp01 ~]# cd /mnt/2018-06-02_09-29-38/ [root@lnmp01 2018-06-02_09-29-38]# ll total 12332 -rw-r----- 1 root root 487 Jun 2 09:29 backup-my.cnf -rw-r----- 1 root root 325 Jun 2 09:29 ib_buffer_pool -rw-r----- 1 root root 12582912 Jun 2 09:29 ibdata1 drwxr-x--- 2 root root 4096 Jun 2 09:29 mysql drwxr-x--- 2 root root 4096 Jun 2 09:29 ops drwxr-x--- 2 root root 4096 Jun 2 09:29 performance_schema drwxr-x--- 2 root root 12288 Jun 2 09:29 sys -rw-r----- 1 root root 113 Jun 2 09:29 xtrabackup_checkpoints -rw-r----- 1 root root 469 Jun 2 09:29 xtrabackup_info -rw-r----- 1 root root 2560 Jun 2 09:29 xtrabackup_logfile [root@lnmp01 2018-06-02_09-29-38]# cat backup-my.cnf # This MySQL options file was generated by innobackupex. # The MySQL server [mysqld] innodb_checksum_algorithm=crc32 innodb_log_checksum_algorithm=strict_crc32 innodb_data_file_path=ibdata1:12M:autoextend innodb_log_files_in_group=2 innodb_log_file_size=50331648 innodb_fast_checksum=false innodb_page_size=16384 innodb_log_block_size=512 innodb_undo_directory=./ innodb_undo_tablespaces=0 server_id=0 redo_log_version=1 server_uuid=c6d9c875-6601-11e8-bdb0-000c29959431 master_key_id=0 [root@lnmp01 2018-06-02_09-29-38]# cat xtrabackup_info uuid = 6d4129b3-6604-11e8-ae5e-000c29959431 name = tool_name = innobackupex tool_command = --defaults-file=/etc/my.cnf --user=root --password=... --socket=/tmp/mysql.sock /mnt/ tool_version = 2.4.11 ibbackup_version = 2.4.11 server_version = 5.7.20 start_time = 2018-06-02 09:29:38 end_time = 2018-06-02 09:29:43 lock_time = 0 binlog_pos = innodb_from_lsn = 0 innodb_to_lsn = 2572985 #序列号 partial = N incremental = N format = file compact = N compressed = N encrypted = N [root@lnmp01 2018-06-02_09-29-38]# cat xtrabackup_checkpoints backup_type = full-backuped #全备 from_lsn = 0 to_lsn = 2572985 last_lsn = 2572994 compact = 0 recover_binlog_info = 0
上面数据库备份好了,此时我们在数据库新增加数据,模拟数据实时写入
mysql> insert into test(id,name) values(99,'marry99'); Query OK, 1 row affected (0.09 sec) mysql> insert into test(id,name) values(98,'jacky98'); Query OK, 1 row affected (0.01 sec)
创建完备份之后的数据还不能马上用来还原, 需要回滚未提交事务,前滚提交事务,让数据库文件保持一致性。innobackupex 使用--apply-log 来做预备备份,或者叫 prepare
[root@lnmp01 ~]# innobackupex --defaults-file=/etc/my.cnf --user=root --password=123456 --socket=/tmp/mysql.sock --apply-log /mnt/2018-06-02_09-29-38/ 180602 09: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 version 2.4.11 based on MySQL server 5.7.19 Linux (x86_64) (revision id: b4e0db5) xtrabackup: cd to /mnt/2018-06-02_09-29-38/ xtrabackup: This target seems to be not prepared yet. InnoDB: Number of pools: 1 xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(2572985) xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = . xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = . xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: Starting InnoDB instance for recovery. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) InnoDB: PUNCH HOLE support available InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Uses event mutexes InnoDB: GCC builtin __sync_synchronize() is used for memory barrier InnoDB: Compressed tables use zlib 1.2.3 InnoDB: Number of pools: 1 InnoDB: 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: -20 InnoDB: Highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 2572985 InnoDB: Doing recovery: scanned up to log sequence number 2572994 (0%) InnoDB: Database was not shutdown normally! InnoDB: Starting crash recovery. InnoDB: Creating shared tablespace for temporary tables InnoDB: 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.19 started; log sequence number 2572994 xtrabackup: starting shutdown with innodb_fast_shutdown = 1 InnoDB: FTS optimize thread exiting. InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 2573091 InnoDB: Number of pools: 1 xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . 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 = 50331648 InnoDB: PUNCH HOLE support available InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Uses event mutexes InnoDB: GCC builtin __sync_synchronize() is used for memory barrier InnoDB: Compressed tables use zlib 1.2.3 InnoDB: Number of pools: 1 InnoDB: 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: -20 InnoDB: Setting log file ./ib_logfile101 size to 48 MB InnoDB: Setting log file ./ib_logfile1 size to 48 MB InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 InnoDB: New log files created, LSN=2573091 InnoDB: Highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 2573324 InnoDB: Doing recovery: scanned up to log sequence number 2573333 (0%) InnoDB: Database was not shutdown normally! InnoDB: Starting crash recovery. InnoDB: Removed temporary tablespace data file: "ibtmp1" InnoDB: Creating shared tablespace for temporary tables InnoDB: 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.19 started; log sequence number 2573333 xtrabackup: starting shutdown with innodb_fast_shutdown = 1 InnoDB: FTS optimize thread exiting. InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 2573352 180602 09:53:56 completed OK!
成功后则会输出
InnoDB: Shutdown completed; log sequence number 2573352
180602 09:53:56 completed OK!
成功后,备份可以被用来还原数据库了。
prepare 的过程,其实是读取备份文件夹中的配置文件,然后 innobackupex 重做已提交
事务,回滚未提交事务,之后数据就被写到了备份的数据文件(innodb 文件)中,并重建日志 文件
--user-memory:指定 prepare 阶段可使用的内存,内存多则速度快,默认为 10MB
恢复数据库
使用 innobackupex --copy-back 来还原备份( recovery)
mysql> drop database ops; #模拟数据丢失,删除数据库ops Query OK, 1 row affected (0.01 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.00 sec)
[root@lnmp01 mysql]# /etc/init.d/mysqld stop
Shutting down MySQL.. SUCCESS!
[root@lnmp01 mysql]# mv data data.old
[root@lnmp01 mysql]# ll
total 84
-rw-r--r-- 1 root root 17987 Sep 13 2017 COPYING
-rw-r--r-- 1 root root 17987 Sep 13 2017 COPYING-test
-rw-r--r-- 1 root root 2478 Sep 13 2017 README
-rw-r--r-- 1 root root 2478 Sep 13 2017 README-test
drwxr-xr-x 2 root root 4096 Jun 2 09:01 bin
drwxr-x--- 5 mysql mysql 4096 Jun 2 10:05 data.old
drwxr-xr-x 2 root root 4096 Jun 2 09:00 docs
drwxr-xr-x 3 root root 4096 Jun 2 09:00 include
drwxr-xr-x 4 root root 4096 Jun 2 09:01 lib
drwxr-xr-x 4 root root 4096 Jun 2 09:00 man
drwxr-xr-x 10 root root 4096 Jun 2 09:02 mysql-test
drwxr-xr-x 28 root root 4096 Jun 2 09:02 share
drwxr-xr-x 2 root root 4096 Jun 2 09:02 support-files
注: datadir 必须是为空的, innobackupex --copy-back 不会覆盖已存在的文件,还要注意,
还原时需要先关闭服务,如果服务是启动的,那么就不能还原到 datadir。
[root@lnmp01 mysql]# innobackupex --defaults-file=/etc/my.cnf --user=root --password=123456 --socket=/tmp/mysql.sock --copy-back /mnt/2018-06-02_09-29-38/ 180602 10:06:52 innobackupex: Starting the copy-back operation IMPORTANT: Please check that the copy-back run completes successfully. At the end of a successful copy-back run innobackupex prints "completed OK!". innobackupex version 2.4.11 based on MySQL server 5.7.19 Linux (x86_64) (revision id: b4e0db5) 180602 10:06:52 [01] Copying ib_logfile0 to /data/mysql/data/ib_logfile0 180602 10:06:52 [01] ...done 180602 10:06:52 [01] Copying ib_logfile1 to /data/mysql/data/ib_logfile1 180602 10:06:53 [01] ...done 180602 10:06:53 [01] Copying ibdata1 to /data/mysql/data/ibdata1 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./ops/test.ibd to /data/mysql/data/ops/test.ibd 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./ops/db.opt to /data/mysql/data/ops/db.opt 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./ops/test.frm to /data/mysql/data/ops/test.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/replication_connection_configuration.frm to /data/mysql/data/performance_schema/replication_connection_configuration.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /data/mysql/data/performance_schema/socket_summary_by_instance.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /data/mysql/data/performance_schema/file_summary_by_event_name.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/users.frm to /data/mysql/data/performance_schema/users.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /data/mysql/data/performance_schema/events_waits_summary_by_user_by_event_name.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/status_by_user.frm to /data/mysql/data/performance_schema/status_by_user.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /data/mysql/data/performance_schema/events_statements_summary_by_digest.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/user_variables_by_thread.frm to /data/mysql/data/performance_schema/user_variables_by_thread.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /data/mysql/data/performance_schema/events_statements_summary_global_by_event_name.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/setup_timers.frm to /data/mysql/data/performance_schema/setup_timers.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/table_handles.frm to /data/mysql/data/performance_schema/table_handles.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_statements_history_long.frm to /data/mysql/data/performance_schema/events_statements_history_long.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/global_variables.frm to /data/mysql/data/performance_schema/global_variables.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/replication_applier_status.frm to /data/mysql/data/performance_schema/replication_applier_status.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /data/mysql/data/performance_schema/session_account_connect_attrs.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/replication_applier_configuration.frm to /data/mysql/data/performance_schema/replication_applier_configuration.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_statements_history.frm to /data/mysql/data/performance_schema/events_statements_history.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /data/mysql/data/performance_schema/table_lock_waits_summary_by_table.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_transactions_history.frm to /data/mysql/data/performance_schema/events_transactions_history.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/replication_group_members.frm to /data/mysql/data/performance_schema/replication_group_members.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /data/mysql/data/performance_schema/table_io_waits_summary_by_table.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /data/mysql/data/performance_schema/events_statements_summary_by_thread_by_event_name.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /data/mysql/data/performance_schema/memory_summary_global_by_event_name.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/db.opt to /data/mysql/data/performance_schema/db.opt 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/mutex_instances.frm to /data/mysql/data/performance_schema/mutex_instances.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /data/mysql/data/performance_schema/events_transactions_summary_by_user_by_event_name.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/session_connect_attrs.frm to /data/mysql/data/performance_schema/session_connect_attrs.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/session_variables.frm to /data/mysql/data/performance_schema/session_variables.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/status_by_host.frm to /data/mysql/data/performance_schema/status_by_host.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/status_by_account.frm to /data/mysql/data/performance_schema/status_by_account.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/setup_instruments.frm to /data/mysql/data/performance_schema/setup_instruments.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /data/mysql/data/performance_schema/events_transactions_summary_by_host_by_event_name.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /data/mysql/data/performance_schema/replication_applier_status_by_coordinator.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /data/mysql/data/performance_schema/events_stages_summary_by_thread_by_event_name.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /data/mysql/data/performance_schema/objects_summary_global_by_type.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_transactions_history_long.frm to /data/mysql/data/performance_schema/events_transactions_history_long.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/setup_objects.frm to /data/mysql/data/performance_schema/setup_objects.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/replication_connection_status.frm to /data/mysql/data/performance_schema/replication_connection_status.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /data/mysql/data/performance_schema/memory_summary_by_user_by_event_name.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /data/mysql/data/performance_schema/events_statements_summary_by_program.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/file_instances.frm to /data/mysql/data/performance_schema/file_instances.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/hosts.frm to /data/mysql/data/performance_schema/hosts.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/setup_consumers.frm to /data/mysql/data/performance_schema/setup_consumers.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/replication_group_member_stats.frm to /data/mysql/data/performance_schema/replication_group_member_stats.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/prepared_statements_instances.frm to /data/mysql/data/performance_schema/prepared_statements_instances.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /data/mysql/data/performance_schema/events_statements_summary_by_host_by_event_name.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /data/mysql/data/performance_schema/events_waits_summary_by_account_by_event_name.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/variables_by_thread.frm to /data/mysql/data/performance_schema/variables_by_thread.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /data/mysql/data/performance_schema/memory_summary_by_host_by_event_name.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /data/mysql/data/performance_schema/events_transactions_summary_by_account_by_event_name.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /data/mysql/data/performance_schema/replication_applier_status_by_worker.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /data/mysql/data/performance_schema/events_waits_summary_by_thread_by_event_name.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/events_waits_current.frm to /data/mysql/data/performance_schema/events_waits_current.frm 180602 10:06:54 [01] ...done 180602 10:06:54 [01] Copying ./performance_schema/accounts.frm to /data/mysql/data/performance_schema/accounts.frm 180602 10:06:54 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /data/mysql/data/performance_schema/events_transactions_summary_by_thread_by_event_name.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /data/mysql/data/performance_schema/table_io_waits_summary_by_index_usage.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /data/mysql/data/performance_schema/events_statements_summary_by_account_by_event_name.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_transactions_current.frm to /data/mysql/data/performance_schema/events_transactions_current.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/metadata_locks.frm to /data/mysql/data/performance_schema/metadata_locks.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_statements_current.frm to /data/mysql/data/performance_schema/events_statements_current.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /data/mysql/data/performance_schema/events_stages_summary_by_host_by_event_name.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/socket_instances.frm to /data/mysql/data/performance_schema/socket_instances.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_stages_history_long.frm to /data/mysql/data/performance_schema/events_stages_history_long.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /data/mysql/data/performance_schema/events_statements_summary_by_user_by_event_name.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /data/mysql/data/performance_schema/socket_summary_by_event_name.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/setup_actors.frm to /data/mysql/data/performance_schema/setup_actors.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/rwlock_instances.frm to /data/mysql/data/performance_schema/rwlock_instances.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/host_cache.frm to /data/mysql/data/performance_schema/host_cache.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_stages_current.frm to /data/mysql/data/performance_schema/events_stages_current.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /data/mysql/data/performance_schema/events_transactions_summary_global_by_event_name.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/status_by_thread.frm to /data/mysql/data/performance_schema/status_by_thread.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_stages_history.frm to /data/mysql/data/performance_schema/events_stages_history.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /data/mysql/data/performance_schema/events_stages_summary_global_by_event_name.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/performance_timers.frm to /data/mysql/data/performance_schema/performance_timers.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_waits_history_long.frm to /data/mysql/data/performance_schema/events_waits_history_long.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/file_summary_by_instance.frm to /data/mysql/data/performance_schema/file_summary_by_instance.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /data/mysql/data/performance_schema/memory_summary_by_account_by_event_name.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /data/mysql/data/performance_schema/memory_summary_by_thread_by_event_name.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/cond_instances.frm to /data/mysql/data/performance_schema/cond_instances.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /data/mysql/data/performance_schema/events_waits_summary_global_by_event_name.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /data/mysql/data/performance_schema/events_waits_summary_by_host_by_event_name.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /data/mysql/data/performance_schema/events_waits_summary_by_instance.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /data/mysql/data/performance_schema/events_stages_summary_by_user_by_event_name.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_waits_history.frm to /data/mysql/data/performance_schema/events_waits_history.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /data/mysql/data/performance_schema/events_stages_summary_by_account_by_event_name.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/threads.frm to /data/mysql/data/performance_schema/threads.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/session_status.frm to /data/mysql/data/performance_schema/session_status.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./performance_schema/global_status.frm to /data/mysql/data/performance_schema/global_status.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/slave_master_info.frm to /data/mysql/data/mysql/slave_master_info.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/procs_priv.frm to /data/mysql/data/mysql/procs_priv.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/servers.ibd to /data/mysql/data/mysql/servers.ibd 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/innodb_index_stats.ibd to /data/mysql/data/mysql/innodb_index_stats.ibd 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/columns_priv.MYD to /data/mysql/data/mysql/columns_priv.MYD 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/slow_log.CSV to /data/mysql/data/mysql/slow_log.CSV 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/general_log.CSV to /data/mysql/data/mysql/general_log.CSV 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/db.MYI to /data/mysql/data/mysql/db.MYI 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/proc.frm to /data/mysql/data/mysql/proc.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/ndb_binlog_index.MYI to /data/mysql/data/mysql/ndb_binlog_index.MYI 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/time_zone.ibd to /data/mysql/data/mysql/time_zone.ibd 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/help_relation.frm to /data/mysql/data/mysql/help_relation.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/db.MYD to /data/mysql/data/mysql/db.MYD 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/help_topic.frm to /data/mysql/data/mysql/help_topic.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/func.MYD to /data/mysql/data/mysql/func.MYD 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/columns_priv.frm to /data/mysql/data/mysql/columns_priv.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/time_zone_transition_type.ibd to /data/mysql/data/mysql/time_zone_transition_type.ibd 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/slave_worker_info.ibd to /data/mysql/data/mysql/slave_worker_info.ibd 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/proxies_priv.MYD to /data/mysql/data/mysql/proxies_priv.MYD 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/tables_priv.MYI to /data/mysql/data/mysql/tables_priv.MYI 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/time_zone_transition.frm to /data/mysql/data/mysql/time_zone_transition.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/help_keyword.ibd to /data/mysql/data/mysql/help_keyword.ibd 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/time_zone_leap_second.frm to /data/mysql/data/mysql/time_zone_leap_second.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/server_cost.ibd to /data/mysql/data/mysql/server_cost.ibd 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/help_category.frm to /data/mysql/data/mysql/help_category.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/db.opt to /data/mysql/data/mysql/db.opt 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/help_topic.ibd to /data/mysql/data/mysql/help_topic.ibd 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/time_zone_leap_second.ibd to /data/mysql/data/mysql/time_zone_leap_second.ibd 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/event.MYI to /data/mysql/data/mysql/event.MYI 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/procs_priv.MYD to /data/mysql/data/mysql/procs_priv.MYD 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/slave_master_info.ibd to /data/mysql/data/mysql/slave_master_info.ibd 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/servers.frm to /data/mysql/data/mysql/servers.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/ndb_binlog_index.MYD to /data/mysql/data/mysql/ndb_binlog_index.MYD 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/tables_priv.MYD to /data/mysql/data/mysql/tables_priv.MYD 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/innodb_index_stats.frm to /data/mysql/data/mysql/innodb_index_stats.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/general_log.CSM to /data/mysql/data/mysql/general_log.CSM 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/proxies_priv.MYI to /data/mysql/data/mysql/proxies_priv.MYI 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/proc.MYD to /data/mysql/data/mysql/proc.MYD 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/proc.MYI to /data/mysql/data/mysql/proc.MYI 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/time_zone_transition_type.frm to /data/mysql/data/mysql/time_zone_transition_type.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/proxies_priv.frm to /data/mysql/data/mysql/proxies_priv.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/procs_priv.MYI to /data/mysql/data/mysql/procs_priv.MYI 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/slave_worker_info.frm to /data/mysql/data/mysql/slave_worker_info.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/slave_relay_log_info.frm to /data/mysql/data/mysql/slave_relay_log_info.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/columns_priv.MYI to /data/mysql/data/mysql/columns_priv.MYI 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/func.MYI to /data/mysql/data/mysql/func.MYI 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/help_category.ibd to /data/mysql/data/mysql/help_category.ibd 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/db.frm to /data/mysql/data/mysql/db.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/tables_priv.frm to /data/mysql/data/mysql/tables_priv.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/time_zone_name.frm to /data/mysql/data/mysql/time_zone_name.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/plugin.frm to /data/mysql/data/mysql/plugin.frm 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/time_zone_transition.ibd to /data/mysql/data/mysql/time_zone_transition.ibd 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/user.MYD to /data/mysql/data/mysql/user.MYD 180602 10:06:55 [01] ...done 180602 10:06:55 [01] Copying ./mysql/gtid_executed.ibd to /data/mysql/data/mysql/gtid_executed.ibd 180602 10:06:55 [01] ...done 180602 10:06:56 [01] Copying ./mysql/slow_log.frm to /data/mysql/data/mysql/slow_log.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/slave_relay_log_info.ibd to /data/mysql/data/mysql/slave_relay_log_info.ibd 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/func.frm to /data/mysql/data/mysql/func.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/innodb_table_stats.ibd to /data/mysql/data/mysql/innodb_table_stats.ibd 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/event.frm to /data/mysql/data/mysql/event.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/help_relation.ibd to /data/mysql/data/mysql/help_relation.ibd 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/innodb_table_stats.frm to /data/mysql/data/mysql/innodb_table_stats.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/user.MYI to /data/mysql/data/mysql/user.MYI 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/event.MYD to /data/mysql/data/mysql/event.MYD 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/server_cost.frm to /data/mysql/data/mysql/server_cost.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/slow_log.CSM to /data/mysql/data/mysql/slow_log.CSM 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/gtid_executed.frm to /data/mysql/data/mysql/gtid_executed.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/engine_cost.frm to /data/mysql/data/mysql/engine_cost.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/help_keyword.frm to /data/mysql/data/mysql/help_keyword.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/user.frm to /data/mysql/data/mysql/user.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/engine_cost.ibd to /data/mysql/data/mysql/engine_cost.ibd 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/time_zone.frm to /data/mysql/data/mysql/time_zone.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/ndb_binlog_index.frm to /data/mysql/data/mysql/ndb_binlog_index.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/plugin.ibd to /data/mysql/data/mysql/plugin.ibd 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/time_zone_name.ibd to /data/mysql/data/mysql/time_zone_name.ibd 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./mysql/general_log.frm to /data/mysql/data/mysql/general_log.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./xtrabackup_info to /data/mysql/data/xtrabackup_info 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./ibtmp1 to /data/mysql/data/ibtmp1 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/session_ssl_status.frm to /data/mysql/data/sys/session_ssl_status.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/schema_object_overview.frm to /data/mysql/data/sys/schema_object_overview.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/statements_with_temp_tables.frm to /data/mysql/data/sys/statements_with_temp_tables.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/schema_auto_increment_columns.frm to /data/mysql/data/sys/schema_auto_increment_columns.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /data/mysql/data/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/schema_table_statistics.frm to /data/mysql/data/sys/schema_table_statistics.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/processlist.frm to /data/mysql/data/sys/processlist.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/memory_global_by_current_bytes.frm to /data/mysql/data/sys/memory_global_by_current_bytes.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /data/mysql/data/sys/x@0024host_summary_by_file_io.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/user_summary_by_statement_latency.frm to /data/mysql/data/sys/user_summary_by_statement_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024statement_analysis.frm to /data/mysql/data/sys/x@0024statement_analysis.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/io_by_thread_by_latency.frm to /data/mysql/data/sys/io_by_thread_by_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024user_summary.frm to /data/mysql/data/sys/x@0024user_summary.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /data/mysql/data/sys/io_global_by_wait_by_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/metrics.frm to /data/mysql/data/sys/metrics.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /data/mysql/data/sys/x@0024innodb_lock_waits.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /data/mysql/data/sys/x@0024schema_table_lock_waits.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/sys_config_insert_set_user.TRN to /data/mysql/data/sys/sys_config_insert_set_user.TRN 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /data/mysql/data/sys/x@0024memory_global_by_current_bytes.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024latest_file_io.frm to /data/mysql/data/sys/x@0024latest_file_io.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/version.frm to /data/mysql/data/sys/version.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/sys_config.TRG to /data/mysql/data/sys/sys_config.TRG 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /data/mysql/data/sys/x@0024memory_by_host_by_current_bytes.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /data/mysql/data/sys/x@0024waits_global_by_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/host_summary_by_stages.frm to /data/mysql/data/sys/host_summary_by_stages.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /data/mysql/data/sys/x@0024wait_classes_global_by_avg_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/db.opt to /data/mysql/data/sys/db.opt 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/waits_by_user_by_latency.frm to /data/mysql/data/sys/waits_by_user_by_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024statements_with_sorting.frm to /data/mysql/data/sys/x@0024statements_with_sorting.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /data/mysql/data/sys/x@0024user_summary_by_file_io_type.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/host_summary_by_file_io_type.frm to /data/mysql/data/sys/host_summary_by_file_io_type.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /data/mysql/data/sys/x@0024io_global_by_file_by_bytes.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /data/mysql/data/sys/x@0024statements_with_full_table_scans.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/statements_with_full_table_scans.frm to /data/mysql/data/sys/statements_with_full_table_scans.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /data/mysql/data/sys/x@0024host_summary_by_stages.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /data/mysql/data/sys/x@0024host_summary_by_file_io_type.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024schema_index_statistics.frm to /data/mysql/data/sys/x@0024schema_index_statistics.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/waits_by_host_by_latency.frm to /data/mysql/data/sys/waits_by_host_by_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/schema_table_lock_waits.frm to /data/mysql/data/sys/schema_table_lock_waits.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /data/mysql/data/sys/innodb_buffer_stats_by_schema.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/host_summary_by_file_io.frm to /data/mysql/data/sys/host_summary_by_file_io.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/user_summary_by_statement_type.frm to /data/mysql/data/sys/user_summary_by_statement_type.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /data/mysql/data/sys/x@0024ps_digest_avg_latency_distribution.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /data/mysql/data/sys/x@0024user_summary_by_stages.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /data/mysql/data/sys/x@0024statements_with_errors_or_warnings.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /data/mysql/data/sys/x@0024memory_by_user_by_current_bytes.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /data/mysql/data/sys/x@0024statements_with_temp_tables.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/host_summary_by_statement_type.frm to /data/mysql/data/sys/host_summary_by_statement_type.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /data/mysql/data/sys/x@0024host_summary_by_statement_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /data/mysql/data/sys/wait_classes_global_by_avg_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /data/mysql/data/sys/x@0024memory_by_thread_by_current_bytes.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /data/mysql/data/sys/io_global_by_file_by_bytes.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/statements_with_sorting.frm to /data/mysql/data/sys/statements_with_sorting.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/session.frm to /data/mysql/data/sys/session.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/user_summary.frm to /data/mysql/data/sys/user_summary.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/schema_index_statistics.frm to /data/mysql/data/sys/schema_index_statistics.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /data/mysql/data/sys/x@0024user_summary_by_statement_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024host_summary.frm to /data/mysql/data/sys/x@0024host_summary.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/statement_analysis.frm to /data/mysql/data/sys/statement_analysis.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /data/mysql/data/sys/x@0024io_global_by_wait_by_bytes.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /data/mysql/data/sys/io_global_by_wait_by_bytes.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /data/mysql/data/sys/x@0024innodb_buffer_stats_by_schema.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /data/mysql/data/sys/x@0024io_global_by_wait_by_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/io_global_by_file_by_latency.frm to /data/mysql/data/sys/io_global_by_file_by_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /data/mysql/data/sys/x@0024schema_tables_with_full_table_scans.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/wait_classes_global_by_latency.frm to /data/mysql/data/sys/wait_classes_global_by_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /data/mysql/data/sys/memory_by_host_by_current_bytes.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/schema_unused_indexes.frm to /data/mysql/data/sys/schema_unused_indexes.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /data/mysql/data/sys/innodb_buffer_stats_by_table.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /data/mysql/data/sys/x@0024schema_flattened_keys.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/latest_file_io.frm to /data/mysql/data/sys/latest_file_io.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /data/mysql/data/sys/x@0024io_by_thread_by_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/host_summary.frm to /data/mysql/data/sys/host_summary.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /data/mysql/data/sys/schema_table_statistics_with_buffer.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /data/mysql/data/sys/memory_by_thread_by_current_bytes.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /data/mysql/data/sys/statements_with_errors_or_warnings.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /data/mysql/data/sys/x@0024waits_by_host_by_latency.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/schema_redundant_indexes.frm to /data/mysql/data/sys/schema_redundant_indexes.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /data/mysql/data/sys/x@0024schema_table_statistics_with_buffer.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/memory_global_total.frm to /data/mysql/data/sys/memory_global_total.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/user_summary_by_file_io.frm to /data/mysql/data/sys/user_summary_by_file_io.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /data/mysql/data/sys/statements_with_runtimes_in_95th_percentile.frm 180602 10:06:56 [01] ...done 180602 10:06:56 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /data/mysql/data/sys/memory_by_user_by_current_bytes.frm 180602 10:06:56 [01] ...done 180602 10:06:57 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /data/mysql/data/sys/x@0024ps_schema_table_statistics_io.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/innodb_lock_waits.frm to /data/mysql/data/sys/innodb_lock_waits.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/x@0024session.frm to /data/mysql/data/sys/x@0024session.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/sys_config_update_set_user.TRN to /data/mysql/data/sys/sys_config_update_set_user.TRN 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/x@0024memory_global_total.frm to /data/mysql/data/sys/x@0024memory_global_total.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /data/mysql/data/sys/ps_check_lost_instrumentation.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/user_summary_by_file_io_type.frm to /data/mysql/data/sys/user_summary_by_file_io_type.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/host_summary_by_statement_latency.frm to /data/mysql/data/sys/host_summary_by_statement_latency.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/sys_config.frm to /data/mysql/data/sys/sys_config.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/user_summary_by_stages.frm to /data/mysql/data/sys/user_summary_by_stages.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /data/mysql/data/sys/x@0024statements_with_runtimes_in_95th_percentile.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /data/mysql/data/sys/x@0024io_global_by_file_by_latency.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /data/mysql/data/sys/x@0024wait_classes_global_by_latency.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/x@0024schema_table_statistics.frm to /data/mysql/data/sys/x@0024schema_table_statistics.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/sys_config.ibd to /data/mysql/data/sys/sys_config.ibd 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /data/mysql/data/sys/x@0024host_summary_by_statement_type.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/waits_global_by_latency.frm to /data/mysql/data/sys/waits_global_by_latency.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /data/mysql/data/sys/x@0024innodb_buffer_stats_by_table.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/x@0024processlist.frm to /data/mysql/data/sys/x@0024processlist.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /data/mysql/data/sys/x@0024user_summary_by_file_io.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /data/mysql/data/sys/schema_tables_with_full_table_scans.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /data/mysql/data/sys/x@0024user_summary_by_statement_type.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /data/mysql/data/sys/x@0024waits_by_user_by_latency.frm 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./xtrabackup_master_key_id to /data/mysql/data/xtrabackup_master_key_id 180602 10:06:57 [01] ...done 180602 10:06:57 [01] Copying ./ib_buffer_pool to /data/mysql/data/ib_buffer_pool 180602 10:06:57 [01] ...done 180602 10:06:57 completed OK!
innobackupex 会根据 my.cnf 的配置,将所有备份数据复制到 my.cnf 里面指定的 datadir 路径
下。
如果恢复成功,最后会有如下提示:
180602 10:06:57 [01] ...done
180602 10:06:57 completed OK!
默认情况下是通过 root 用户恢复的数据,所以 mysql 数据文件夹目录是 root 权限,需
要修改文件的所有者和权限
[root@lnmp01 mysql]# pwd /data/mysql [root@lnmp01 mysql]# ll total 88 -rw-r--r-- 1 root root 17987 Sep 13 2017 COPYING -rw-r--r-- 1 root root 17987 Sep 13 2017 COPYING-test -rw-r--r-- 1 root root 2478 Sep 13 2017 README -rw-r--r-- 1 root root 2478 Sep 13 2017 README-test drwxr-xr-x 2 root root 4096 Jun 2 09:01 bin drwxr-x--- 6 root root 4096 Jun 2 10:06 data drwxr-x--- 5 mysql mysql 4096 Jun 2 10:05 data.old drwxr-xr-x 2 root root 4096 Jun 2 09:00 docs drwxr-xr-x 3 root root 4096 Jun 2 09:00 include drwxr-xr-x 4 root root 4096 Jun 2 09:01 lib drwxr-xr-x 4 root root 4096 Jun 2 09:00 man drwxr-xr-x 10 root root 4096 Jun 2 09:02 mysql-test drwxr-xr-x 28 root root 4096 Jun 2 09:02 share drwxr-xr-x 2 root root 4096 Jun 2 09:02 support-files [root@lnmp01 mysql]# chown -R mysql.mysql data