一、使用innobackupex创建全备
语法
innobackupex --user=DBUSER --password=DBUSERPASS /path/to/backup/dir/
innobackupex --user=DBUSER --password=DBUSERPASS --backup --target-dir=/path/to/BACKUP-DIR/
--backup 默认选项
–port 端口
–socket socket
–host 主机
--no-timestamp 指定了这个选项备份会直接备份在BACKUP-DIR，不再创建时间戳文件夹
--target-dir 指定了这个选项备份会直接备份在BACKUP-DIR，不再创建时间戳文件夹
--defaults-file 指定默认的配置文件，必须为第一个选项
[root@linuxidc backup]# innobackupex --defaults-file=/etc/my.cnf --user=root --password=wangshengzhuang /backup/
160904 18:01:55 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!".
160904 18:01:56 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/lib/mysql/mysql.sock' as 'root' (using password: YES).
160904 18:01:56 version_check Connected to MySQL server
160904 18:01:56 version_check Executing a version check against the server...
160904 18:01:56 version_check Done.
160904 18:01:56 Connecting to MySQL server host: localhost, user: root, password: set, port: 0, socket: /var/lib/mysql/mysql.sock
Using server version 5.6.30-log
innobackupex version 2.4.4 based on MySQL server 5.7.13 Linux (x86_64) (revision id: df58cf2)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
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
160904 18:01:56 >> log scanned up to (1626027)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 3 for mysql/slave_relay_log_info, old maximum was 0
160904 18:01:56 [01] Copying ./ibdata1 to /backup/2019-09-04_18-01-55/ibdata1
160904 18:01:56 [01] ...done
160904 18:01:56 [01] Copying ./mysql/slave_relay_log_info.ibd to /backup/2019-09-04_18-01-55/mysql/slave_relay_log_info.ibd
160904 18:01:56 [01] ...done
160904 18:01:56 [01] Copying ./mysql/slave_worker_info.ibd to /backup/2019-09-04_18-01-55/mysql/slave_worker_info.ibd
160904 18:01:56 [01] ...done
160904 18:01:56 [01] Copying ./mysql/slave_master_info.ibd to /backup/2019-09-04_18-01-55/mysql/slave_master_info.ibd
160904 18:01:56 [01] ...done
160904 18:01:56 [01] Copying ./mysql/innodb_index_stats.ibd to /backup/2019-09-04_18-01-55/mysql/innodb_index_stats.ibd
160904 18:01:56 [01] ...done
160904 18:01:56 [01] Copying ./mysql/innodb_table_stats.ibd to /backup/2019-09-04_18-01-55/mysql/innodb_table_stats.ibd
160904 18:01:56 [01] ...done
160904 18:01:57 >> log scanned up to (1626027)
160904 18:01:57 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
160904 18:01:57 Executing FLUSH TABLES WITH READ LOCK...
160904 18:01:57 Starting to backup non-InnoDB tables and files
160904 18:01:57 [00] Writing test/db.opt
160904 18:01:57 [00] ...done
160904 18:01:57 [01] Copying ./mysql/servers.frm to /backup/2019-09-04_18-01-55/mysql/servers.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/tables_priv.MYD to /backup/2019-09-04_18-01-55/mysql/tables_priv.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/help_keyword.frm to /backup/2019-09-04_18-01-55/mysql/help_keyword.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/ndb_binlog_index.MYD to /backup/2019-09-04_18-01-55/mysql/ndb_binlog_index.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/columns_priv.MYD to /backup/2019-09-04_18-01-55/mysql/columns_priv.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/servers.MYD to /backup/2019-09-04_18-01-55/mysql/servers.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/user.MYD to /backup/2019-09-04_18-01-55/mysql/user.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/event.frm to /backup/2019-09-04_18-01-55/mysql/event.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone_transition.MYD to /backup/2019-09-04_18-01-55/mysql/time_zone_transition.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/proc.MYI to /backup/2019-09-04_18-01-55/mysql/proc.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone_leap_second.MYI to /backup/2019-09-04_18-01-55/mysql/time_zone_leap_second.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/help_topic.MYI to /backup/2019-09-04_18-01-55/mysql/help_topic.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone_transition.MYI to /backup/2019-09-04_18-01-55/mysql/time_zone_transition.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/general_log.CSV to /backup/2019-09-04_18-01-55/mysql/general_log.CSV
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone_transition.frm to /backup/2019-09-04_18-01-55/mysql/time_zone_transition.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/func.MYD to /backup/2019-09-04_18-01-55/mysql/func.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/user.MYI to /backup/2019-09-04_18-01-55/mysql/user.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/help_relation.MYI to /backup/2019-09-04_18-01-55/mysql/help_relation.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/plugin.frm to /backup/2019-09-04_18-01-55/mysql/plugin.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone_name.frm to /backup/2019-09-04_18-01-55/mysql/time_zone_name.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/ndb_binlog_index.MYI to /backup/2019-09-04_18-01-55/mysql/ndb_binlog_index.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/help_relation.MYD to /backup/2019-09-04_18-01-55/mysql/help_relation.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/plugin.MYD to /backup/2019-09-04_18-01-55/mysql/plugin.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/help_category.MYD to /backup/2019-09-04_18-01-55/mysql/help_category.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/event.MYI to /backup/2019-09-04_18-01-55/mysql/event.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/event.MYD to /backup/2019-09-04_18-01-55/mysql/event.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/procs_priv.MYI to /backup/2019-09-04_18-01-55/mysql/procs_priv.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/slow_log.frm to /backup/2019-09-04_18-01-55/mysql/slow_log.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/help_keyword.MYI to /backup/2019-09-04_18-01-55/mysql/help_keyword.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/user.frm to /backup/2019-09-04_18-01-55/mysql/user.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/slow_log.CSV to /backup/2019-09-04_18-01-55/mysql/slow_log.CSV
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/help_keyword.MYD to /backup/2019-09-04_18-01-55/mysql/help_keyword.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/plugin.MYI to /backup/2019-09-04_18-01-55/mysql/plugin.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/func.frm to /backup/2019-09-04_18-01-55/mysql/func.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/proxies_priv.MYD to /backup/2019-09-04_18-01-55/mysql/proxies_priv.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone_leap_second.frm to /backup/2019-09-04_18-01-55/mysql/time_zone_leap_second.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/slave_master_info.frm to /backup/2019-09-04_18-01-55/mysql/slave_master_info.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/help_relation.frm to /backup/2019-09-04_18-01-55/mysql/help_relation.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/func.MYI to /backup/2019-09-04_18-01-55/mysql/func.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/procs_priv.frm to /backup/2019-09-04_18-01-55/mysql/procs_priv.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/proc.frm to /backup/2019-09-04_18-01-55/mysql/proc.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/innodb_index_stats.frm to /backup/2019-09-04_18-01-55/mysql/innodb_index_stats.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/db.MYD to /backup/2019-09-04_18-01-55/mysql/db.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/db.frm to /backup/2019-09-04_18-01-55/mysql/db.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/columns_priv.MYI to /backup/2019-09-04_18-01-55/mysql/columns_priv.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone.frm to /backup/2019-09-04_18-01-55/mysql/time_zone.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/columns_priv.frm to /backup/2019-09-04_18-01-55/mysql/columns_priv.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/slave_worker_info.frm to /backup/2019-09-04_18-01-55/mysql/slave_worker_info.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone_transition_type.frm to /backup/2019-09-04_18-01-55/mysql/time_zone_transition_type.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/help_topic.frm to /backup/2019-09-04_18-01-55/mysql/help_topic.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/servers.MYI to /backup/2019-09-04_18-01-55/mysql/servers.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/help_category.frm to /backup/2019-09-04_18-01-55/mysql/help_category.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/help_category.MYI to /backup/2019-09-04_18-01-55/mysql/help_category.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/general_log.frm to /backup/2019-09-04_18-01-55/mysql/general_log.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone_leap_second.MYD to /backup/2019-09-04_18-01-55/mysql/time_zone_leap_second.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/tables_priv.MYI to /backup/2019-09-04_18-01-55/mysql/tables_priv.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone_name.MYI to /backup/2019-09-04_18-01-55/mysql/time_zone_name.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/tables_priv.frm to /backup/2019-09-04_18-01-55/mysql/tables_priv.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone_transition_type.MYI to /backup/2019-09-04_18-01-55/mysql/time_zone_transition_type.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone_name.MYD to /backup/2019-09-04_18-01-55/mysql/time_zone_name.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/slave_relay_log_info.frm to /backup/2019-09-04_18-01-55/mysql/slave_relay_log_info.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/ndb_binlog_index.frm to /backup/2019-09-04_18-01-55/mysql/ndb_binlog_index.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone.MYD to /backup/2019-09-04_18-01-55/mysql/time_zone.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/innodb_table_stats.frm to /backup/2019-09-04_18-01-55/mysql/innodb_table_stats.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/proc.MYD to /backup/2019-09-04_18-01-55/mysql/proc.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone_transition_type.MYD to /backup/2019-09-04_18-01-55/mysql/time_zone_transition_type.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/general_log.CSM to /backup/2019-09-04_18-01-55/mysql/general_log.CSM
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/proxies_priv.frm to /backup/2019-09-04_18-01-55/mysql/proxies_priv.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/db.MYI to /backup/2019-09-04_18-01-55/mysql/db.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/proxies_priv.MYI to /backup/2019-09-04_18-01-55/mysql/proxies_priv.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/procs_priv.MYD to /backup/2019-09-04_18-01-55/mysql/procs_priv.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/help_topic.MYD to /backup/2019-09-04_18-01-55/mysql/help_topic.MYD
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/time_zone.MYI to /backup/2019-09-04_18-01-55/mysql/time_zone.MYI
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./mysql/slow_log.CSM to /backup/2019-09-04_18-01-55/mysql/slow_log.CSM
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./performance_schema/hosts.frm to /backup/2019-09-04_18-01-55/performance_schema/hosts.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./performance_schema/setup_objects.frm to /backup/2019-09-04_18-01-55/performance_schema/setup_objects.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./performance_schema/file_instances.frm to /backup/2019-09-04_18-01-55/performance_schema/file_instances.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./performance_schema/performance_timers.frm to /backup/2019-09-04_18-01-55/performance_schema/performance_timers.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /backup/2019-09-04_18-01-55/performance_schema/table_io_waits_summary_by_index_usage.frm
160904 18:01:57 [01] ...done
160904 18:01:57 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_statements_summary_by_user_by_event_name.frm
160904 18:01:57 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /backup/2019-09-04_18-01-55/performance_schema/objects_summary_global_by_type.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_statements_current.frm to /backup/2019-09-04_18-01-55/performance_schema/events_statements_current.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/accounts.frm to /backup/2019-09-04_18-01-55/performance_schema/accounts.frm
160904 18:01:58 [01] ...done
160904 18:01:58 >> log scanned up to (1626027)
160904 18:01:58 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/socket_summary_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/mutex_instances.frm to /backup/2019-09-04_18-01-55/performance_schema/mutex_instances.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /backup/2019-09-04_18-01-55/performance_schema/table_lock_waits_summary_by_table.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/users.frm to /backup/2019-09-04_18-01-55/performance_schema/users.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/file_summary_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_statements_history_long.frm to /backup/2019-09-04_18-01-55/performance_schema/events_statements_history_long.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/host_cache.frm to /backup/2019-09-04_18-01-55/performance_schema/host_cache.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_statements_summary_by_account_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_waits_summary_by_user_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /backup/2019-09-04_18-01-55/performance_schema/events_statements_summary_by_digest.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /backup/2019-09-04_18-01-55/performance_schema/session_account_connect_attrs.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/setup_actors.frm to /backup/2019-09-04_18-01-55/performance_schema/setup_actors.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /backup/2019-09-04_18-01-55/performance_schema/events_waits_summary_by_instance.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/setup_instruments.frm to /backup/2019-09-04_18-01-55/performance_schema/setup_instruments.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_stages_history_long.frm to /backup/2019-09-04_18-01-55/performance_schema/events_stages_history_long.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_waits_history_long.frm to /backup/2019-09-04_18-01-55/performance_schema/events_waits_history_long.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_statements_history.frm to /backup/2019-09-04_18-01-55/performance_schema/events_statements_history.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_stages_summary_by_host_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_waits_summary_by_thread_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_waits_current.frm to /backup/2019-09-04_18-01-55/performance_schema/events_waits_current.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/cond_instances.frm to /backup/2019-09-04_18-01-55/performance_schema/cond_instances.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /backup/2019-09-04_18-01-55/performance_schema/table_io_waits_summary_by_table.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_stages_summary_by_account_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_waits_summary_global_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/threads.frm to /backup/2019-09-04_18-01-55/performance_schema/threads.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_stages_summary_by_thread_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/session_connect_attrs.frm to /backup/2019-09-04_18-01-55/performance_schema/session_connect_attrs.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_statements_summary_global_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/db.opt to /backup/2019-09-04_18-01-55/performance_schema/db.opt
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_waits_summary_by_host_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/file_summary_by_instance.frm to /backup/2019-09-04_18-01-55/performance_schema/file_summary_by_instance.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_waits_summary_by_account_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_stages_summary_global_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_stages_current.frm to /backup/2019-09-04_18-01-55/performance_schema/events_stages_current.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_waits_history.frm to /backup/2019-09-04_18-01-55/performance_schema/events_waits_history.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/socket_instances.frm to /backup/2019-09-04_18-01-55/performance_schema/socket_instances.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_statements_summary_by_host_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/setup_consumers.frm to /backup/2019-09-04_18-01-55/performance_schema/setup_consumers.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /backup/2019-09-04_18-01-55/performance_schema/socket_summary_by_instance.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_statements_summary_by_thread_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/rwlock_instances.frm to /backup/2019-09-04_18-01-55/performance_schema/rwlock_instances.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /backup/2019-09-04_18-01-55/performance_schema/events_stages_summary_by_user_by_event_name.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/events_stages_history.frm to /backup/2019-09-04_18-01-55/performance_schema/events_stages_history.frm
160904 18:01:58 [01] ...done
160904 18:01:58 [01] Copying ./performance_schema/setup_timers.frm to /backup/2019-09-04_18-01-55/performance_schema/setup_timers.frm
160904 18:01:58 [01] ...done
160904 18:01:58 Finished backing up non-InnoDB tables and files
160904 18:01:58 [00] Writing xtrabackup_binlog_info
160904 18:01:58 [00] ...done
160904 18:01:58 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '1626027'
xtrabackup: Stopping log copying thread.
.160904 18:01:58 >> log scanned up to (1626027)