原文:
MySQL物理物理备份与还原工具xtraBackup

（一）xtraBackup简介

xtraBackup是Percona公司开发的一款MySQL数据库备份软件，在备份模式中属于物理备份。其显著特点是开源、免费、备份执行过程中不会阻塞事物、备份可压缩、支持全备和增量备份。

（二）下载安装xtraBackup工具

xtraBackup并没有随着MySQL安装包一起下载，需要单独到percona官网下载。注意，最新版的Percona XtraBackup 8.0不适用于MySQL 8.0以前的版本，我的数据库是MySQL5.7，因此下载2.4版本。

（2.1）离线安装

大部分公司服务器都不连接外网，离线安装是使用最多的方式。xtraBackup rpm包下载地址为：https://www.percona.com/downloads/Percona-XtraBackup-2.4/LATEST/。以下过程是在断网情况下执行的。

STEP1：将rpm安装包传到服务器上

[root@mysqlserver ~]# ls -l |grep percona-rw-r--r-- 1 root root 7935884 Feb 11 16:19 percona-xtrabackup-24-2.4.18-1.el7.x86_64.rpm

STEP2：安装rpm包，这里不要使用rpm -ivh去安装，因为该安装包需要其他依赖包，直接使用yum解决依赖问题

[root@mysqlserver ~]# yum install -y percona-xtrabackup-24-2.4.18-1.el7.x86_64.rpm

STEP3：确认安装结果

[root@mysqlserver ~]# which xtrabackup/usr/bin/xtrabackup[root@mysqlserver ~]# which innobackupex/usr/bin/innobackupex

（2.2）在线安装

如果机器联网，可以直接使用yum源安装，这里以centos7服务器为例。

STEP1:安装xtraBackup的yum源

[root@mysqlserver /root]# yum install -y https://repo.percona.com/yum/percona-release-latest.noarch.rpm

STEP2：确认xtrabackup安装包（可跳过）

[root@mysqlserver /root]# yum list | grep percona...percona-xtrabackup-22-debuginfo.x86_64 2.2.13-1.el7 percona-release-x86_64percona-xtrabackup-24.x86_64 2.4.18-1.el7 percona-release-x86_64percona-xtrabackup-24-debuginfo.x86_64 2.4.18-1.el7 percona-release-x86_64percona-xtrabackup-80.x86_64 8.0.9-1.el7 percona-release-x86_64percona-xtrabackup-80-debuginfo.x86_64 8.0.9-1.el7 percona-release-x86_64percona-xtrabackup-debuginfo.x86_64 2.3.10-1.el7 percona-release-x86_64percona-xtrabackup-test.x86_64 2.3.10-1.el7 percona-release-x86_64percona-xtrabackup-test-22.x86_64 2.2.13-1.el7 percona-release-x86_64percona-xtrabackup-test-24.x86_64 2.4.18-1.el7 percona-release-x86_64percona-xtrabackup-test-80.x86_64 8.0.9-1.el7 percona-release-x86_64percona-zabbix-templates.noarch 1.1.8-1 percona-release-noarch...

STEP3：安装xtraBackup

[root@mysqlserver /root]# yum install -y percona-xtrabackup-24

STEP4：确认安装结果

[root@mysqlserver /root]# which xtrabackup/usr/bin/xtrabackup[root@mysqlserver /root]# which innobackupex/usr/bin/innobackupex

xtraBackup包含2个主要的工具：xtrabackup和innobackupex。两者区别如下：

• xtrbackup只能备份innodb和xtradb引擎的表，对于其他引擎的表则无能为力，包括MYISAM。
• innobackupex是一个封装了xtrbackup的Perl脚本，除了支持xtrabackup工具可以备份的表以外，还支持MYISAM、CSV、memory(仅表结构)等，比xtrabackup强大。

因为innobackupex工具更为强大，所以后续直接使用innobackupex来执行备份和恢复。

（三）使用innobackupex备份数据库

innobackupex支持全备和增量备份，对于该工具的用法，可以直接使用“--help”命令查看

[root@mysqlserver ~]# innobackupex --help

（3.1）使用innobackupex来执行全备

执行全备的命令如下：

[root@mysqlserver ~]# innobackupex --user=root --password=‘123456‘ --default-file=‘/etc/my.cnf‘ /backup 

 参数信息：

--user                  ：连接数据库使用的用户名

--password          ：连接数据库使用的密码

--default-file         ：指出MySQL的参数配置文件路径

[backup_dir]        ：备份集存放地址

innobackupex备份执行过程如下：

