（一）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解决依赖问题
yum install -y percona-xtrabackup-STEP3：确认安装结果
（2.2）在线安装
如果机器联网，可以直接使用yum源安装，这里以centos7服务器为例。
STEP1:安装xtraBackup的yum源
[root@MysqLserver /root]# install -y https://repo.percona.com/yum/percona-release-latest.noarch.rpm
STEP2：确认xtrabackup安装包（可跳过）
yum list | percona
...
percona-xtrabackup-22-debuginfo.x86_64 2.2.13-1.el7 percona-release-x86_64
percona-xtrabackup-24.x86_64 24-debuginfo.x86_64 80.x86_64 8.0.9-1.el7 percona-release-80-debuginfo.x86_64 x86_64
percona-xtrabackup-debuginfo.x86_64 2.3.10-x86_64
percona-xtrabackup-test.x86_64 x86_64
percona-xtrabackup-test-22.x86_64 24.x86_64 80.x86_64 x86_64
percona-zabbix-templates.noarch 1.1.8-1 percona-release-noarch
...
STEP3：安装xtraBackup
install -y percona-xtrabackup-24
STEP4：确认安装结果
xtrabackup
[root@MysqLserver /root]# 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来执行全备
执行全备的命令如下：
@H_404_203@[root@MysqLserver ~]# innobackupex --user=root --password='123456' --default-file=/etc/my.cnf' /backup
参数信息：
--password ：连接数据库使用的密码
--default-file ：指出MysqL的参数配置文件路径
[backup_dir] ：备份集存放地址
innobackupex备份执行过程如下：
@H_404_203@
[root@MysqLserver ~]# innobackupex --user=root --password=' /backup xtrabackup: recognized server arguments: --datadir=/usr/local/MysqL/data xtrabackup: recognized client arguments: 200211 42:47 innobackupex: Starting the backup operation IMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints "completed OK!". 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). version_check Connected to MysqL server version_check Executing a version check against the server... version_check Done. 47 Connecting to MysqL server host: localhost,user: root,password: set,port: not set,socket: /tmp/MysqL.soc Using server version 5.7.27 innobackupex version 18 based on MysqL server 26 Linux (x86_64) (revision id: 29b4ca5) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /usr/local/MysqL/data xtrabackup: open files limit requested 0,set to 1024 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 InnoDB: Number of pools: 1 47 >> log scanned up to (2625691) xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 2 for MysqL/plugin,old maximum was 0 47 [01] Copying ./ibdata1 to /backup/2020-02-11_16-42-47/ibdata1 48 [01] ...done 01] Copying ./MysqL/plugin.ibd to /backup/47/MysqL/plugin.ibd 01] Copying ./MysqL/servers.ibd to /backup/servers.ibd 01] Copying ./MysqL/help_topic.ibd to /backup/help_topic.ibd 01] Copying ./MysqL/help_category.ibd to /backup/help_category.ibd 01] Copying ./MysqL/help_relation.ibd to /backup/help_relation.ibd 01] Copying ./MysqL/help_keyword.ibd to /backup/help_keyword.ibd 01] Copying ./MysqL/time_zone_name.ibd to /backup/time_zone_name.ibd 01] Copying ./MysqL/time_zone.ibd to /backup/time_zone.ibd 01] Copying ./MysqL/time_zone_transition.ibd to /backup/time_zone_transition.ibd 01] Copying ./MysqL/time_zone_transition_type.ibd to /backup/time_zone_transition_type.ibd 01] Copying ./MysqL/time_zone_leap_second.ibd to /backup/time_zone_leap_second.ibd 01] Copying ./MysqL/innodb_table_stats.ibd to /backup/innodb_table_stats.ibd 01] Copying ./MysqL/innodb_index_stats.ibd to /backup/innodb_index_stats.ibd 01] Copying ./MysqL/slave_relay_log_info.ibd to /backup/slave_relay_log_info.ibd 01] Copying ./MysqL/slave_master_info.ibd to /backup/slave_master_info.ibd 01] Copying ./MysqL/slave_worker_info.ibd to /backup/slave_worker_info.ibd 01] Copying ./MysqL/gtid_executed.ibd to /backup/gtid_executed.ibd 01] Copying ./MysqL/server_cost.ibd to /backup/server_cost.ibd 01] Copying ./MysqL/engine_cost.ibd to /backup/engine_cost.ibd 01] Copying ./sys/sys_config.ibd to /backup/47/sys/sys_config.ibd 01] Copying ./test_database/test01.ibd to /backup/47/test_database/test01.ibd 48 >> log scanned up to () 48 Executing FLUSH NO_WRITE_TO_BINLOG TABLES... Executing FLUSH TABLES WITH READ LOCK... 48 Starting to backup non-InnoDB tables and files 01] Copying ./MysqL/db.opt to /backup/db.opt 01] Copying ./MysqL/db.frm to /backup/db.frm 01] Copying ./MysqL/db.MYI to /backup/db.MYI 01] Copying ./MysqL/db.MYD to /backup/db.MYD 01] Copying ./MysqL/user.frm to /backup/user.frm 01] Copying ./MysqL/user.MYI to /backup/user.MYI 01] Copying ./MysqL/user.MYD to /backup/user.MYD 01] Copying ./MysqL/func.frm to /backup/func.frm 01] Copying ./MysqL/func.MYI to /backup/func.MYI 01] Copying ./MysqL/func.MYD to /backup/func.MYD 01] Copying ./MysqL/plugin.frm to /backup/plugin.frm 01] Copying ./MysqL/servers.frm to /backup/servers.frm 01] Copying ./MysqL/tables_priv.frm to /backup/tables_priv.frm 01] Copying ./MysqL/tables_priv.MYI to /backup/tables_priv.MYI 01] Copying ./MysqL/tables_priv.MYD to /backup/tables_priv.MYD 01] Copying ./MysqL/columns_priv.frm to /backup/columns_priv.frm 01] Copying ./MysqL/columns_priv.MYI to /backup/columns_priv.MYI 01] Copying ./MysqL/columns_priv.MYD to /backup/columns_priv.MYD 01] Copying ./MysqL/help_topic.frm to /backup/help_topic.frm 01] Copying ./MysqL/help_category.frm to /backup/help_category.frm 01] Copying ./MysqL/help_relation.frm to /backup/help_relation.frm 01] Copying ./MysqL/help_keyword.frm to /backup/help_keyword.frm 01] Copying ./MysqL/time_zone_name.frm to /backup/time_zone_name.frm 01] Copying ./MysqL/time_zone.frm to /backup/time_zone.frm 01] Copying ./MysqL/time_zone_transition.frm to /backup/time_zone_transition.frm 01] Copying ./MysqL/time_zone_transition_type.frm to /backup/time_zone_transition_type.frm 01] Copying ./MysqL/time_zone_leap_second.frm to /backup/time_zone_leap_second.frm 01] Copying ./MysqL/proc.frm to /backup/proc.frm 01] Copying ./MysqL/proc.MYI to /backup/proc.MYI 01] Copying ./MysqL/proc.MYD to /backup/proc.MYD 01] Copying ./MysqL/procs_priv.frm to /backup/procs_priv.frm 01] Copying ./MysqL/procs_priv.MYI to /backup/procs_priv.MYI 01] Copying ./MysqL/procs_priv.MYD to /backup/procs_priv.MYD 01] Copying ./MysqL/general_log.frm to /backup/general_log.frm 01] Copying ./MysqL/general_log.CSM to /backup/general_log.CSM 01] Copying ./MysqL/general_log.CSV to /backup/general_log.CSV 01] Copying ./MysqL/slow_log.frm to /backup/slow_log.frm 01] Copying ./MysqL/slow_log.CSM to /backup/slow_log.CSM 01] Copying ./MysqL/slow_log.CSV to /backup/slow_log.CSV 01] Copying ./MysqL/event.frm to /backup/event.frm 01] Copying ./MysqL/event.MYI to /backup/event.MYI 01] Copying ./MysqL/event.MYD to /backup/event.MYD 01] Copying ./MysqL/ndb_binlog_index.frm to /backup/ndb_binlog_index.frm 01] Copying ./MysqL/ndb_binlog_index.MYI to /backup/ndb_binlog_index.MYI 01] Copying ./MysqL/ndb_binlog_index.MYD to /backup/ndb_binlog_index.MYD 01] Copying ./MysqL/innodb_table_stats.frm to /backup/innodb_table_stats.frm 01] Copying ./MysqL/innodb_index_stats.frm to /backup/innodb_index_stats.frm 01] Copying ./MysqL/slave_relay_log_info.frm to /backup/slave_relay_log_info.frm 01] Copying ./MysqL/slave_master_info.frm to /backup/slave_master_info.frm 01] Copying ./MysqL/slave_worker_info.frm to /backup/slave_worker_info.frm 01] Copying ./MysqL/gtid_executed.frm to /backup/gtid_executed.frm 01] Copying ./MysqL/server_cost.frm to /backup/server_cost.frm 01] Copying ./MysqL/engine_cost.frm to /backup/engine_cost.frm 01] Copying ./MysqL/proxies_priv.frm to /backup/proxies_priv.frm 01] Copying ./MysqL/proxies_priv.MYI to /backup/proxies_priv.MYI 01] Copying ./MysqL/proxies_priv.MYD to /backup/proxies_priv.MYD 01] Copying ./sys/db.opt to /backup/01] Copying ./sys/version.frm to /backup/version.frm 01] Copying ./sys/sys_config.frm to /backup/sys_config.frm 01] Copying ./sys/statements_with_full_table_scans.frm to /backup/statements_with_full_table_scans.frm 01] Copying ./sys/sys_config_insert_set_user.TRN to /backup/sys_config_insert_set_user.TRN 01] Copying ./sys/processlist.frm to /backup/processlist.frm 01] Copying ./sys/sys_config.TRG to /backup/sys_config.TRG 01] Copying ./sys/statements_with_sorting.frm to /backup/statements_with_sorting.frm 01] Copying ./sys/sys_config_update_set_user.TRN to /backup/sys_config_update_set_user.TRN 01] Copying ./sys/x@0024statements_with_sorting.frm to /backup/x@0024statements_with_sorting.frm 01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /backup/innodb_buffer_stats_by_schema.frm 01] Copying ./sys/schema_index_statistics.frm to /backup/schema_index_statistics.frm 01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /backup/x@0024innodb_buffer_stats_by_schema.frm 01] Copying ./sys/statements_with_temp_tables.frm to /backup/statements_with_temp_tables.frm 01] Copying ./sys/innodb_buffer_stats_by_table.frm to /backup/innodb_buffer_stats_by_table.frm 01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /backup/x@0024ps_schema_table_statistics_io.frm 01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /backup/x@0024innodb_buffer_stats_by_table.frm 01] Copying ./sys/host_summary.frm to /backup/host_summary.frm 01] Copying ./sys/innodb_lock_waits.frm to /backup/innodb_lock_waits.frm 01] Copying ./sys/x@0024host_summary.frm to /backup/x@0024host_summary.frm 01] Copying ./sys/x@0024innodb_lock_waits.frm to /backup/x@0024innodb_lock_waits.frm 01] Copying ./sys/waits_by_user_by_latency.frm to /backup/waits_by_user_by_latency.frm 01] Copying ./sys/schema_object_overview.frm to /backup/schema_object_overview.frm 01] Copying ./sys/user_summary_by_file_io_type.frm to /backup/user_summary_by_file_io_type.frm 01] Copying ./sys/schema_auto_increment_columns.frm to /backup/schema_auto_increment_columns.frm 01] Copying ./sys/user_summary_by_file_io.frm to /backup/user_summary_by_file_io.frm 01] Copying ./sys/x@0024schema_flattened_keys.frm to /backup/x@0024schema_flattened_keys.frm 01] Copying ./sys/x@0024user_summary_by_file_io.frm to /backup/x@0024user_summary_by_file_io.frm 01] Copying ./sys/schema_redundant_indexes.frm to /backup/schema_redundant_indexes.frm 01] Copying ./sys/user_summary_by_statement_type.frm to /backup/user_summary_by_statement_type.frm 01] Copying ./sys/ps_check_lost_instrumentation.frm to /backup/ps_check_lost_instrumentation.frm 01] Copying ./sys/latest_file_io.frm to /backup/latest_file_io.frm 01] Copying ./sys/waits_by_host_by_latency.frm to /backup/waits_by_host_by_latency.frm 01] Copying ./sys/x@0024latest_file_io.frm to /backup/x@0024latest_file_io.frm 01] Copying ./sys/waits_global_by_latency.frm to /backup/waits_global_by_latency.frm 01] Copying ./sys/io_by_thread_by_latency.frm to /backup/io_by_thread_by_latency.frm 01] Copying ./sys/user_summary_by_stages.frm to /backup/user_summary_by_stages.frm 01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /backup/x@0024io_by_thread_by_latency.frm 01] Copying ./sys/x@0024user_summary_by_stages.frm to /backup/x@0024user_summary_by_stages.frm 01] Copying ./sys/io_global_by_file_by_bytes.frm to /backup/io_global_by_file_by_bytes.frm 01] Copying ./sys/x@0024schema_index_statistics.frm to /backup/x@0024schema_index_statistics.frm 01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /backup/x@0024io_global_by_file_by_bytes.frm 01] Copying ./sys/user_summary.frm to /backup/user_summary.frm 01] Copying ./sys/io_global_by_file_by_latency.frm to /backup/io_global_by_file_by_latency.frm 01] Copying ./sys/schema_table_statistics.frm to /backup/schema_table_statistics.frm 01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /backup/x@0024io_global_by_file_by_latency.frm 01] Copying ./sys/x@0024user_summary.frm to /backup/x@0024user_summary.frm 01] Copying ./sys/io_global_by_wait_by_bytes.frm to /backup/io_global_by_wait_by_bytes.frm 01] Copying ./sys/x@0024schema_table_statistics.frm to /backup/x@0024schema_table_statistics.frm 01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /backup/x@0024io_global_by_wait_by_bytes.frm 01] Copying ./sys/host_summary_by_file_io_type.frm to /backup/host_summary_by_file_io_type.frm 01] Copying ./sys/io_global_by_wait_by_latency.frm to /backup/io_global_by_wait_by_latency.frm 01] Copying ./sys/schema_table_statistics_with_buffer.frm to /backup/schema_table_statistics_with_buffer.frm 01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /backup/x@0024io_global_by_wait_by_latency.frm 01] Copying ./sys/host_summary_by_file_io.frm to /backup/host_summary_by_file_io.frm 01] Copying ./sys/memory_by_user_by_current_bytes.frm to /backup/memory_by_user_by_current_bytes.frm 01] Copying ./sys/schema_table_lock_waits.frm to /backup/schema_table_lock_waits.frm 01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /backup/x@0024memory_by_user_by_current_bytes.frm 01] Copying ./sys/x@0024host_summary_by_file_io.frm to /backup/x@0024host_summary_by_file_io.frm 01] Copying ./sys/memory_by_host_by_current_bytes.frm to /backup/memory_by_host_by_current_bytes.frm 01] Copying ./sys/x@0024schema_table_lock_waits.frm to /backup/x@0024schema_table_lock_waits.frm 01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /backup/x@0024memory_by_host_by_current_bytes.frm 01] Copying ./sys/statement_analysis.frm to /backup/statement_analysis.frm 01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /backup/memory_by_thread_by_current_bytes.frm 01] Copying ./sys/x@0024statement_analysis.frm to /backup/x@0024statement_analysis.frm 01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /backup/x@0024memory_by_thread_by_current_bytes.frm 01] Copying ./sys/host_summary_by_statement_type.frm to /backup/host_summary_by_statement_type.frm 01] Copying ./sys/memory_global_by_current_bytes.frm to /backup/memory_global_by_current_bytes.frm 01] Copying ./sys/statements_with_errors_or_warnings.frm to /backup/statements_with_errors_or_warnings.frm 01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /backup/x@0024memory_global_by_current_bytes.frm 01] Copying ./sys/metrics.frm to /backup/metrics.frm 01] Copying ./sys/memory_global_total.frm to /backup/memory_global_total.frm 01] Copying ./sys/host_summary_by_stages.frm to /backup/host_summary_by_stages.frm 01] Copying ./sys/x@0024memory_global_total.frm to /backup/x@0024memory_global_total.frm 01] Copying ./sys/session.frm to /backup/session.frm 01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /backup/x@0024schema_table_statistics_with_buffer.frm 01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /backup/x@0024statements_with_errors_or_warnings.frm 01] Copying ./sys/schema_tables_with_full_table_scans.frm to /backup/schema_tables_with_full_table_scans.frm 01] Copying ./sys/schema_unused_indexes.frm to /backup/schema_unused_indexes.frm 01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /backup/x@0024schema_tables_with_full_table_scans.frm 01] Copying ./sys/x@0024host_summary_by_stages.frm to /backup/x@0024host_summary_by_stages.frm 01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /backup/x@0024statements_with_full_table_scans.frm 01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /backup/x@0024ps_digest_avg_latency_distribution.frm 01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /backup/x@0024ps_digest_95th_percentile_by_avg_us.frm 01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /backup/statements_with_runtimes_in_95th_percentile.frm 01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /backup/x@0024statements_with_runtimes_in_95th_percentile.frm 01] Copying ./sys/x@0024statements_with_temp_tables.frm to /backup/x@0024statements_with_temp_tables.frm 01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /backup/x@0024user_summary_by_file_io_type.frm 01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /backup/x@0024user_summary_by_statement_type.frm 01] Copying ./sys/user_summary_by_statement_latency.frm to /backup/user_summary_by_statement_latency.frm 01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /backup/x@0024user_summary_by_statement_latency.frm 01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /backup/x@0024host_summary_by_file_io_type.frm 01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /backup/x@0024host_summary_by_statement_type.frm 01] Copying ./sys/host_summary_by_statement_latency.frm to /backup/host_summary_by_statement_latency.frm 01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /backup/x@0024host_summary_by_statement_latency.frm 01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /backup/wait_classes_global_by_avg_latency.frm 01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /backup/x@0024wait_classes_global_by_avg_latency.frm 01] Copying ./sys/wait_classes_global_by_latency.frm to /backup/wait_classes_global_by_latency.frm 01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /backup/x@0024wait_classes_global_by_latency.frm 01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /backup/x@0024waits_by_user_by_latency.frm 01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /backup/x@0024waits_by_host_by_latency.frm 01] Copying ./sys/x@0024waits_global_by_latency.frm to /backup/x@0024waits_global_by_latency.frm 01] Copying ./sys/x@0024processlist.frm to /backup/x@0024processlist.frm 01] Copying ./sys/x@0024session.frm to /backup/x@0024session.frm 01] Copying ./sys/session_ssl_status.frm to /backup/session_ssl_status.frm 01] Copying ./test_database/db.opt to /backup/49 [01] Copying ./test_database/test01.frm to /backup/test01.frm 01] Copying ./performance_schema/db.opt to /backup/47/performance_schema/01] Copying ./performance_schema/cond_instances.frm to /backup/cond_instances.frm 01] Copying ./performance_schema/events_waits_current.frm to /backup/events_waits_current.frm 01] Copying ./performance_schema/events_waits_history.frm to /backup/events_waits_history.frm 01] Copying ./performance_schema/events_waits_history_long.frm to /backup/events_waits_history_long.frm 01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /backup/events_waits_summary_by_instance.frm 01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /backup/events_waits_summary_by_host_by_event_name.frm 01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /backup/events_waits_summary_by_user_by_event_name.frm 01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /backup/events_waits_summary_by_account_by_event_name.frm 01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /backup/events_waits_summary_by_thread_by_event_name.frm 01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /backup/events_waits_summary_global_by_event_name.frm 01] Copying ./performance_schema/file_instances.frm to /backup/file_instances.frm 01] Copying ./performance_schema/file_summary_by_event_name.frm to /backup/file_summary_by_event_name.frm 01] Copying ./performance_schema/file_summary_by_instance.frm to /backup/file_summary_by_instance.frm 01] Copying ./performance_schema/socket_instances.frm to /backup/socket_instances.frm 01] Copying ./performance_schema/socket_summary_by_instance.frm to /backup/socket_summary_by_instance.frm 01] Copying ./performance_schema/socket_summary_by_event_name.frm to /backup/socket_summary_by_event_name.frm 01] Copying ./performance_schema/host_cache.frm to /backup/host_cache.frm 01] Copying ./performance_schema/mutex_instances.frm to /backup/mutex_instances.frm 01] Copying ./performance_schema/objects_summary_global_by_type.frm to /backup/objects_summary_global_by_type.frm 01] Copying ./performance_schema/performance_timers.frm to /backup/performance_timers.frm 01] Copying ./performance_schema/rwlock_instances.frm to /backup/rwlock_instances.frm 01] Copying ./performance_schema/setup_actors.frm to /backup/setup_actors.frm 01] Copying ./performance_schema/setup_consumers.frm to /backup/setup_consumers.frm 01] Copying ./performance_schema/setup_instruments.frm to /backup/setup_instruments.frm 01] Copying ./performance_schema/setup_objects.frm to /backup/setup_objects.frm 01] Copying ./performance_schema/setup_timers.frm to /backup/setup_timers.frm 01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /backup/table_io_waits_summary_by_index_usage.frm 01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /backup/table_io_waits_summary_by_table.frm 01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /backup/table_lock_waits_summary_by_table.frm 01] Copying ./performance_schema/threads.frm to /backup/threads.frm 01] Copying ./performance_schema/events_stages_current.frm to /backup/events_stages_current.frm 01] Copying ./performance_schema/events_stages_history.frm to /backup/events_stages_history.frm 01] Copying ./performance_schema/events_stages_history_long.frm to /backup/events_stages_history_long.frm 01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /backup/events_stages_summary_by_thread_by_event_name.frm 01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /backup/events_stages_summary_by_host_by_event_name.frm 01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /backup/events_stages_summary_by_user_by_event_name.frm 01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /backup/events_stages_summary_by_account_by_event_name.frm 01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /backup/events_stages_summary_global_by_event_name.frm 01] Copying ./performance_schema/events_statements_current.frm to /backup/events_statements_current.frm 01] Copying ./performance_schema/events_statements_history.frm to /backup/events_statements_history.frm 01] Copying ./performance_schema/events_statements_history_long.frm to /backup/events_statements_history_long.frm 01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /backup/events_statements_summary_by_thread_by_event_name.frm 01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /backup/events_statements_summary_by_host_by_event_name.frm 01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /backup/events_statements_summary_by_user_by_event_name.frm 01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /backup/events_statements_summary_by_account_by_event_name.frm 01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /backup/events_statements_summary_global_by_event_name.frm 01] Copying ./performance_schema/events_transactions_current.frm to /backup/events_transactions_current.frm 01] Copying ./performance_schema/events_transactions_history.frm to /backup/events_transactions_history.frm 01] Copying ./performance_schema/events_transactions_history_long.frm to /backup/events_transactions_history_long.frm 01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /backup/events_transactions_summary_by_thread_by_event_name.frm 01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /backup/events_transactions_summary_by_host_by_event_name.frm 01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /backup/events_transactions_summary_by_user_by_event_name.frm 01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /backup/events_transactions_summary_by_account_by_event_name.frm 01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /backup/events_transactions_summary_global_by_event_name.frm 01] Copying ./performance_schema/hosts.frm to /backup/hosts.frm 01] Copying ./performance_schema/users.frm to /backup/users.frm 01] Copying ./performance_schema/accounts.frm to /backup/accounts.frm 01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /backup/memory_summary_global_by_event_name.frm 01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /backup/memory_summary_by_thread_by_event_name.frm 01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /backup/memory_summary_by_account_by_event_name.frm 01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /backup/memory_summary_by_host_by_event_name.frm 01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /backup/memory_summary_by_user_by_event_name.frm 01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /backup/events_statements_summary_by_digest.frm 01] Copying ./performance_schema/events_statements_summary_by_program.frm to /backup/events_statements_summary_by_program.frm 01] Copying ./performance_schema/prepared_statements_instances.frm to /backup/prepared_statements_instances.frm 01] Copying ./performance_schema/replication_connection_configuration.frm to /backup/replication_connection_configuration.frm 01] Copying ./performance_schema/replication_group_member_stats.frm to /backup/replication_group_member_stats.frm 01] Copying ./performance_schema/replication_group_members.frm to /backup/replication_group_members.frm 01] Copying ./performance_schema/replication_connection_status.frm to /backup/replication_connection_status.frm 01] Copying ./performance_schema/replication_applier_configuration.frm to /backup/replication_applier_configuration.frm 01] Copying ./performance_schema/replication_applier_status.frm to /backup/replication_applier_status.frm 01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /backup/replication_applier_status_by_coordinator.frm 01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /backup/replication_applier_status_by_worker.frm 01] Copying ./performance_schema/session_connect_attrs.frm to /backup/session_connect_attrs.frm 01] Copying ./performance_schema/session_account_connect_attrs.frm to /backup/session_account_connect_attrs.frm 01] Copying ./performance_schema/table_handles.frm to /backup/table_handles.frm 01] Copying ./performance_schema/Metadata_locks.frm to /backup/Metadata_locks.frm 01] Copying ./performance_schema/user_variables_by_thread.frm to /backup/user_variables_by_thread.frm 01] Copying ./performance_schema/variables_by_thread.frm to /backup/variables_by_thread.frm 01] Copying ./performance_schema/global_variables.frm to /backup/global_variables.frm 01] Copying ./performance_schema/session_variables.frm to /backup/session_variables.frm 01] Copying ./performance_schema/status_by_thread.frm to /backup/status_by_thread.frm 01] Copying ./performance_schema/status_by_user.frm to /backup/status_by_user.frm 01] Copying ./performance_schema/status_by_host.frm to /backup/status_by_host.frm 01] Copying ./performance_schema/status_by_account.frm to /backup/status_by_account.frm 01] Copying ./performance_schema/global_status.frm to /backup/global_status.frm 01] Copying ./performance_schema/session_status.frm to /backup/session_status.frm 00] Writing /backup/47/2019-11-06_22-32-57/00] ...33-49/35-29/36/36-37-24/38-11/49 Finished backing up non-49 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... xtrabackup: The latest check point (for incremental): 2625682 xtrabackup: Stopping log copying thread. .49 >> log scanned up to () Executing UNLOCK TABLES All tables unlocked 00] Copying ib_buffer_pool to /backup/ib_buffer_pool 49 Backup created in directory /backup/2020-02-11_16-42-47/' 47/backup-my.cnf xtrabackup_info done xtrabackup: Transaction log of lsn (2625682) to () was copied. 49 completed OK!