使用Xtrabackup进行MySQL数据库全备和全备还原

一、使用innobackupex创建全备 语法

innobackupex --user=DBUSER --password=DBUSERPASS /path/to/backup/dir/ innobackupex --user=DBUSER --password=DBUSERPASS --backup --target-dir=/path/to/BACKUP-DIR/

OptionDescription
--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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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/2016-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) 160904 18:01:58 Executing UNLOCK TABLES 160904 18:01:58 All tables unlocked 160904 18:01:58 Backup created in directory '/backup/2016-09-04_18-01-55' MySQL binlog position: filename 'mysql-bin.000012', position '262' 160904 18:01:58 [00] Writing backup-my.cnf 160904 18:01:58 [00] ...done 160904 18:01:58 [00] Writing xtrabackup_info 160904 18:01:58 [00] ...done xtrabackup: Transaction log of lsn (1626027) to (1626027) was copied. 160904 18:01:59 completed OK!

最后的completed OK!表示成功

二、使用innobackupex预备全备

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/1650f969c342cdd314eb8e69d7096c82.html