[root@mysqlserver ~]# innobackupex --user=root --password=‘123456‘ --default-file=‘/etc/my.cnf‘ /backup xtrabackup: recognized server arguments: --datadir=/usr/local/mysql/data xtrabackup: recognized client arguments: 200211 16:42:47 innobackupex: Starting the backup operationIMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!".200211 16:42:47 version_check Connecting to MySQL server with DSN ‘dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/tmp/mysql.soc‘ as ‘root‘ (using password: YES).200211 16:42:47 version_check Connected to MySQL server200211 16:42:47 version_check Executing a version check against the server...200211 16:42:47 version_check Done.200211 16:42:47 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: /tmp/mysql.socUsing server version 5.7.27innobackupex version 2.4.18 based on MySQL server 5.7.26 Linux (x86_64) (revision id: 29b4ca5)xtrabackup: uses posix_fadvise().xtrabackup: cd to /usr/local/mysql/dataxtrabackup: open files limit requested 0, set to 1024xtrabackup: using the following InnoDB configuration:xtrabackup: innodb_data_home_dir = .xtrabackup: innodb_data_file_path = ibdata1:12M:autoextendxtrabackup: innodb_log_group_home_dir = ./xtrabackup: innodb_log_files_in_group = 2xtrabackup: innodb_log_file_size = 50331648InnoDB: Number of pools: 1200211 16:42:47 >> log scanned up to (2625691)xtrabackup: Generating a list of tablespacesInnoDB: Allocated tablespace ID 2 for mysql/plugin, old maximum was 0200211 16:42:47 [01] Copying ./ibdata1 to /backup/2020-02-11_16-42-47/ibdata1200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/plugin.ibd to /backup/2020-02-11_16-42-47/mysql/plugin.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/servers.ibd to /backup/2020-02-11_16-42-47/mysql/servers.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/help_topic.ibd to /backup/2020-02-11_16-42-47/mysql/help_topic.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/help_category.ibd to /backup/2020-02-11_16-42-47/mysql/help_category.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/help_relation.ibd to /backup/2020-02-11_16-42-47/mysql/help_relation.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/help_keyword.ibd to /backup/2020-02-11_16-42-47/mysql/help_keyword.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/time_zone_name.ibd to /backup/2020-02-11_16-42-47/mysql/time_zone_name.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/time_zone.ibd to /backup/2020-02-11_16-42-47/mysql/time_zone.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/time_zone_transition.ibd to /backup/2020-02-11_16-42-47/mysql/time_zone_transition.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/time_zone_transition_type.ibd to /backup/2020-02-11_16-42-47/mysql/time_zone_transition_type.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/time_zone_leap_second.ibd to /backup/2020-02-11_16-42-47/mysql/time_zone_leap_second.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/innodb_table_stats.ibd to /backup/2020-02-11_16-42-47/mysql/innodb_table_stats.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/innodb_index_stats.ibd to /backup/2020-02-11_16-42-47/mysql/innodb_index_stats.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/slave_relay_log_info.ibd to /backup/2020-02-11_16-42-47/mysql/slave_relay_log_info.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/slave_master_info.ibd to /backup/2020-02-11_16-42-47/mysql/slave_master_info.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/slave_worker_info.ibd to /backup/2020-02-11_16-42-47/mysql/slave_worker_info.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/gtid_executed.ibd to /backup/2020-02-11_16-42-47/mysql/gtid_executed.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/server_cost.ibd to /backup/2020-02-11_16-42-47/mysql/server_cost.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/engine_cost.ibd to /backup/2020-02-11_16-42-47/mysql/engine_cost.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/sys_config.ibd to /backup/2020-02-11_16-42-47/sys/sys_config.ibd200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./test_database/test01.ibd to /backup/2020-02-11_16-42-47/test_database/test01.ibd200211 16:42:48 [01] ...done200211 16:42:48 >> log scanned up to (2625691)200211 16:42:48 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...200211 16:42:48 Executing FLUSH TABLES WITH READ LOCK...200211 16:42:48 Starting to backup non-InnoDB tables and files200211 16:42:48 [01] Copying ./mysql/db.opt to /backup/2020-02-11_16-42-47/mysql/db.opt200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/db.frm to /backup/2020-02-11_16-42-47/mysql/db.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/db.MYI to /backup/2020-02-11_16-42-47/mysql/db.MYI200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/db.MYD to /backup/2020-02-11_16-42-47/mysql/db.MYD200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/user.frm to /backup/2020-02-11_16-42-47/mysql/user.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/user.MYI to /backup/2020-02-11_16-42-47/mysql/user.MYI200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/user.MYD to /backup/2020-02-11_16-42-47/mysql/user.MYD200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/func.frm to /backup/2020-02-11_16-42-47/mysql/func.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/func.MYI to /backup/2020-02-11_16-42-47/mysql/func.MYI200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/func.MYD to /backup/2020-02-11_16-42-47/mysql/func.MYD200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/plugin.frm to /backup/2020-02-11_16-42-47/mysql/plugin.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/servers.frm to /backup/2020-02-11_16-42-47/mysql/servers.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/tables_priv.frm to /backup/2020-02-11_16-42-47/mysql/tables_priv.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/tables_priv.MYI to /backup/2020-02-11_16-42-47/mysql/tables_priv.MYI200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/tables_priv.MYD to /backup/2020-02-11_16-42-47/mysql/tables_priv.MYD200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/columns_priv.frm to /backup/2020-02-11_16-42-47/mysql/columns_priv.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/columns_priv.MYI to /backup/2020-02-11_16-42-47/mysql/columns_priv.MYI200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/columns_priv.MYD to /backup/2020-02-11_16-42-47/mysql/columns_priv.MYD200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/help_topic.frm to /backup/2020-02-11_16-42-47/mysql/help_topic.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/help_category.frm to /backup/2020-02-11_16-42-47/mysql/help_category.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/help_relation.frm to /backup/2020-02-11_16-42-47/mysql/help_relation.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/help_keyword.frm to /backup/2020-02-11_16-42-47/mysql/help_keyword.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/time_zone_name.frm to /backup/2020-02-11_16-42-47/mysql/time_zone_name.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/time_zone.frm to /backup/2020-02-11_16-42-47/mysql/time_zone.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/time_zone_transition.frm to /backup/2020-02-11_16-42-47/mysql/time_zone_transition.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/time_zone_transition_type.frm to /backup/2020-02-11_16-42-47/mysql/time_zone_transition_type.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/time_zone_leap_second.frm to /backup/2020-02-11_16-42-47/mysql/time_zone_leap_second.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/proc.frm to /backup/2020-02-11_16-42-47/mysql/proc.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/proc.MYI to /backup/2020-02-11_16-42-47/mysql/proc.MYI200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/proc.MYD to /backup/2020-02-11_16-42-47/mysql/proc.MYD200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/procs_priv.frm to /backup/2020-02-11_16-42-47/mysql/procs_priv.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/procs_priv.MYI to /backup/2020-02-11_16-42-47/mysql/procs_priv.MYI200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/procs_priv.MYD to /backup/2020-02-11_16-42-47/mysql/procs_priv.MYD200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/general_log.frm to /backup/2020-02-11_16-42-47/mysql/general_log.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/general_log.CSM to /backup/2020-02-11_16-42-47/mysql/general_log.CSM200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/general_log.CSV to /backup/2020-02-11_16-42-47/mysql/general_log.CSV200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/slow_log.frm to /backup/2020-02-11_16-42-47/mysql/slow_log.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/slow_log.CSM to /backup/2020-02-11_16-42-47/mysql/slow_log.CSM200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/slow_log.CSV to /backup/2020-02-11_16-42-47/mysql/slow_log.CSV200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/event.frm to /backup/2020-02-11_16-42-47/mysql/event.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/event.MYI to /backup/2020-02-11_16-42-47/mysql/event.MYI200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/event.MYD to /backup/2020-02-11_16-42-47/mysql/event.MYD200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/ndb_binlog_index.frm to /backup/2020-02-11_16-42-47/mysql/ndb_binlog_index.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/ndb_binlog_index.MYI to /backup/2020-02-11_16-42-47/mysql/ndb_binlog_index.MYI200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/ndb_binlog_index.MYD to /backup/2020-02-11_16-42-47/mysql/ndb_binlog_index.MYD200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/innodb_table_stats.frm to /backup/2020-02-11_16-42-47/mysql/innodb_table_stats.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/innodb_index_stats.frm to /backup/2020-02-11_16-42-47/mysql/innodb_index_stats.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/slave_relay_log_info.frm to /backup/2020-02-11_16-42-47/mysql/slave_relay_log_info.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/slave_master_info.frm to /backup/2020-02-11_16-42-47/mysql/slave_master_info.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/slave_worker_info.frm to /backup/2020-02-11_16-42-47/mysql/slave_worker_info.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/gtid_executed.frm to /backup/2020-02-11_16-42-47/mysql/gtid_executed.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/server_cost.frm to /backup/2020-02-11_16-42-47/mysql/server_cost.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/engine_cost.frm to /backup/2020-02-11_16-42-47/mysql/engine_cost.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/proxies_priv.frm to /backup/2020-02-11_16-42-47/mysql/proxies_priv.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/proxies_priv.MYI to /backup/2020-02-11_16-42-47/mysql/proxies_priv.MYI200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./mysql/proxies_priv.MYD to /backup/2020-02-11_16-42-47/mysql/proxies_priv.MYD200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/db.opt to /backup/2020-02-11_16-42-47/sys/db.opt200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/version.frm to /backup/2020-02-11_16-42-47/sys/version.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/sys_config.frm to /backup/2020-02-11_16-42-47/sys/sys_config.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/statements_with_full_table_scans.frm to /backup/2020-02-11_16-42-47/sys/statements_with_full_table_scans.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/sys_config_insert_set_user.TRN to /backup/2020-02-11_16-42-47/sys/sys_config_insert_set_user.TRN200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/processlist.frm to /backup/2020-02-11_16-42-47/sys/processlist.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/sys_config.TRG to /backup/2020-02-11_16-42-47/sys/sys_config.TRG200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/statements_with_sorting.frm to /backup/2020-02-11_16-42-47/sys/statements_with_sorting.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/sys_config_update_set_user.TRN to /backup/2020-02-11_16-42-47/sys/sys_config_update_set_user.TRN200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024statements_with_sorting.frm to /backup/2020-02-11_16-42-47/sys/x@0024statements_with_sorting.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /backup/2020-02-11_16-42-47/sys/innodb_buffer_stats_by_schema.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/schema_index_statistics.frm to /backup/2020-02-11_16-42-47/sys/schema_index_statistics.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /backup/2020-02-11_16-42-47/sys/x@0024innodb_buffer_stats_by_schema.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/statements_with_temp_tables.frm to /backup/2020-02-11_16-42-47/sys/statements_with_temp_tables.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /backup/2020-02-11_16-42-47/sys/innodb_buffer_stats_by_table.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /backup/2020-02-11_16-42-47/sys/x@0024ps_schema_table_statistics_io.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /backup/2020-02-11_16-42-47/sys/x@0024innodb_buffer_stats_by_table.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/host_summary.frm to /backup/2020-02-11_16-42-47/sys/host_summary.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/innodb_lock_waits.frm to /backup/2020-02-11_16-42-47/sys/innodb_lock_waits.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024host_summary.frm to /backup/2020-02-11_16-42-47/sys/x@0024host_summary.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /backup/2020-02-11_16-42-47/sys/x@0024innodb_lock_waits.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/waits_by_user_by_latency.frm to /backup/2020-02-11_16-42-47/sys/waits_by_user_by_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/schema_object_overview.frm to /backup/2020-02-11_16-42-47/sys/schema_object_overview.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/user_summary_by_file_io_type.frm to /backup/2020-02-11_16-42-47/sys/user_summary_by_file_io_type.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/schema_auto_increment_columns.frm to /backup/2020-02-11_16-42-47/sys/schema_auto_increment_columns.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/user_summary_by_file_io.frm to /backup/2020-02-11_16-42-47/sys/user_summary_by_file_io.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /backup/2020-02-11_16-42-47/sys/x@0024schema_flattened_keys.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /backup/2020-02-11_16-42-47/sys/x@0024user_summary_by_file_io.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/schema_redundant_indexes.frm to /backup/2020-02-11_16-42-47/sys/schema_redundant_indexes.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/user_summary_by_statement_type.frm to /backup/2020-02-11_16-42-47/sys/user_summary_by_statement_type.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /backup/2020-02-11_16-42-47/sys/ps_check_lost_instrumentation.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/latest_file_io.frm to /backup/2020-02-11_16-42-47/sys/latest_file_io.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/waits_by_host_by_latency.frm to /backup/2020-02-11_16-42-47/sys/waits_by_host_by_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024latest_file_io.frm to /backup/2020-02-11_16-42-47/sys/x@0024latest_file_io.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/waits_global_by_latency.frm to /backup/2020-02-11_16-42-47/sys/waits_global_by_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/io_by_thread_by_latency.frm to /backup/2020-02-11_16-42-47/sys/io_by_thread_by_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/user_summary_by_stages.frm to /backup/2020-02-11_16-42-47/sys/user_summary_by_stages.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /backup/2020-02-11_16-42-47/sys/x@0024io_by_thread_by_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /backup/2020-02-11_16-42-47/sys/x@0024user_summary_by_stages.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /backup/2020-02-11_16-42-47/sys/io_global_by_file_by_bytes.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024schema_index_statistics.frm to /backup/2020-02-11_16-42-47/sys/x@0024schema_index_statistics.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /backup/2020-02-11_16-42-47/sys/x@0024io_global_by_file_by_bytes.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/user_summary.frm to /backup/2020-02-11_16-42-47/sys/user_summary.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/io_global_by_file_by_latency.frm to /backup/2020-02-11_16-42-47/sys/io_global_by_file_by_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/schema_table_statistics.frm to /backup/2020-02-11_16-42-47/sys/schema_table_statistics.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /backup/2020-02-11_16-42-47/sys/x@0024io_global_by_file_by_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024user_summary.frm to /backup/2020-02-11_16-42-47/sys/x@0024user_summary.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /backup/2020-02-11_16-42-47/sys/io_global_by_wait_by_bytes.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024schema_table_statistics.frm to /backup/2020-02-11_16-42-47/sys/x@0024schema_table_statistics.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /backup/2020-02-11_16-42-47/sys/x@0024io_global_by_wait_by_bytes.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/host_summary_by_file_io_type.frm to /backup/2020-02-11_16-42-47/sys/host_summary_by_file_io_type.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /backup/2020-02-11_16-42-47/sys/io_global_by_wait_by_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /backup/2020-02-11_16-42-47/sys/schema_table_statistics_with_buffer.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /backup/2020-02-11_16-42-47/sys/x@0024io_global_by_wait_by_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/host_summary_by_file_io.frm to /backup/2020-02-11_16-42-47/sys/host_summary_by_file_io.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /backup/2020-02-11_16-42-47/sys/memory_by_user_by_current_bytes.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/schema_table_lock_waits.frm to /backup/2020-02-11_16-42-47/sys/schema_table_lock_waits.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /backup/2020-02-11_16-42-47/sys/x@0024memory_by_user_by_current_bytes.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /backup/2020-02-11_16-42-47/sys/x@0024host_summary_by_file_io.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /backup/2020-02-11_16-42-47/sys/memory_by_host_by_current_bytes.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /backup/2020-02-11_16-42-47/sys/x@0024schema_table_lock_waits.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /backup/2020-02-11_16-42-47/sys/x@0024memory_by_host_by_current_bytes.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/statement_analysis.frm to /backup/2020-02-11_16-42-47/sys/statement_analysis.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /backup/2020-02-11_16-42-47/sys/memory_by_thread_by_current_bytes.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024statement_analysis.frm to /backup/2020-02-11_16-42-47/sys/x@0024statement_analysis.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /backup/2020-02-11_16-42-47/sys/x@0024memory_by_thread_by_current_bytes.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/host_summary_by_statement_type.frm to /backup/2020-02-11_16-42-47/sys/host_summary_by_statement_type.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/memory_global_by_current_bytes.frm to /backup/2020-02-11_16-42-47/sys/memory_global_by_current_bytes.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /backup/2020-02-11_16-42-47/sys/statements_with_errors_or_warnings.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /backup/2020-02-11_16-42-47/sys/x@0024memory_global_by_current_bytes.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/metrics.frm to /backup/2020-02-11_16-42-47/sys/metrics.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/memory_global_total.frm to /backup/2020-02-11_16-42-47/sys/memory_global_total.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/host_summary_by_stages.frm to /backup/2020-02-11_16-42-47/sys/host_summary_by_stages.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024memory_global_total.frm to /backup/2020-02-11_16-42-47/sys/x@0024memory_global_total.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/session.frm to /backup/2020-02-11_16-42-47/sys/session.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /backup/2020-02-11_16-42-47/sys/x@0024schema_table_statistics_with_buffer.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /backup/2020-02-11_16-42-47/sys/x@0024statements_with_errors_or_warnings.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /backup/2020-02-11_16-42-47/sys/schema_tables_with_full_table_scans.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/schema_unused_indexes.frm to /backup/2020-02-11_16-42-47/sys/schema_unused_indexes.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /backup/2020-02-11_16-42-47/sys/x@0024schema_tables_with_full_table_scans.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /backup/2020-02-11_16-42-47/sys/x@0024host_summary_by_stages.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /backup/2020-02-11_16-42-47/sys/x@0024statements_with_full_table_scans.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /backup/2020-02-11_16-42-47/sys/x@0024ps_digest_avg_latency_distribution.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /backup/2020-02-11_16-42-47/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /backup/2020-02-11_16-42-47/sys/statements_with_runtimes_in_95th_percentile.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /backup/2020-02-11_16-42-47/sys/x@0024statements_with_runtimes_in_95th_percentile.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /backup/2020-02-11_16-42-47/sys/x@0024statements_with_temp_tables.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /backup/2020-02-11_16-42-47/sys/x@0024user_summary_by_file_io_type.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /backup/2020-02-11_16-42-47/sys/x@0024user_summary_by_statement_type.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/user_summary_by_statement_latency.frm to /backup/2020-02-11_16-42-47/sys/user_summary_by_statement_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /backup/2020-02-11_16-42-47/sys/x@0024user_summary_by_statement_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /backup/2020-02-11_16-42-47/sys/x@0024host_summary_by_file_io_type.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /backup/2020-02-11_16-42-47/sys/x@0024host_summary_by_statement_type.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/host_summary_by_statement_latency.frm to /backup/2020-02-11_16-42-47/sys/host_summary_by_statement_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /backup/2020-02-11_16-42-47/sys/x@0024host_summary_by_statement_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /backup/2020-02-11_16-42-47/sys/wait_classes_global_by_avg_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /backup/2020-02-11_16-42-47/sys/x@0024wait_classes_global_by_avg_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/wait_classes_global_by_latency.frm to /backup/2020-02-11_16-42-47/sys/wait_classes_global_by_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /backup/2020-02-11_16-42-47/sys/x@0024wait_classes_global_by_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /backup/2020-02-11_16-42-47/sys/x@0024waits_by_user_by_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /backup/2020-02-11_16-42-47/sys/x@0024waits_by_host_by_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /backup/2020-02-11_16-42-47/sys/x@0024waits_global_by_latency.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024processlist.frm to /backup/2020-02-11_16-42-47/sys/x@0024processlist.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/x@0024session.frm to /backup/2020-02-11_16-42-47/sys/x@0024session.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./sys/session_ssl_status.frm to /backup/2020-02-11_16-42-47/sys/session_ssl_status.frm200211 16:42:48 [01] ...done200211 16:42:48 [01] Copying ./test_database/db.opt to /backup/2020-02-11_16-42-47/test_database/db.opt200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./test_database/test01.frm to /backup/2020-02-11_16-42-47/test_database/test01.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/db.opt to /backup/2020-02-11_16-42-47/performance_schema/db.opt200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/cond_instances.frm to /backup/2020-02-11_16-42-47/performance_schema/cond_instances.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_waits_current.frm to /backup/2020-02-11_16-42-47/performance_schema/events_waits_current.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_waits_history.frm to /backup/2020-02-11_16-42-47/performance_schema/events_waits_history.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_waits_history_long.frm to /backup/2020-02-11_16-42-47/performance_schema/events_waits_history_long.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /backup/2020-02-11_16-42-47/performance_schema/events_waits_summary_by_instance.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_waits_summary_by_host_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_waits_summary_by_user_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_waits_summary_by_account_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_waits_summary_by_thread_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_waits_summary_global_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/file_instances.frm to /backup/2020-02-11_16-42-47/performance_schema/file_instances.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/file_summary_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/file_summary_by_instance.frm to /backup/2020-02-11_16-42-47/performance_schema/file_summary_by_instance.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/socket_instances.frm to /backup/2020-02-11_16-42-47/performance_schema/socket_instances.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /backup/2020-02-11_16-42-47/performance_schema/socket_summary_by_instance.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/socket_summary_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/host_cache.frm to /backup/2020-02-11_16-42-47/performance_schema/host_cache.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/mutex_instances.frm to /backup/2020-02-11_16-42-47/performance_schema/mutex_instances.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /backup/2020-02-11_16-42-47/performance_schema/objects_summary_global_by_type.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/performance_timers.frm to /backup/2020-02-11_16-42-47/performance_schema/performance_timers.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/rwlock_instances.frm to /backup/2020-02-11_16-42-47/performance_schema/rwlock_instances.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/setup_actors.frm to /backup/2020-02-11_16-42-47/performance_schema/setup_actors.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/setup_consumers.frm to /backup/2020-02-11_16-42-47/performance_schema/setup_consumers.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/setup_instruments.frm to /backup/2020-02-11_16-42-47/performance_schema/setup_instruments.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/setup_objects.frm to /backup/2020-02-11_16-42-47/performance_schema/setup_objects.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/setup_timers.frm to /backup/2020-02-11_16-42-47/performance_schema/setup_timers.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /backup/2020-02-11_16-42-47/performance_schema/table_io_waits_summary_by_index_usage.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /backup/2020-02-11_16-42-47/performance_schema/table_io_waits_summary_by_table.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /backup/2020-02-11_16-42-47/performance_schema/table_lock_waits_summary_by_table.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/threads.frm to /backup/2020-02-11_16-42-47/performance_schema/threads.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_stages_current.frm to /backup/2020-02-11_16-42-47/performance_schema/events_stages_current.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_stages_history.frm to /backup/2020-02-11_16-42-47/performance_schema/events_stages_history.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_stages_history_long.frm to /backup/2020-02-11_16-42-47/performance_schema/events_stages_history_long.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_stages_summary_by_thread_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_stages_summary_by_host_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_stages_summary_by_user_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_stages_summary_by_account_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_stages_summary_global_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_statements_current.frm to /backup/2020-02-11_16-42-47/performance_schema/events_statements_current.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_statements_history.frm to /backup/2020-02-11_16-42-47/performance_schema/events_statements_history.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_statements_history_long.frm to /backup/2020-02-11_16-42-47/performance_schema/events_statements_history_long.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_statements_summary_by_thread_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_statements_summary_by_host_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_statements_summary_by_user_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_statements_summary_by_account_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_statements_summary_global_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_transactions_current.frm to /backup/2020-02-11_16-42-47/performance_schema/events_transactions_current.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_transactions_history.frm to /backup/2020-02-11_16-42-47/performance_schema/events_transactions_history.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_transactions_history_long.frm to /backup/2020-02-11_16-42-47/performance_schema/events_transactions_history_long.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_transactions_summary_by_thread_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_transactions_summary_by_host_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_transactions_summary_by_user_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_transactions_summary_by_account_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/events_transactions_summary_global_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/hosts.frm to /backup/2020-02-11_16-42-47/performance_schema/hosts.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/users.frm to /backup/2020-02-11_16-42-47/performance_schema/users.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/accounts.frm to /backup/2020-02-11_16-42-47/performance_schema/accounts.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/memory_summary_global_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/memory_summary_by_thread_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/memory_summary_by_account_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/memory_summary_by_host_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /backup/2020-02-11_16-42-47/performance_schema/memory_summary_by_user_by_event_name.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /backup/2020-02-11_16-42-47/performance_schema/events_statements_summary_by_digest.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /backup/2020-02-11_16-42-47/performance_schema/events_statements_summary_by_program.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/prepared_statements_instances.frm to /backup/2020-02-11_16-42-47/performance_schema/prepared_statements_instances.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/replication_connection_configuration.frm to /backup/2020-02-11_16-42-47/performance_schema/replication_connection_configuration.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/replication_group_member_stats.frm to /backup/2020-02-11_16-42-47/performance_schema/replication_group_member_stats.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/replication_group_members.frm to /backup/2020-02-11_16-42-47/performance_schema/replication_group_members.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/replication_connection_status.frm to /backup/2020-02-11_16-42-47/performance_schema/replication_connection_status.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/replication_applier_configuration.frm to /backup/2020-02-11_16-42-47/performance_schema/replication_applier_configuration.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/replication_applier_status.frm to /backup/2020-02-11_16-42-47/performance_schema/replication_applier_status.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /backup/2020-02-11_16-42-47/performance_schema/replication_applier_status_by_coordinator.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /backup/2020-02-11_16-42-47/performance_schema/replication_applier_status_by_worker.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/session_connect_attrs.frm to /backup/2020-02-11_16-42-47/performance_schema/session_connect_attrs.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /backup/2020-02-11_16-42-47/performance_schema/session_account_connect_attrs.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/table_handles.frm to /backup/2020-02-11_16-42-47/performance_schema/table_handles.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/metadata_locks.frm to /backup/2020-02-11_16-42-47/performance_schema/metadata_locks.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/user_variables_by_thread.frm to /backup/2020-02-11_16-42-47/performance_schema/user_variables_by_thread.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/variables_by_thread.frm to /backup/2020-02-11_16-42-47/performance_schema/variables_by_thread.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/global_variables.frm to /backup/2020-02-11_16-42-47/performance_schema/global_variables.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/session_variables.frm to /backup/2020-02-11_16-42-47/performance_schema/session_variables.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/status_by_thread.frm to /backup/2020-02-11_16-42-47/performance_schema/status_by_thread.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/status_by_user.frm to /backup/2020-02-11_16-42-47/performance_schema/status_by_user.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/status_by_host.frm to /backup/2020-02-11_16-42-47/performance_schema/status_by_host.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/status_by_account.frm to /backup/2020-02-11_16-42-47/performance_schema/status_by_account.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/global_status.frm to /backup/2020-02-11_16-42-47/performance_schema/global_status.frm200211 16:42:49 [01] ...done200211 16:42:49 [01] Copying ./performance_schema/session_status.frm to /backup/2020-02-11_16-42-47/performance_schema/session_status.frm200211 16:42:49 [01] ...done200211 16:42:49 [00] Writing /backup/2020-02-11_16-42-47/2019-11-06_22-32-57/db.opt200211 16:42:49 [00] ...done200211 16:42:49 [00] Writing /backup/2020-02-11_16-42-47/2019-11-06_22-33-49/db.opt200211 16:42:49 [00] ...done200211 16:42:49 [00] Writing /backup/2020-02-11_16-42-47/2019-11-06_22-35-29/db.opt200211 16:42:49 [00] ...done200211 16:42:49 [00] Writing /backup/2020-02-11_16-42-47/2019-11-06_22-35-36/db.opt200211 16:42:49 [00] ...done200211 16:42:49 [00] Writing /backup/2020-02-11_16-42-47/2019-11-06_22-36-57/db.opt200211 16:42:49 [00] ...done200211 16:42:49 [00] Writing /backup/2020-02-11_16-42-47/2019-11-06_22-37-24/db.opt200211 16:42:49 [00] ...done200211 16:42:49 [00] Writing /backup/2020-02-11_16-42-47/2019-11-06_22-38-11/db.opt200211 16:42:49 [00] ...done200211 16:42:49 Finished backing up non-InnoDB tables and files200211 16:42:49 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...xtrabackup: The latest check point (for incremental): ‘2625682‘xtrabackup: Stopping log copying thread..200211 16:42:49 >> log scanned up to (2625691)200211 16:42:49 Executing UNLOCK TABLES200211 16:42:49 All tables unlocked200211 16:42:49 [00] Copying ib_buffer_pool to /backup/2020-02-11_16-42-47/ib_buffer_pool200211 16:42:49 [00] ...done200211 16:42:49 Backup created in directory ‘/backup/2020-02-11_16-42-47/‘200211 16:42:49 [00] Writing /backup/2020-02-11_16-42-47/backup-my.cnf200211 16:42:49 [00] ...done200211 16:42:49 [00] Writing /backup/2020-02-11_16-42-47/xtrabackup_info200211 16:42:49 [00] ...donextrabackup: Transaction log of lsn (2625682) to (2625691) was copied.200211 16:42:49 completed OK!

View Code

最终会在备份路径下生成一个以时间"yyyy-mm-dd_hh:mi:ss"的文件。

[root@mysqlserver backup]# pwd/backup[root@mysqlserver backup]# ls2020-02-11_16-42-47

（3.2）使用innobackupex执行增量备份

MySQL的增量备份与Oracle RMAN增量备份十分相似，仅仅备份那些发生过改变的块(MySQL叫页，page)，Oracle是通过SCN(system changer number)号来记录数据块的改变的，而MySQL是通过LSN(Log Sequence Number)来记录页的改变。每次全备或增量备份时，innobackupex都会在备份集中创建一个名为"xtrabackup_checkpoints"的文件，里面记录了最后修改的LSN号，在后续增量备份中，只要备份比该LSN大的page和二进制日志即可。

执行增量备份的命令如下：

[root@mysqlserver backup]# innobackupex --user=root --password=‘123456‘ --default-file=‘/etc/my.cnf‘ --incremental --incremental-basedir=2020-02-11_16-42-47 /backup/increm

 相对于全备来说，新增了2个参数：

--incremental                ：代表创建增量备份

--incremental-basedir   ：增量备份需要依赖于某次全备，该参数指定了全备的路径

innobackupex增量备份执行过程如下：

[root@mysqlserver backup]# innobackupex --user=root --password=‘123456‘ --default-file=‘/etc/my.cnf‘ --incremental --incremental-basedir=2020-02-11_16-42-47 /backup/incrementxtrabackup: recognized server arguments: --datadir=/usr/local/mysql/data xtrabackup: recognized client arguments: 200211 17:08:13 innobackupex: Starting the backup operationIMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!".200211 17:08:13 version_check Connecting to MySQL server with DSN ‘dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/tmp/mysql.soc‘ as ‘root‘ (using password: YES).200211 17:08:13 version_check Connected to MySQL server200211 17:08:13 version_check Executing a version check against the server...200211 17:08:13 version_check Done.200211 17:08:13 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: /tmp/mysql.socUsing server version 5.7.27innobackupex version 2.4.18 based on MySQL server 5.7.26 Linux (x86_64) (revision id: 29b4ca5)incremental backup from 2625682 is enabled.xtrabackup: uses posix_fadvise().xtrabackup: cd to /usr/local/mysql/dataxtrabackup: open files limit requested 0, set to 1024xtrabackup: using the following InnoDB configuration:xtrabackup: innodb_data_home_dir = .xtrabackup: innodb_data_file_path = ibdata1:12M:autoextendxtrabackup: innodb_log_group_home_dir = ./xtrabackup: innodb_log_files_in_group = 2xtrabackup: innodb_log_file_size = 50331648InnoDB: Number of pools: 1200211 17:08:13 >> log scanned up to (2625691)xtrabackup: Generating a list of tablespacesInnoDB: Allocated tablespace ID 2 for mysql/plugin, old maximum was 0xtrabackup: using the full scan for incremental backup200211 17:08:13 [01] Copying ./ibdata1 to /backup/increment/2020-02-11_17-08-13/ibdata1.delta200211 17:08:13 [01] ...done200211 17:08:13 [01] Copying ./mysql/plugin.ibd to /backup/increment/2020-02-11_17-08-13/mysql/plugin.ibd.delta200211 17:08:13 [01] ...done200211 17:08:13 [01] Copying ./mysql/servers.ibd to /backup/increment/2020-02-11_17-08-13/mysql/servers.ibd.delta200211 17:08:13 [01] ...done200211 17:08:13 [01] Copying ./mysql/help_topic.ibd to /backup/increment/2020-02-11_17-08-13/mysql/help_topic.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/help_category.ibd to /backup/increment/2020-02-11_17-08-13/mysql/help_category.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/help_relation.ibd to /backup/increment/2020-02-11_17-08-13/mysql/help_relation.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/help_keyword.ibd to /backup/increment/2020-02-11_17-08-13/mysql/help_keyword.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/time_zone_name.ibd to /backup/increment/2020-02-11_17-08-13/mysql/time_zone_name.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/time_zone.ibd to /backup/increment/2020-02-11_17-08-13/mysql/time_zone.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/time_zone_transition.ibd to /backup/increment/2020-02-11_17-08-13/mysql/time_zone_transition.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/time_zone_transition_type.ibd to /backup/increment/2020-02-11_17-08-13/mysql/time_zone_transition_type.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/time_zone_leap_second.ibd to /backup/increment/2020-02-11_17-08-13/mysql/time_zone_leap_second.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/innodb_table_stats.ibd to /backup/increment/2020-02-11_17-08-13/mysql/innodb_table_stats.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/innodb_index_stats.ibd to /backup/increment/2020-02-11_17-08-13/mysql/innodb_index_stats.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/slave_relay_log_info.ibd to /backup/increment/2020-02-11_17-08-13/mysql/slave_relay_log_info.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/slave_master_info.ibd to /backup/increment/2020-02-11_17-08-13/mysql/slave_master_info.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/slave_worker_info.ibd to /backup/increment/2020-02-11_17-08-13/mysql/slave_worker_info.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/gtid_executed.ibd to /backup/increment/2020-02-11_17-08-13/mysql/gtid_executed.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/server_cost.ibd to /backup/increment/2020-02-11_17-08-13/mysql/server_cost.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/engine_cost.ibd to /backup/increment/2020-02-11_17-08-13/mysql/engine_cost.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/sys_config.ibd to /backup/increment/2020-02-11_17-08-13/sys/sys_config.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./test_database/test01.ibd to /backup/increment/2020-02-11_17-08-13/test_database/test01.ibd.delta200211 17:08:14 [01] ...done200211 17:08:14 >> log scanned up to (2625691)200211 17:08:14 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...200211 17:08:14 Executing FLUSH TABLES WITH READ LOCK...200211 17:08:14 Starting to backup non-InnoDB tables and files200211 17:08:14 [01] Copying ./mysql/db.opt to /backup/increment/2020-02-11_17-08-13/mysql/db.opt200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/db.frm to /backup/increment/2020-02-11_17-08-13/mysql/db.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/db.MYI to /backup/increment/2020-02-11_17-08-13/mysql/db.MYI200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/db.MYD to /backup/increment/2020-02-11_17-08-13/mysql/db.MYD200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/user.frm to /backup/increment/2020-02-11_17-08-13/mysql/user.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/user.MYI to /backup/increment/2020-02-11_17-08-13/mysql/user.MYI200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/user.MYD to /backup/increment/2020-02-11_17-08-13/mysql/user.MYD200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/func.frm to /backup/increment/2020-02-11_17-08-13/mysql/func.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/func.MYI to /backup/increment/2020-02-11_17-08-13/mysql/func.MYI200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/func.MYD to /backup/increment/2020-02-11_17-08-13/mysql/func.MYD200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/plugin.frm to /backup/increment/2020-02-11_17-08-13/mysql/plugin.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/servers.frm to /backup/increment/2020-02-11_17-08-13/mysql/servers.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/tables_priv.frm to /backup/increment/2020-02-11_17-08-13/mysql/tables_priv.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/tables_priv.MYI to /backup/increment/2020-02-11_17-08-13/mysql/tables_priv.MYI200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/tables_priv.MYD to /backup/increment/2020-02-11_17-08-13/mysql/tables_priv.MYD200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/columns_priv.frm to /backup/increment/2020-02-11_17-08-13/mysql/columns_priv.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/columns_priv.MYI to /backup/increment/2020-02-11_17-08-13/mysql/columns_priv.MYI200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/columns_priv.MYD to /backup/increment/2020-02-11_17-08-13/mysql/columns_priv.MYD200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/help_topic.frm to /backup/increment/2020-02-11_17-08-13/mysql/help_topic.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/help_category.frm to /backup/increment/2020-02-11_17-08-13/mysql/help_category.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/help_relation.frm to /backup/increment/2020-02-11_17-08-13/mysql/help_relation.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/help_keyword.frm to /backup/increment/2020-02-11_17-08-13/mysql/help_keyword.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/time_zone_name.frm to /backup/increment/2020-02-11_17-08-13/mysql/time_zone_name.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/time_zone.frm to /backup/increment/2020-02-11_17-08-13/mysql/time_zone.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/time_zone_transition.frm to /backup/increment/2020-02-11_17-08-13/mysql/time_zone_transition.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/time_zone_transition_type.frm to /backup/increment/2020-02-11_17-08-13/mysql/time_zone_transition_type.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/time_zone_leap_second.frm to /backup/increment/2020-02-11_17-08-13/mysql/time_zone_leap_second.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/proc.frm to /backup/increment/2020-02-11_17-08-13/mysql/proc.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/proc.MYI to /backup/increment/2020-02-11_17-08-13/mysql/proc.MYI200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/proc.MYD to /backup/increment/2020-02-11_17-08-13/mysql/proc.MYD200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/procs_priv.frm to /backup/increment/2020-02-11_17-08-13/mysql/procs_priv.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/procs_priv.MYI to /backup/increment/2020-02-11_17-08-13/mysql/procs_priv.MYI200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/procs_priv.MYD to /backup/increment/2020-02-11_17-08-13/mysql/procs_priv.MYD200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/general_log.frm to /backup/increment/2020-02-11_17-08-13/mysql/general_log.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/general_log.CSM to /backup/increment/2020-02-11_17-08-13/mysql/general_log.CSM200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/general_log.CSV to /backup/increment/2020-02-11_17-08-13/mysql/general_log.CSV200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/slow_log.frm to /backup/increment/2020-02-11_17-08-13/mysql/slow_log.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/slow_log.CSM to /backup/increment/2020-02-11_17-08-13/mysql/slow_log.CSM200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/slow_log.CSV to /backup/increment/2020-02-11_17-08-13/mysql/slow_log.CSV200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/event.frm to /backup/increment/2020-02-11_17-08-13/mysql/event.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/event.MYI to /backup/increment/2020-02-11_17-08-13/mysql/event.MYI200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/event.MYD to /backup/increment/2020-02-11_17-08-13/mysql/event.MYD200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/ndb_binlog_index.frm to /backup/increment/2020-02-11_17-08-13/mysql/ndb_binlog_index.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/ndb_binlog_index.MYI to /backup/increment/2020-02-11_17-08-13/mysql/ndb_binlog_index.MYI200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/ndb_binlog_index.MYD to /backup/increment/2020-02-11_17-08-13/mysql/ndb_binlog_index.MYD200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/innodb_table_stats.frm to /backup/increment/2020-02-11_17-08-13/mysql/innodb_table_stats.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/innodb_index_stats.frm to /backup/increment/2020-02-11_17-08-13/mysql/innodb_index_stats.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/slave_relay_log_info.frm to /backup/increment/2020-02-11_17-08-13/mysql/slave_relay_log_info.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/slave_master_info.frm to /backup/increment/2020-02-11_17-08-13/mysql/slave_master_info.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/slave_worker_info.frm to /backup/increment/2020-02-11_17-08-13/mysql/slave_worker_info.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/gtid_executed.frm to /backup/increment/2020-02-11_17-08-13/mysql/gtid_executed.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/server_cost.frm to /backup/increment/2020-02-11_17-08-13/mysql/server_cost.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/engine_cost.frm to /backup/increment/2020-02-11_17-08-13/mysql/engine_cost.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/proxies_priv.frm to /backup/increment/2020-02-11_17-08-13/mysql/proxies_priv.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/proxies_priv.MYI to /backup/increment/2020-02-11_17-08-13/mysql/proxies_priv.MYI200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./mysql/proxies_priv.MYD to /backup/increment/2020-02-11_17-08-13/mysql/proxies_priv.MYD200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/db.opt to /backup/increment/2020-02-11_17-08-13/sys/db.opt200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/version.frm to /backup/increment/2020-02-11_17-08-13/sys/version.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/sys_config.frm to /backup/increment/2020-02-11_17-08-13/sys/sys_config.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/statements_with_full_table_scans.frm to /backup/increment/2020-02-11_17-08-13/sys/statements_with_full_table_scans.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/sys_config_insert_set_user.TRN to /backup/increment/2020-02-11_17-08-13/sys/sys_config_insert_set_user.TRN200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/processlist.frm to /backup/increment/2020-02-11_17-08-13/sys/processlist.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/sys_config.TRG to /backup/increment/2020-02-11_17-08-13/sys/sys_config.TRG200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/statements_with_sorting.frm to /backup/increment/2020-02-11_17-08-13/sys/statements_with_sorting.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/sys_config_update_set_user.TRN to /backup/increment/2020-02-11_17-08-13/sys/sys_config_update_set_user.TRN200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024statements_with_sorting.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024statements_with_sorting.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /backup/increment/2020-02-11_17-08-13/sys/innodb_buffer_stats_by_schema.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/schema_index_statistics.frm to /backup/increment/2020-02-11_17-08-13/sys/schema_index_statistics.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024innodb_buffer_stats_by_schema.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/statements_with_temp_tables.frm to /backup/increment/2020-02-11_17-08-13/sys/statements_with_temp_tables.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /backup/increment/2020-02-11_17-08-13/sys/innodb_buffer_stats_by_table.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024ps_schema_table_statistics_io.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024innodb_buffer_stats_by_table.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/host_summary.frm to /backup/increment/2020-02-11_17-08-13/sys/host_summary.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/innodb_lock_waits.frm to /backup/increment/2020-02-11_17-08-13/sys/innodb_lock_waits.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024host_summary.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024host_summary.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024innodb_lock_waits.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/waits_by_user_by_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/waits_by_user_by_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/schema_object_overview.frm to /backup/increment/2020-02-11_17-08-13/sys/schema_object_overview.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/user_summary_by_file_io_type.frm to /backup/increment/2020-02-11_17-08-13/sys/user_summary_by_file_io_type.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/schema_auto_increment_columns.frm to /backup/increment/2020-02-11_17-08-13/sys/schema_auto_increment_columns.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/user_summary_by_file_io.frm to /backup/increment/2020-02-11_17-08-13/sys/user_summary_by_file_io.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024schema_flattened_keys.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024user_summary_by_file_io.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/schema_redundant_indexes.frm to /backup/increment/2020-02-11_17-08-13/sys/schema_redundant_indexes.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/user_summary_by_statement_type.frm to /backup/increment/2020-02-11_17-08-13/sys/user_summary_by_statement_type.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /backup/increment/2020-02-11_17-08-13/sys/ps_check_lost_instrumentation.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/latest_file_io.frm to /backup/increment/2020-02-11_17-08-13/sys/latest_file_io.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/waits_by_host_by_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/waits_by_host_by_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024latest_file_io.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024latest_file_io.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/waits_global_by_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/waits_global_by_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/io_by_thread_by_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/io_by_thread_by_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/user_summary_by_stages.frm to /backup/increment/2020-02-11_17-08-13/sys/user_summary_by_stages.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024io_by_thread_by_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024user_summary_by_stages.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /backup/increment/2020-02-11_17-08-13/sys/io_global_by_file_by_bytes.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024schema_index_statistics.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024schema_index_statistics.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024io_global_by_file_by_bytes.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/user_summary.frm to /backup/increment/2020-02-11_17-08-13/sys/user_summary.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/io_global_by_file_by_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/io_global_by_file_by_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/schema_table_statistics.frm to /backup/increment/2020-02-11_17-08-13/sys/schema_table_statistics.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024io_global_by_file_by_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024user_summary.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024user_summary.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /backup/increment/2020-02-11_17-08-13/sys/io_global_by_wait_by_bytes.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024schema_table_statistics.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024schema_table_statistics.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024io_global_by_wait_by_bytes.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/host_summary_by_file_io_type.frm to /backup/increment/2020-02-11_17-08-13/sys/host_summary_by_file_io_type.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/io_global_by_wait_by_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /backup/increment/2020-02-11_17-08-13/sys/schema_table_statistics_with_buffer.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024io_global_by_wait_by_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/host_summary_by_file_io.frm to /backup/increment/2020-02-11_17-08-13/sys/host_summary_by_file_io.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /backup/increment/2020-02-11_17-08-13/sys/memory_by_user_by_current_bytes.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/schema_table_lock_waits.frm to /backup/increment/2020-02-11_17-08-13/sys/schema_table_lock_waits.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024memory_by_user_by_current_bytes.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024host_summary_by_file_io.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /backup/increment/2020-02-11_17-08-13/sys/memory_by_host_by_current_bytes.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024schema_table_lock_waits.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024memory_by_host_by_current_bytes.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/statement_analysis.frm to /backup/increment/2020-02-11_17-08-13/sys/statement_analysis.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /backup/increment/2020-02-11_17-08-13/sys/memory_by_thread_by_current_bytes.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024statement_analysis.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024statement_analysis.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024memory_by_thread_by_current_bytes.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/host_summary_by_statement_type.frm to /backup/increment/2020-02-11_17-08-13/sys/host_summary_by_statement_type.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/memory_global_by_current_bytes.frm to /backup/increment/2020-02-11_17-08-13/sys/memory_global_by_current_bytes.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /backup/increment/2020-02-11_17-08-13/sys/statements_with_errors_or_warnings.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024memory_global_by_current_bytes.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/metrics.frm to /backup/increment/2020-02-11_17-08-13/sys/metrics.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/memory_global_total.frm to /backup/increment/2020-02-11_17-08-13/sys/memory_global_total.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/host_summary_by_stages.frm to /backup/increment/2020-02-11_17-08-13/sys/host_summary_by_stages.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024memory_global_total.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024memory_global_total.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/session.frm to /backup/increment/2020-02-11_17-08-13/sys/session.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024schema_table_statistics_with_buffer.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024statements_with_errors_or_warnings.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /backup/increment/2020-02-11_17-08-13/sys/schema_tables_with_full_table_scans.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/schema_unused_indexes.frm to /backup/increment/2020-02-11_17-08-13/sys/schema_unused_indexes.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024schema_tables_with_full_table_scans.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024host_summary_by_stages.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024statements_with_full_table_scans.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024ps_digest_avg_latency_distribution.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /backup/increment/2020-02-11_17-08-13/sys/statements_with_runtimes_in_95th_percentile.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024statements_with_runtimes_in_95th_percentile.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024statements_with_temp_tables.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024user_summary_by_file_io_type.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024user_summary_by_statement_type.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/user_summary_by_statement_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/user_summary_by_statement_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024user_summary_by_statement_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024host_summary_by_file_io_type.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024host_summary_by_statement_type.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/host_summary_by_statement_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/host_summary_by_statement_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024host_summary_by_statement_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/wait_classes_global_by_avg_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024wait_classes_global_by_avg_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/wait_classes_global_by_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/wait_classes_global_by_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024wait_classes_global_by_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024waits_by_user_by_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024waits_by_host_by_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024waits_global_by_latency.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024processlist.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024processlist.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/x@0024session.frm to /backup/increment/2020-02-11_17-08-13/sys/x@0024session.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./sys/session_ssl_status.frm to /backup/increment/2020-02-11_17-08-13/sys/session_ssl_status.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./test_database/db.opt to /backup/increment/2020-02-11_17-08-13/test_database/db.opt200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./test_database/test01.frm to /backup/increment/2020-02-11_17-08-13/test_database/test01.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./performance_schema/db.opt to /backup/increment/2020-02-11_17-08-13/performance_schema/db.opt200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./performance_schema/cond_instances.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/cond_instances.frm200211 17:08:14 [01] ...done200211 17:08:14 [01] Copying ./performance_schema/events_waits_current.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_waits_current.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_waits_history.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_waits_history.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_waits_history_long.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_waits_history_long.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_waits_summary_by_instance.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_waits_summary_by_host_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_waits_summary_by_user_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_waits_summary_by_account_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_waits_summary_by_thread_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_waits_summary_global_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/file_instances.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/file_instances.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/file_summary_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/file_summary_by_instance.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/file_summary_by_instance.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/socket_instances.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/socket_instances.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/socket_summary_by_instance.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/socket_summary_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/host_cache.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/host_cache.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/mutex_instances.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/mutex_instances.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/objects_summary_global_by_type.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/performance_timers.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/performance_timers.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/rwlock_instances.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/rwlock_instances.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/setup_actors.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/setup_actors.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/setup_consumers.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/setup_consumers.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/setup_instruments.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/setup_instruments.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/setup_objects.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/setup_objects.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/setup_timers.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/setup_timers.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/table_io_waits_summary_by_index_usage.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/table_io_waits_summary_by_table.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/table_lock_waits_summary_by_table.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/threads.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/threads.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_stages_current.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_stages_current.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_stages_history.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_stages_history.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_stages_history_long.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_stages_history_long.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_stages_summary_by_thread_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_stages_summary_by_host_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_stages_summary_by_user_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_stages_summary_by_account_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_stages_summary_global_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_statements_current.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_statements_current.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_statements_history.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_statements_history.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_statements_history_long.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_statements_history_long.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_statements_summary_by_thread_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_statements_summary_by_host_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_statements_summary_by_user_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_statements_summary_by_account_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_statements_summary_global_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_transactions_current.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_transactions_current.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_transactions_history.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_transactions_history.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_transactions_history_long.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_transactions_history_long.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_transactions_summary_by_thread_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_transactions_summary_by_host_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_transactions_summary_by_user_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_transactions_summary_by_account_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_transactions_summary_global_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/hosts.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/hosts.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/users.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/users.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/accounts.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/accounts.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/memory_summary_global_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/memory_summary_by_thread_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/memory_summary_by_account_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/memory_summary_by_host_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/memory_summary_by_user_by_event_name.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_statements_summary_by_digest.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/events_statements_summary_by_program.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/prepared_statements_instances.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/prepared_statements_instances.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/replication_connection_configuration.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/replication_connection_configuration.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/replication_group_member_stats.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/replication_group_member_stats.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/replication_group_members.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/replication_group_members.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/replication_connection_status.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/replication_connection_status.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/replication_applier_configuration.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/replication_applier_configuration.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/replication_applier_status.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/replication_applier_status.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/replication_applier_status_by_coordinator.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/replication_applier_status_by_worker.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/session_connect_attrs.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/session_connect_attrs.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/session_account_connect_attrs.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/table_handles.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/table_handles.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/metadata_locks.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/metadata_locks.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/user_variables_by_thread.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/user_variables_by_thread.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/variables_by_thread.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/variables_by_thread.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/global_variables.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/global_variables.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/session_variables.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/session_variables.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/status_by_thread.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/status_by_thread.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/status_by_user.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/status_by_user.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/status_by_host.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/status_by_host.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/status_by_account.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/status_by_account.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/global_status.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/global_status.frm200211 17:08:15 [01] ...done200211 17:08:15 [01] Copying ./performance_schema/session_status.frm to /backup/increment/2020-02-11_17-08-13/performance_schema/session_status.frm200211 17:08:15 [01] ...done200211 17:08:15 [00] Writing /backup/increment/2020-02-11_17-08-13/2019-11-06_22-32-57/db.opt200211 17:08:15 [00] ...done200211 17:08:15 [00] Writing /backup/increment/2020-02-11_17-08-13/2019-11-06_22-33-49/db.opt200211 17:08:15 [00] ...done200211 17:08:15 [00] Writing /backup/increment/2020-02-11_17-08-13/2019-11-06_22-35-29/db.opt200211 17:08:15 [00] ...done200211 17:08:15 [00] Writing /backup/increment/2020-02-11_17-08-13/2019-11-06_22-35-36/db.opt200211 17:08:15 [00] ...done200211 17:08:15 [00] Writing /backup/increment/2020-02-11_17-08-13/2019-11-06_22-36-57/db.opt200211 17:08:15 [00] ...done200211 17:08:15 [00] Writing /backup/increment/2020-02-11_17-08-13/2019-11-06_22-37-24/db.opt200211 17:08:15 [00] ...done200211 17:08:15 [00] Writing /backup/increment/2020-02-11_17-08-13/2019-11-06_22-38-11/db.opt200211 17:08:15 [00] ...done200211 17:08:15 Finished backing up non-InnoDB tables and files200211 17:08:15 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...xtrabackup: The latest check point (for incremental): ‘2625682‘xtrabackup: Stopping log copying thread..200211 17:08:15 >> log scanned up to (2625691)200211 17:08:15 Executing UNLOCK TABLES200211 17:08:15 All tables unlocked200211 17:08:15 [00] Copying ib_buffer_pool to /backup/increment/2020-02-11_17-08-13/ib_buffer_pool200211 17:08:15 [00] ...done200211 17:08:15 Backup created in directory ‘/backup/increment/2020-02-11_17-08-13/‘200211 17:08:15 [00] Writing /backup/increment/2020-02-11_17-08-13/backup-my.cnf200211 17:08:15 [00] ...done200211 17:08:15 [00] Writing /backup/increment/2020-02-11_17-08-13/xtrabackup_info200211 17:08:15 [00] ...donextrabackup: Transaction log of lsn (2625682) to (2625691) was copied.200211 17:08:15 completed OK!