1.下载并解压xtrabackup
[root@myrep1 tmp]# tar -zxvf percona-xtrabackup-2.3.2-Linux-x86_64.tar.gz
[root@myrep1 tmp]# ll
total 367484
drwxr-xr-x. 5 root root 4096 Oct 17 02:50 percona-xtrabackup-2.3.2-Linux-x86_64
-rw-r--r--. 1 root root 26753461 Dec 10 2015 percona-xtrabackup-2.3.2-Linux-x86_64.tar.gz
-rw-------. 1 root root 0 Dec 10 05:10 yum.log
[root@myrep1 tmp]#
[root@myrep1 tmp]#
[root@myrep1 tmp]#
[root@myrep1 tmp]# mv percona-xtrabackup-2.3.2-Linux-x86_64 /usr/local/xtrabackup
[root@myrep1 tmp]# 设置用户环境
[root@myrep1 tmp]#
[root@myrep1 tmp]# echo "export PATH=\$PATH:/usr/local/mysql/bin:/usr/local/xtrabackup/bin" >> /etc/profile
[root@myrep1 tmp]# source /etc/profile
[root@myrep1 tmp]# 2.创建备份用户
mysql>
mysql>
mysql> create user 'backup'@'%' identified by 'backup';
Query OK, 0 rows affected (0.02 sec)
mysql> grant reload,lock tables,replication client,create tablespace,super on *.* to 'backup'@'%';
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> 3.创建全备份，在/dbdata/backup/full下。
建立测试数据库lucien，建立测试表并插入数据。
mysql>
mysql>
mysql> select * from lijingkuan;
+----+----------+
| id | name |
+----+----------+
| 1 | shandong |
| 2 | beijing |
| 3 | hebei |
+----+----------+
3 rows in set (0.00 sec)
mysql>
mysql>
全备份
[root@myrep1 ~]#
[root@myrep1 ~]#
[root@myrep1 ~]#
[root@myrep1 ~]#
[root@myrep1 ~]# innobackupex --user=backup --password=backup /dbdata/backup/full/
151210 14:57:02 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!".
151210 14:57:02 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/dbdata/aux/mysqlsock.sock' as 'backup' (using password: YES).
Failed to connect to MySQL server as DBD::mysql module is not installed at - line 1327.
151210 14:57:02 Connecting to MySQL server host: localhost, user: backup, password: set, port: 3306, socket: /dbdata/aux/mysqlsock.sock
Using server version 5.6.27-log
innobackupex version 2.3.2 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 306a2e0)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /dbdata/data
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = ../ibdata
xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup: innodb_log_group_home_dir = ../iblogs
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 52428800
151210 14:57:02 >> log scanned up to (292683999)
xtrabackup: Generating a list of tablespaces
151210 14:57:03 [01] Copying ../ibdata/ibdata1 to /dbdata/backup/full//2015-12-10_14-57-02/ibdata1
151210 14:57:03 [01] ...done
151210 14:57:03 [01] Copying ./mysql/slave_master_info.ibd to /dbdata/backup/full//2015-12-10_14-57-02/mysql/slave_master_info.ibd
151210 14:57:03 [01] ...done
151210 14:57:03 [01] Copying ./mysql/innodb_table_stats.ibd to /dbdata/backup/full//2015-12-10_14-57-02/mysql/innodb_table_stats.ibd
151210 14:57:03 [01] ...done
151210 14:57:03 [01] Copying ./mysql/slave_relay_log_info.ibd to /dbdata/backup/full//2015-12-10_14-57-02/mysql/slave_relay_log_info.ibd
151210 14:57:03 [01] ...done
151210 14:57:03 [01] Copying ./mysql/innodb_index_stats.ibd to /dbdata/backup/full//2015-12-10_14-57-02/mysql/innodb_index_stats.ibd
151210 14:57:03 [01] ...done
151210 14:57:03 [01] Copying ./mysql/slave_worker_info.ibd to /dbdata/backup/full//2015-12-10_14-57-02/mysql/slave_worker_info.ibd
151210 14:57:03 [01] ...done
151210 14:57:03 [01] Copying ./employees/employees.ibd to /dbdata/backup/full//2015-12-10_14-57-02/employees/employees.ibd
151210 14:57:03 >> log scanned up to (292683999)
151210 14:57:03 [01] ...done
151210 14:57:04 [01] Copying ./employees/dept_manager.ibd to /dbdata/backup/full//2015-12-10_14-57-02/employees/dept_manager.ibd
151210 14:57:04 [01] ...done
151210 14:57:04 [01] Copying ./employees/departments.ibd to /dbdata/backup/full//2015-12-10_14-57-02/employees/departments.ibd
151210 14:57:04 [01] ...done
151210 14:57:04 [01] Copying ./employees/salaries.ibd to /dbdata/backup/full//2015-12-10_14-57-02/employees/salaries.ibd
151210 14:57:04 >> log scanned up to (292683999)
151210 14:57:05 >> log scanned up to (292683999)
151210 14:57:06 [01] ...done
151210 14:57:06 [01] Copying ./employees/dept_emp.ibd to /dbdata/backup/full//2015-12-10_14-57-02/employees/dept_emp.ibd
151210 14:57:06 [01] ...done
151210 14:57:06 [01] Copying ./employees/titles.ibd to /dbdata/backup/full//2015-12-10_14-57-02/employees/titles.ibd
151210 14:57:06 >> log scanned up to (292683999)
151210 14:57:07 [01] ...done
151210 14:57:07 [01] Copying ./lucien/lijingkuan.ibd to /dbdata/backup/full//2015-12-10_14-57-02/lucien/lijingkuan.ibd
151210 14:57:07 [01] ...done
151210 14:57:07 >> log scanned up to (292683999)
Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
151210 14:57:08 Executing FLUSH TABLES WITH READ LOCK...
151210 14:57:08 Starting to backup non-InnoDB tables and files
151210 14:57:08 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/table_io_waits_summary_by_table.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_statements_history.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_statements_history.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_waits_summary_by_host_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/session_connect_attrs.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/session_connect_attrs.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_statements_history_long.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_statements_history_long.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/hosts.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/hosts.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/socket_summary_by_instance.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_waits_summary_by_instance.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_stages_summary_by_host_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_waits_summary_by_user_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_stages_summary_by_account_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_stages_history.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_stages_history.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/socket_summary_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_waits_summary_by_account_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/mutex_instances.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/mutex_instances.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_stages_summary_global_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_statements_current.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_statements_current.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/rwlock_instances.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/rwlock_instances.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_stages_current.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_stages_current.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_waits_summary_global_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_stages_summary_by_thread_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/accounts.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/accounts.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/setup_consumers.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/setup_consumers.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/objects_summary_global_by_type.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_stages_history_long.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_stages_history_long.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/file_instances.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/file_instances.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_statements_summary_by_host_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_statements_summary_by_thread_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_waits_current.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_waits_current.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/setup_timers.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/setup_timers.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_statements_summary_by_account_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/performance_timers.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/performance_timers.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/socket_instances.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/socket_instances.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_waits_history.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_waits_history.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/setup_actors.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/setup_actors.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_statements_summary_global_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_waits_history_long.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_waits_history_long.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/file_summary_by_instance.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/file_summary_by_instance.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_stages_summary_by_user_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_statements_summary_by_user_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/table_lock_waits_summary_by_table.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_statements_summary_by_digest.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/events_waits_summary_by_thread_by_event_name.frm
151210 14:57:08 [01] ...done
151210 14:57:08 >> log scanned up to (292683999)
151210 14:57:08 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/session_account_connect_attrs.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/host_cache.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/host_cache.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/setup_objects.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/setup_objects.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/users.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/users.frm
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/db.opt to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/db.opt
151210 14:57:08 [01] ...done
151210 14:57:08 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/table_io_waits_summary_by_index_usage.frm
151210 14:57:08 [01] ...done
151210 14:57:09 [01] Copying ./performance_schema/setup_instruments.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/setup_instruments.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./performance_schema/cond_instances.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/cond_instances.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/file_summary_by_event_name.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./performance_schema/threads.frm to /dbdata/backup/full//2015-12-10_14-57-02/performance_schema/threads.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [00] Writing test/db.opt
151210 14:57:09 [00] ...done
151210 14:57:09 [01] Copying ./mysql/event.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/event.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/ndb_binlog_index.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/ndb_binlog_index.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/time_zone_transition.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone_transition.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/help_relation.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/help_relation.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/func.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/func.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/ndb_binlog_index.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/ndb_binlog_index.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/innodb_index_stats.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/innodb_index_stats.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/time_zone_name.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone_name.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/tables_priv.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/tables_priv.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/func.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/func.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/slow_log.CSV to /dbdata/backup/full//2015-12-10_14-57-02/mysql/slow_log.CSV
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/plugin.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/plugin.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/procs_priv.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/procs_priv.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/help_keyword.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/help_keyword.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/help_topic.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/help_topic.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/db.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/db.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/event.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/event.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/user.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/user.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/proxies_priv.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/proxies_priv.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/servers.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/servers.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/time_zone_leap_second.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone_leap_second.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/time_zone_transition.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone_transition.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/proxies_priv.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/proxies_priv.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/slow_log.CSM to /dbdata/backup/full//2015-12-10_14-57-02/mysql/slow_log.CSM
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/proxies_priv.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/proxies_priv.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/time_zone_name.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone_name.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/tables_priv.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/tables_priv.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/proc.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/proc.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/user.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/user.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/help_category.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/help_category.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/columns_priv.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/columns_priv.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/innodb_table_stats.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/innodb_table_stats.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/time_zone_name.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone_name.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/servers.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/servers.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/help_keyword.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/help_keyword.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/procs_priv.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/procs_priv.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/columns_priv.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/columns_priv.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/user.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/user.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/help_category.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/help_category.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/time_zone_transition.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone_transition.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/time_zone_transition_type.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone_transition_type.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/servers.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/servers.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/help_relation.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/help_relation.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/event.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/event.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/help_topic.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/help_topic.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/db.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/db.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/tables_priv.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/tables_priv.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/help_topic.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/help_topic.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/slave_relay_log_info.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/slave_relay_log_info.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/time_zone.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/general_log.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/general_log.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/proc.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/proc.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/plugin.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/plugin.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/slow_log.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/slow_log.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/time_zone_leap_second.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone_leap_second.MYD
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/db.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/db.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/slave_worker_info.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/slave_worker_info.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/time_zone.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/help_relation.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/help_relation.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/time_zone_transition_type.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone_transition_type.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/help_category.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/help_category.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/general_log.CSV to /dbdata/backup/full//2015-12-10_14-57-02/mysql/general_log.CSV
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/help_keyword.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/help_keyword.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/procs_priv.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/procs_priv.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/slave_master_info.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/slave_master_info.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/time_zone.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone.frm
151210 14:57:09 [01] ...done
151210 14:57:09 >> log scanned up to (292683999)
151210 14:57:09 [01] Copying ./mysql/ndb_binlog_index.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/ndb_binlog_index.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/time_zone_leap_second.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone_leap_second.MYI
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/columns_priv.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/columns_priv.frm
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/general_log.CSM to /dbdata/backup/full//2015-12-10_14-57-02/mysql/general_log.CSM
151210 14:57:09 [01] ...done
151210 14:57:09 [01] Copying ./mysql/proc.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/proc.MYI
151210 14:57:09 [01] ...done
151210 14:57:10 [01] Copying ./mysql/plugin.frm to /dbdata/backup/full//2015-12-10_14-57-02/mysql/plugin.frm
151210 14:57:10 [01] ...done
151210 14:57:10 [01] Copying ./mysql/func.MYI to /dbdata/backup/full//2015-12-10_14-57-02/mysql/func.MYI
151210 14:57:10 [01] ...done
151210 14:57:10 [01] Copying ./mysql/time_zone_transition_type.MYD to /dbdata/backup/full//2015-12-10_14-57-02/mysql/time_zone_transition_type.MYD
151210 14:57:10 [01] ...done
151210 14:57:10 [01] Copying ./employees/dept_manager.frm to /dbdata/backup/full//2015-12-10_14-57-02/employees/dept_manager.frm
151210 14:57:10 [01] ...done
151210 14:57:10 [01] Copying ./employees/dept_emp.frm to /dbdata/backup/full//2015-12-10_14-57-02/employees/dept_emp.frm
151210 14:57:10 [01] ...done
151210 14:57:10 [01] Copying ./employees/departments.frm to /dbdata/backup/full//2015-12-10_14-57-02/employees/departments.frm
151210 14:57:10 [01] ...done
151210 14:57:10 [01] Copying ./employees/dept_emp_latest_date.frm to /dbdata/backup/full//2015-12-10_14-57-02/employees/dept_emp_latest_date.frm
151210 14:57:10 [01] ...done
151210 14:57:10 [01] Copying ./employees/current_dept_emp.frm to /dbdata/backup/full//2015-12-10_14-57-02/employees/current_dept_emp.frm
151210 14:57:10 [01] ...done
151210 14:57:10 [01] Copying ./employees/titles.frm to /dbdata/backup/full//2015-12-10_14-57-02/employees/titles.frm
151210 14:57:10 [01] ...done
151210 14:57:10 [01] Copying ./employees/db.opt to /dbdata/backup/full//2015-12-10_14-57-02/employees/db.opt
151210 14:57:10 [01] ...done
151210 14:57:10 [01] Copying ./employees/employees.frm to /dbdata/backup/full//2015-12-10_14-57-02/employees/employees.frm
151210 14:57:10 [01] ...done
151210 14:57:10 [01] Copying ./employees/salaries.frm to /dbdata/backup/full//2015-12-10_14-57-02/employees/salaries.frm
151210 14:57:10 [01] ...done
151210 14:57:10 [01] Copying ./lucien/lijingkuan.frm to /dbdata/backup/full//2015-12-10_14-57-02/lucien/lijingkuan.frm
151210 14:57:10 [01] ...done
151210 14:57:10 [01] Copying ./lucien/db.opt to /dbdata/backup/full//2015-12-10_14-57-02/lucien/db.opt
151210 14:57:10 [01] ...done
151210 14:57:10 Finished backing up non-InnoDB tables and files
151210 14:57:10 [00] Writing xtrabackup_binlog_info
151210 14:57:10 [00] ...done
151210 14:57:10 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '292683999'
xtrabackup: Stopping log copying thread.
.151210 14:57:10 >> log scanned up to (292683999)
151210 14:57:10 Executing UNLOCK TABLES
151210 14:57:10 All tables unlocked
151210 14:57:10 Backup created in directory '/dbdata/backup/full//2015-12-10_14-57-02'
MySQL binlog position: filename 'mysql-bin.000002', position '200188649'
151210 14:57:10 [00] Writing backup-my.cnf
151210 14:57:10 [00] ...done
151210 14:57:10 [00] Writing xtrabackup_info
151210 14:57:10 [00] ...done
xtrabackup: Transaction log of lsn (292683999) to (292683999) was copied.
151210 14:57:10 completed OK!
[root@myrep1 ~]#
[root@myrep1 ~]#
[root@myrep1 ~]#
[root@myrep1 ~]#
[root@myrep1 ~]#
==========================================================================================================
备份开始时报错，目前还不确定是否因为这个错误导致接下来恢复失败，innodb表里的数据无法读取：
151210 14:57:02 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/dbdata/aux/mysqlsock.sock' as 'backup' (using password: YES).
Failed to connect to MySQL server as DBD::mysql module is not installed at - line 1327.
yum install perl-DBI
yum install perl-DBD-MySQL
yum install perl-Time-HiRes
yum install perl-IO-Socket-SSL
==========================================================================================================
安装好perl相关模块后，备份过程中不再有报错信息：
[root@myrep1 ~]#
[root@myrep1 ~]#
[root@myrep1 ~]# innobackupex --user=backup --password=backup /dbdata/backup/full/
151213 07:03:45 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!".
151213 07:03:45 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/dbdata/aux/mysqlsock.sock' as 'backup' (using password: YES).
151213 07:03:45 version_check Connected to MySQL server
151213 07:03:45 version_check Executing a version check against the server...
151213 07:03:45 version_check Done.
151213 07:03:45 Connecting to MySQL server host: localhost, user: backup, password: set, port: 3306, socket: /dbdata/aux/mysqlsock.sock
Using server version 5.6.27-log
innobackupex version 2.3.2 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 306a2e0)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /dbdata/data
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = ../ibdata
xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup: innodb_log_group_home_dir = ../iblogs
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 52428800
151213 07:03:46 >> log scanned up to (292685083)
xtrabackup: Generating a list of tablespaces
151213 07:03:46 [01] Copying ../ibdata/ibdata1 to /dbdata/backup/full//2015-12-13_07-03-45/ibdata1
151213 07:03:46 [01] ...done
151213 07:03:46 [01] Copying ./mysql/slave_master_info.ibd to /dbdata/backup/full//2015-12-13_07-03-45/mysql/slave_master_info.ibd
151213 07:03:46 [01] ...done
151213 07:03:46 [01] Copying ./mysql/innodb_table_stats.ibd to /dbdata/backup/full//2015-12-13_07-03-45/mysql/innodb_table_stats.ibd
151213 07:03:46 [01] ...done
151213 07:03:46 [01] Copying ./mysql/slave_relay_log_info.ibd to /dbdata/backup/full//2015-12-13_07-03-45/mysql/slave_relay_log_info.ibd
151213 07:03:46 [01] ...done
151213 07:03:46 [01] Copying ./mysql/innodb_index_stats.ibd to /dbdata/backup/full//2015-12-13_07-03-45/mysql/innodb_index_stats.ibd
151213 07:03:46 [01] ...done
151213 07:03:46 [01] Copying ./mysql/slave_worker_info.ibd to /dbdata/backup/full//2015-12-13_07-03-45/mysql/slave_worker_info.ibd
151213 07:03:46 [01] ...done
151213 07:03:46 [01] Copying ./employees/employees.ibd to /dbdata/backup/full//2015-12-13_07-03-45/employees/employees.ibd
151213 07:03:46 [01] ...done
151213 07:03:46 [01] Copying ./employees/dept_manager.ibd to /dbdata/backup/full//2015-12-13_07-03-45/employees/dept_manager.ibd
151213 07:03:46 [01] ...done
151213 07:03:46 [01] Copying ./employees/departments.ibd to /dbdata/backup/full//2015-12-13_07-03-45/employees/departments.ibd
151213 07:03:46 [01] ...done
151213 07:03:46 [01] Copying ./employees/salaries.ibd to /dbdata/backup/full//2015-12-13_07-03-45/employees/salaries.ibd
151213 07:03:47 >> log scanned up to (292685083)
151213 07:03:48 >> log scanned up to (292685083)
151213 07:03:48 [01] ...done
151213 07:03:48 [01] Copying ./employees/dept_emp.ibd to /dbdata/backup/full//2015-12-13_07-03-45/employees/dept_emp.ibd
151213 07:03:48 [01] ...done
151213 07:03:48 [01] Copying ./employees/titles.ibd to /dbdata/backup/full//2015-12-13_07-03-45/employees/titles.ibd
151213 07:03:49 >> log scanned up to (292685083)
151213 07:03:49 [01] ...done
151213 07:03:49 [01] Copying ./lucien/lijingkuan.ibd to /dbdata/backup/full//2015-12-13_07-03-45/lucien/lijingkuan.ibd
151213 07:03:49 [01] ...done
151213 07:03:50 >> log scanned up to (292685083)
Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
151213 07:03:50 Executing FLUSH TABLES WITH READ LOCK...
151213 07:03:50 Starting to backup non-InnoDB tables and files
151213 07:03:50 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/table_io_waits_summary_by_table.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_statements_history.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_statements_history.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_waits_summary_by_host_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/session_connect_attrs.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/session_connect_attrs.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_statements_history_long.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_statements_history_long.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/hosts.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/hosts.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/socket_summary_by_instance.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_waits_summary_by_instance.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_stages_summary_by_host_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_waits_summary_by_user_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_stages_summary_by_account_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_stages_history.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_stages_history.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/socket_summary_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_waits_summary_by_account_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/mutex_instances.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/mutex_instances.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_stages_summary_global_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_statements_current.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_statements_current.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/rwlock_instances.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/rwlock_instances.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_stages_current.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_stages_current.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_waits_summary_global_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_stages_summary_by_thread_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/accounts.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/accounts.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/setup_consumers.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/setup_consumers.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/objects_summary_global_by_type.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_stages_history_long.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_stages_history_long.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/file_instances.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/file_instances.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_statements_summary_by_host_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_statements_summary_by_thread_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_waits_current.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_waits_current.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/setup_timers.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/setup_timers.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_statements_summary_by_account_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/performance_timers.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/performance_timers.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/socket_instances.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/socket_instances.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_waits_history.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_waits_history.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/setup_actors.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/setup_actors.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_statements_summary_global_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_waits_history_long.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_waits_history_long.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/file_summary_by_instance.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/file_summary_by_instance.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_stages_summary_by_user_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_statements_summary_by_user_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/table_lock_waits_summary_by_table.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_statements_summary_by_digest.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/events_waits_summary_by_thread_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/session_account_connect_attrs.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/host_cache.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/host_cache.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/setup_objects.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/setup_objects.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/users.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/users.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/db.opt to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/db.opt
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/table_io_waits_summary_by_index_usage.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/setup_instruments.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/setup_instruments.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/cond_instances.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/cond_instances.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/file_summary_by_event_name.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./performance_schema/threads.frm to /dbdata/backup/full//2015-12-13_07-03-45/performance_schema/threads.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [00] Writing test/db.opt
151213 07:03:50 [00] ...done
151213 07:03:50 [01] Copying ./mysql/event.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/event.MYD
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/ndb_binlog_index.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/ndb_binlog_index.MYD
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/time_zone_transition.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone_transition.MYI
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/help_relation.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/help_relation.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/func.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/func.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/ndb_binlog_index.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/ndb_binlog_index.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/innodb_index_stats.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/innodb_index_stats.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/time_zone_name.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone_name.MYD
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/tables_priv.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/tables_priv.MYD
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/func.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/func.MYD
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/slow_log.CSV to /dbdata/backup/full//2015-12-13_07-03-45/mysql/slow_log.CSV
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/plugin.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/plugin.MYD
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/procs_priv.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/procs_priv.MYD
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/help_keyword.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/help_keyword.MYD
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/help_topic.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/help_topic.MYD
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/db.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/db.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/event.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/event.MYI
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/user.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/user.MYD
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/proxies_priv.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/proxies_priv.MYD
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/servers.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/servers.MYI
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/time_zone_leap_second.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone_leap_second.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/time_zone_transition.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone_transition.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/proxies_priv.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/proxies_priv.MYI
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/slow_log.CSM to /dbdata/backup/full//2015-12-13_07-03-45/mysql/slow_log.CSM
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/proxies_priv.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/proxies_priv.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/time_zone_name.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone_name.MYI
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/tables_priv.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/tables_priv.MYI
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/proc.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/proc.MYD
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/user.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/user.frm
151213 07:03:50 [01] ...done
151213 07:03:50 [01] Copying ./mysql/help_category.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/help_category.MYI
151213 07:03:50 [01] ...done
151213 07:03:51 [01] Copying ./mysql/columns_priv.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/columns_priv.MYD
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/innodb_table_stats.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/innodb_table_stats.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/time_zone_name.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone_name.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/servers.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/servers.MYD
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/help_keyword.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/help_keyword.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/procs_priv.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/procs_priv.frm
151213 07:03:51 [01] ...done
151213 07:03:51 >> log scanned up to (292685083)
151213 07:03:51 [01] Copying ./mysql/columns_priv.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/columns_priv.MYI
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/user.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/user.MYI
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/help_category.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/help_category.MYD
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/time_zone_transition.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone_transition.MYD
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/time_zone_transition_type.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone_transition_type.MYI
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/servers.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/servers.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/help_relation.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/help_relation.MYD
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/event.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/event.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/help_topic.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/help_topic.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/db.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/db.MYD
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/tables_priv.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/tables_priv.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/help_topic.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/help_topic.MYI
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/slave_relay_log_info.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/slave_relay_log_info.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/time_zone.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone.MYD
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/general_log.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/general_log.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/proc.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/proc.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/plugin.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/plugin.MYI
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/slow_log.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/slow_log.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/time_zone_leap_second.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone_leap_second.MYD
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/db.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/db.MYI
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/slave_worker_info.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/slave_worker_info.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/time_zone.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone.MYI
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/help_relation.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/help_relation.MYI
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/time_zone_transition_type.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone_transition_type.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/help_category.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/help_category.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/general_log.CSV to /dbdata/backup/full//2015-12-13_07-03-45/mysql/general_log.CSV
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/help_keyword.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/help_keyword.MYI
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/procs_priv.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/procs_priv.MYI
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/slave_master_info.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/slave_master_info.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/time_zone.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/ndb_binlog_index.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/ndb_binlog_index.MYI
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/time_zone_leap_second.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone_leap_second.MYI
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/columns_priv.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/columns_priv.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/general_log.CSM to /dbdata/backup/full//2015-12-13_07-03-45/mysql/general_log.CSM
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/proc.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/proc.MYI
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/plugin.frm to /dbdata/backup/full//2015-12-13_07-03-45/mysql/plugin.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/func.MYI to /dbdata/backup/full//2015-12-13_07-03-45/mysql/func.MYI
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./mysql/time_zone_transition_type.MYD to /dbdata/backup/full//2015-12-13_07-03-45/mysql/time_zone_transition_type.MYD
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./employees/dept_manager.frm to /dbdata/backup/full//2015-12-13_07-03-45/employees/dept_manager.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./employees/dept_emp.frm to /dbdata/backup/full//2015-12-13_07-03-45/employees/dept_emp.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./employees/departments.frm to /dbdata/backup/full//2015-12-13_07-03-45/employees/departments.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./employees/dept_emp_latest_date.frm to /dbdata/backup/full//2015-12-13_07-03-45/employees/dept_emp_latest_date.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./employees/current_dept_emp.frm to /dbdata/backup/full//2015-12-13_07-03-45/employees/current_dept_emp.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./employees/titles.frm to /dbdata/backup/full//2015-12-13_07-03-45/employees/titles.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./employees/db.opt to /dbdata/backup/full//2015-12-13_07-03-45/employees/db.opt
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./employees/employees.frm to /dbdata/backup/full//2015-12-13_07-03-45/employees/employees.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./employees/salaries.frm to /dbdata/backup/full//2015-12-13_07-03-45/employees/salaries.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./lucien/lijingkuan.frm to /dbdata/backup/full//2015-12-13_07-03-45/lucien/lijingkuan.frm
151213 07:03:51 [01] ...done
151213 07:03:51 [01] Copying ./lucien/db.opt to /dbdata/backup/full//2015-12-13_07-03-45/lucien/db.opt
151213 07:03:51 [01] ...done
151213 07:03:51 Finished backing up non-InnoDB tables and files
151213 07:03:51 [00] Writing xtrabackup_binlog_info
151213 07:03:51 [00] ...done
151213 07:03:51 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '292685083'
xtrabackup: Stopping log copying thread.
.151213 07:03:51 >> log scanned up to (292685083)
151213 07:03:51 Executing UNLOCK TABLES
151213 07:03:51 All tables unlocked
151213 07:03:51 Backup created in directory '/dbdata/backup/full//2015-12-13_07-03-45'
MySQL binlog position: filename 'mysql-bin.000005', position '332'
151213 07:03:51 [00] Writing backup-my.cnf
151213 07:03:51 [00] ...done
151213 07:03:51 [00] Writing xtrabackup_info
151213 07:03:51 [00] ...done
xtrabackup: Transaction log of lsn (292685083) to (292685083) was copied.
151213 07:03:51 completed OK!
[root@myrep1 ~]#
[root@myrep1 ~]#
[root@myrep1 ~]#
[root@myrep1 ~]#
[root@myrep1 ~]# cd /dbdata/backup/full/2015-12-10_14-57-02/
[root@myrep1 2015-12-10_14-57-02]# ll
total 12328
-rw-r-----. 1 root root 386 Dec 10 14:57 backup-my.cnf
drwx------. 2 root root 4096 Dec 10 14:57 employees
-rw-r-----. 1 root root 12582912 Dec 10 14:57 ibdata1
drwx------. 2 root root 4096 Dec 10 14:57 lucien
drwx------. 2 root root 4096 Dec 10 14:57 mysql
drwx------. 2 root root 4096 Dec 10 14:57 performance_schema
drwx------. 2 root root 4096 Dec 10 14:57 test
-rw-r-----. 1 root root 27 Dec 10 14:57 xtrabackup_binlog_info
-rw-r-----. 1 root root 117 Dec 10 14:57 xtrabackup_checkpoints
-rw-r-----. 1 root root 486 Dec 10 14:57 xtrabackup_info
-rw-r-----. 1 root root 2560 Dec 10 14:57 xtrabackup_logfile
[root@myrep1 2015-12-10_14-57-02]#
[root@myrep1 2015-12-10_14-57-02]# 查看生成的备份文件（安装perl模块之后）
[root@myrep1 ~]#
[root@myrep1 ~]#
[root@myrep1 ~]# cd /dbdata/backup/full/
[root@myrep1 full]# ll
total 8
drwx------. 7 root root 4096 Dec 10 14:57 2015-12-10_14-57-02
drwx------. 7 root root 4096 Dec 13 07:03 2015-12-13_07-03-45
[root@myrep1 full]#
[root@myrep1 full]# 压缩生成的备份文件目录（perl之前）
[root@myrep1 full]#
[root@myrep1 full]#
[root@myrep1 full]# ll
total 4
drwx------. 7 root root 4096 Dec 10 14:57 2015-12-10_14-57-02
[root@myrep1 full]#
[root@myrep1 full]#
[root@myrep1 full]#
[root@myrep1 full]# tar -zcvf /tmp/beifen.tar.gz 2015-12-10_14-57-02/
压缩生成的备份文件目录（perl之后）
[root@myrep1 full]# tar -zcvf /tmp/beifen2.tar.gz <span style="font-family: Arial, Helvetica, sans-serif;">2015-12-13_07-03-45</span><span style="font-family: Arial, Helvetica, sans-serif;">/</span>
[root@myrep1 tmp]#
[root@myrep1 tmp]#
[root@myrep1 tmp]# ll
total 425016
-rw-r--r--. 1 root root 58915483 Dec 10 15:31 beifen.tar.gz
-rw-r--r--. 1 root root 312845162 Oct 30 23:12 mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz
-rw-r--r--. 1 root root 26753461 Dec 10 2015 percona-xtrabackup-2.3.2-Linux-x86_64.tar.gz
-rw-------. 1 root root 0 Dec 10 05:10 yum.log
[root@myrep1 tmp]#
[root@myrep1 tmp]#
[root@myrep1 tmp]# scp beifen.tar.gz mysql@192.168.56.102:/dbdata/backup/full/
mysql@192.168.56.102's password:
beifen.tar.gz 100% 56MB 9.4MB/s 00:06
[root@myrep1 tmp]#
[root@myrep1 tmp]#
[root@myrep1 tmp]#
[root@myrep1 tmp]# scp beifen2.tar.gz mysql@192.168.56.102:/dbdata/backup/full/
mysql@192.168.56.102's password:
beifen2.tar.gz 100% 56MB 18.7MB/s 00:03
[root@myrep1 tmp]#
[root@myrep1 tmp]#
[root@myrep2 full]#
[root@myrep2 full]#
[root@myrep2 full]# ll
total 57536
-rw-r--r--. 1 mysql mysql 58915483 Dec 10 15:35 beifen.tar.gz
[root@myrep2 full]#
[root@myrep2 full]#
[root@myrep2 full]# tar -zxvf beifen.tar.gz
[root@myrep2 full]#
[root@myrep2 full]#
[root@myrep2 full]# ll
total 57540
drwx------. 7 root root 4096 Dec 10 14:57 2015-12-10_14-57-02
-rw-r--r--. 1 mysql mysql 58915483 Dec 10 15:35 beifen.tar.gz
[root@myrep2 full]#
[root@myrep2 full]#
[root@myrep2 full]# cd 2015-12-10_14-57-02/
[root@myrep2 2015-12-10_14-57-02]#
[root@myrep2 2015-12-10_14-57-02]#
[root@myrep2 2015-12-10_14-57-02]#
[root@myrep2 2015-12-10_14-57-02]# ll
total 12328
-rw-r-----. 1 root root 386 Dec 10 14:57 backup-my.cnf
drwx------. 2 root root 4096 Dec 10 14:57 employees
-rw-r-----. 1 root root 12582912 Dec 10 14:57 ibdata1
drwx------. 2 root root 4096 Dec 10 14:57 lucien
drwx------. 2 root root 4096 Dec 10 14:57 mysql
drwx------. 2 root root 4096 Dec 10 14:57 performance_schema
drwx------. 2 root root 4096 Dec 10 14:57 test
-rw-r-----. 1 root root 27 Dec 10 14:57 xtrabackup_binlog_info
-rw-r-----. 1 root root 117 Dec 10 14:57 xtrabackup_checkpoints
-rw-r-----. 1 root root 486 Dec 10 14:57 xtrabackup_info
-rw-r-----. 1 root root 2560 Dec 10 14:57 xtrabackup_logfile
[root@myrep2 2015-12-10_14-57-02]#
[root@myrep2 2015-12-10_14-57-02]#
[root@myrep2 2015-12-10_14-57-02]# [root@myrep2 full]# tar -zxvf beifen2.tar.gz
[root@myrep2 full]#
[root@myrep2 full]# ll
total 115080
drwx------. 7 mysql mysql 4096 Dec 10 15:45 2015-12-10_14-57-02
drwx------. 7 root root 4096 Dec 13 07:03 2015-12-13_07-03-45
-rw-r--r--. 1 mysql mysql 58906158 Dec 13 07:12 beifen2.tar.gz
-rw-r--r--. 1 mysql mysql 58915483 Dec 10 15:35 beifen.tar.gz
drwx------. 2 mysql mysql 4096 Dec 10 15:55 ibdata
drwx------. 2 mysql mysql 4096 Dec 10 15:55 iblogs
[root@myrep2 full]#
[root@myrep2 full]# cd 2015-12-13_07-03-45/
[root@myrep2 2015-12-13_07-03-45]# ll
total 12328
-rw-r-----. 1 root root 386 Dec 13 07:03 backup-my.cnf
drwx------. 2 root root 4096 Dec 13 07:03 employees
-rw-r-----. 1 root root 12582912 Dec 13 07:03 ibdata1
drwx------. 2 root root 4096 Dec 13 07:03 lucien
drwx------. 2 root root 4096 Dec 13 07:03 mysql
drwx------. 2 root root 4096 Dec 13 07:03 performance_schema
drwx------. 2 root root 4096 Dec 13 07:03 test
-rw-r-----. 1 root root 21 Dec 13 07:03 xtrabackup_binlog_info
-rw-r-----. 1 root root 117 Dec 13 07:03 xtrabackup_checkpoints
-rw-r-----. 1 root root 480 Dec 13 07:03 xtrabackup_info
-rw-r-----. 1 root root 2560 Dec 13 07:03 xtrabackup_logfile
[root@myrep2 2015-12-13_07-03-45]#
[root@myrep2 2015-12-13_07-03-45]#
恢复，应用日志
[root@myrep2 ~]#
[root@myrep2 ~]#
[root@myrep2 ~]# innobackupex --apply-log /dbdata/backup/full/2015-12-10_14-57-02/
151210 15:45:43 innobackupex: Starting the apply-log operation
IMPORTANT: Please check that the apply-log run completes successfully.
At the end of a successful apply-log run innobackupex
prints "completed OK!".
innobackupex version 2.3.2 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 306a2e0)
xtrabackup: cd to /dbdata/backup/full/2015-12-10_14-57-02/
xtrabackup: This target seems to be not prepared yet.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(292683999)
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 1
xtrabackup: innodb_log_file_size = 2097152
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 1
xtrabackup: innodb_log_file_size = 2097152
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
InnoDB: Using atomics to ref count buffer pool pages
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Memory barrier is not used
InnoDB: Compressed tables use zlib 1.2.3
InnoDB: Not using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 100.0M
InnoDB: Completed initialization of buffer pool
InnoDB: Highest supported file format is Barracuda.
InnoDB: The log sequence numbers 1625987 and 1625987 in ibdata files do not match the log sequence number 292683999 in the ib_logfiles!
InnoDB: Database was not shutdown normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages
InnoDB: from the doublewrite buffer...
InnoDB: 128 rollback segment(s) are active.
InnoDB: Waiting for purge to start
InnoDB: 5.6.24 started; log sequence number 292683999
xtrabackup: Last MySQL binlog file position 200188649, file name mysql-bin.000002
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 292684009
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 52428800
InnoDB: Using atomics to ref count buffer pool pages
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Memory barrier is not used
InnoDB: Compressed tables use zlib 1.2.3
InnoDB: Not using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 100.0M
InnoDB: Completed initialization of buffer pool
InnoDB: Setting log file ./ib_logfile101 size to 50 MB
InnoDB: Setting log file ./ib_logfile1 size to 50 MB
InnoDB: Setting log file ./ib_logfile2 size to 50 MB
InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
InnoDB: New log files created, LSN=292684009
InnoDB: Highest supported file format is Barracuda.
InnoDB: 128 rollback segment(s) are active.
InnoDB: Waiting for purge to start
InnoDB: 5.6.24 started; log sequence number 292684300
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 292684310
151210 15:45:52 completed OK!
[root@myrep2 ~]#
[root@myrep2 ~]#
[root@myrep2 ~]#
[root@myrep2 ~]#
[root@myrep2 ~]#
[root@myrep2 ~]#
[root@myrep2 ~]# innobackupex --defaults-file=/etc/my.cnf --copy-back --rsync /dbdata/backup/full/2015-12-10_14-57-02/
151210 15:55:27 innobackupex: Starting the copy-back operation
IMPORTANT: Please check that the copy-back run completes successfully.
At the end of a successful copy-back run innobackupex
prints "completed OK!".
innobackupex version 2.3.2 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 306a2e0)
151210 15:55:27 [01] Copying ib_logfile0 to ../iblogs/ib_logfile0
151210 15:55:28 [01] ...done
151210 15:55:28 [01] Copying ib_logfile1 to ../iblogs/ib_logfile1
151210 15:55:28 [01] ...done
151210 15:55:28 [01] Copying ib_logfile2 to ../iblogs/ib_logfile2
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ibdata1 to ../ibdata/ibdata1
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/func.frm to /dbdata/data/mysql/func.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/slave_worker_info.frm to /dbdata/data/mysql/slave_worker_info.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/innodb_table_stats.frm to /dbdata/data/mysql/innodb_table_stats.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/help_relation.frm to /dbdata/data/mysql/help_relation.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone_name.MYD to /dbdata/data/mysql/time_zone_name.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/help_topic.frm to /dbdata/data/mysql/help_topic.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/general_log.CSV to /dbdata/data/mysql/general_log.CSV
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone_transition_type.MYD to /dbdata/data/mysql/time_zone_transition_type.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/slow_log.CSM to /dbdata/data/mysql/slow_log.CSM
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/proxies_priv.MYD to /dbdata/data/mysql/proxies_priv.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/procs_priv.MYI to /dbdata/data/mysql/procs_priv.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/func.MYI to /dbdata/data/mysql/func.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/slow_log.frm to /dbdata/data/mysql/slow_log.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/general_log.CSM to /dbdata/data/mysql/general_log.CSM
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/user.frm to /dbdata/data/mysql/user.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone_transition.MYD to /dbdata/data/mysql/time_zone_transition.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/func.MYD to /dbdata/data/mysql/func.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/event.MYD to /dbdata/data/mysql/event.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/proxies_priv.frm to /dbdata/data/mysql/proxies_priv.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/innodb_index_stats.frm to /dbdata/data/mysql/innodb_index_stats.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/db.MYD to /dbdata/data/mysql/db.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/plugin.MYI to /dbdata/data/mysql/plugin.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone.MYI to /dbdata/data/mysql/time_zone.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone_transition_type.frm to /dbdata/data/mysql/time_zone_transition_type.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/db.MYI to /dbdata/data/mysql/db.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone_name.frm to /dbdata/data/mysql/time_zone_name.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/db.frm to /dbdata/data/mysql/db.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/general_log.frm to /dbdata/data/mysql/general_log.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/plugin.MYD to /dbdata/data/mysql/plugin.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/servers.MYI to /dbdata/data/mysql/servers.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/help_topic.MYD to /dbdata/data/mysql/help_topic.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone_leap_second.MYD to /dbdata/data/mysql/time_zone_leap_second.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/slave_worker_info.ibd to /dbdata/data/mysql/slave_worker_info.ibd
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/help_category.frm to /dbdata/data/mysql/help_category.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/proxies_priv.MYI to /dbdata/data/mysql/proxies_priv.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/tables_priv.MYI to /dbdata/data/mysql/tables_priv.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/plugin.frm to /dbdata/data/mysql/plugin.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/ndb_binlog_index.MYD to /dbdata/data/mysql/ndb_binlog_index.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone.frm to /dbdata/data/mysql/time_zone.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/servers.MYD to /dbdata/data/mysql/servers.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/slave_master_info.ibd to /dbdata/data/mysql/slave_master_info.ibd
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/tables_priv.frm to /dbdata/data/mysql/tables_priv.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/proc.frm to /dbdata/data/mysql/proc.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone_leap_second.MYI to /dbdata/data/mysql/time_zone_leap_second.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/ndb_binlog_index.MYI to /dbdata/data/mysql/ndb_binlog_index.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/help_relation.MYI to /dbdata/data/mysql/help_relation.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/slow_log.CSV to /dbdata/data/mysql/slow_log.CSV
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/procs_priv.MYD to /dbdata/data/mysql/procs_priv.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/user.MYD to /dbdata/data/mysql/user.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/servers.frm to /dbdata/data/mysql/servers.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/procs_priv.frm to /dbdata/data/mysql/procs_priv.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/event.MYI to /dbdata/data/mysql/event.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/slave_master_info.frm to /dbdata/data/mysql/slave_master_info.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/ndb_binlog_index.frm to /dbdata/data/mysql/ndb_binlog_index.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/help_keyword.frm to /dbdata/data/mysql/help_keyword.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone_name.MYI to /dbdata/data/mysql/time_zone_name.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone.MYD to /dbdata/data/mysql/time_zone.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/help_keyword.MYI to /dbdata/data/mysql/help_keyword.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone_transition.MYI to /dbdata/data/mysql/time_zone_transition.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/slave_relay_log_info.frm to /dbdata/data/mysql/slave_relay_log_info.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone_transition.frm to /dbdata/data/mysql/time_zone_transition.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/help_category.MYI to /dbdata/data/mysql/help_category.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/proc.MYI to /dbdata/data/mysql/proc.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/help_topic.MYI to /dbdata/data/mysql/help_topic.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/innodb_index_stats.ibd to /dbdata/data/mysql/innodb_index_stats.ibd
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/proc.MYD to /dbdata/data/mysql/proc.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/columns_priv.frm to /dbdata/data/mysql/columns_priv.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/tables_priv.MYD to /dbdata/data/mysql/tables_priv.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/slave_relay_log_info.ibd to /dbdata/data/mysql/slave_relay_log_info.ibd
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/user.MYI to /dbdata/data/mysql/user.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone_transition_type.MYI to /dbdata/data/mysql/time_zone_transition_type.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/help_keyword.MYD to /dbdata/data/mysql/help_keyword.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/help_category.MYD to /dbdata/data/mysql/help_category.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/event.frm to /dbdata/data/mysql/event.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/help_relation.MYD to /dbdata/data/mysql/help_relation.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/columns_priv.MYI to /dbdata/data/mysql/columns_priv.MYI
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/columns_priv.MYD to /dbdata/data/mysql/columns_priv.MYD
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/innodb_table_stats.ibd to /dbdata/data/mysql/innodb_table_stats.ibd
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./mysql/time_zone_leap_second.frm to /dbdata/data/mysql/time_zone_leap_second.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./xtrabackup_binlog_pos_innodb to /dbdata/data/xtrabackup_binlog_pos_innodb
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./performance_schema/events_stages_history_long.frm to /dbdata/data/performance_schema/events_stages_history_long.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./performance_schema/events_waits_history_long.frm to /dbdata/data/performance_schema/events_waits_history_long.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /dbdata/data/performance_schema/socket_summary_by_event_name.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /dbdata/data/performance_schema/socket_summary_by_instance.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /dbdata/data/performance_schema/events_stages_summary_by_account_by_event_name.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./performance_schema/rwlock_instances.frm to /dbdata/data/performance_schema/rwlock_instances.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /dbdata/data/performance_schema/events_waits_summary_by_thread_by_event_name.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./performance_schema/file_instances.frm to /dbdata/data/performance_schema/file_instances.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /dbdata/data/performance_schema/events_statements_summary_by_user_by_event_name.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./performance_schema/accounts.frm to /dbdata/data/performance_schema/accounts.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./performance_schema/socket_instances.frm to /dbdata/data/performance_schema/socket_instances.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./performance_schema/threads.frm to /dbdata/data/performance_schema/threads.frm
151210 15:55:29 [01] ...done
151210 15:55:29 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /dbdata/data/performance_schema/events_waits_summary_by_account_by_event_name.frm
151210 15:55:29 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /dbdata/data/performance_schema/file_summary_by_event_name.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /dbdata/data/performance_schema/events_stages_summary_by_host_by_event_name.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_statements_history_long.frm to /dbdata/data/performance_schema/events_statements_history_long.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/setup_consumers.frm to /dbdata/data/performance_schema/setup_consumers.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/host_cache.frm to /dbdata/data/performance_schema/host_cache.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_statements_history.frm to /dbdata/data/performance_schema/events_statements_history.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /dbdata/data/performance_schema/events_waits_summary_by_instance.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/performance_timers.frm to /dbdata/data/performance_schema/performance_timers.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/session_connect_attrs.frm to /dbdata/data/performance_schema/session_connect_attrs.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /dbdata/data/performance_schema/events_stages_summary_global_by_event_name.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /dbdata/data/performance_schema/events_statements_summary_global_by_event_name.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/setup_instruments.frm to /dbdata/data/performance_schema/setup_instruments.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /dbdata/data/performance_schema/events_waits_summary_global_by_event_name.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/db.opt to /dbdata/data/performance_schema/db.opt
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_waits_current.frm to /dbdata/data/performance_schema/events_waits_current.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/users.frm to /dbdata/data/performance_schema/users.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/mutex_instances.frm to /dbdata/data/performance_schema/mutex_instances.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/file_summary_by_instance.frm to /dbdata/data/performance_schema/file_summary_by_instance.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /dbdata/data/performance_schema/table_io_waits_summary_by_table.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /dbdata/data/performance_schema/table_lock_waits_summary_by_table.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/cond_instances.frm to /dbdata/data/performance_schema/cond_instances.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /dbdata/data/performance_schema/events_waits_summary_by_host_by_event_name.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_stages_current.frm to /dbdata/data/performance_schema/events_stages_current.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /dbdata/data/performance_schema/table_io_waits_summary_by_index_usage.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /dbdata/data/performance_schema/events_stages_summary_by_thread_by_event_name.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/setup_objects.frm to /dbdata/data/performance_schema/setup_objects.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /dbdata/data/performance_schema/events_waits_summary_by_user_by_event_name.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_statements_current.frm to /dbdata/data/performance_schema/events_statements_current.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /dbdata/data/performance_schema/events_statements_summary_by_account_by_event_name.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_stages_history.frm to /dbdata/data/performance_schema/events_stages_history.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_waits_history.frm to /dbdata/data/performance_schema/events_waits_history.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /dbdata/data/performance_schema/events_statements_summary_by_digest.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /dbdata/data/performance_schema/events_statements_summary_by_host_by_event_name.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/setup_actors.frm to /dbdata/data/performance_schema/setup_actors.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/hosts.frm to /dbdata/data/performance_schema/hosts.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /dbdata/data/performance_schema/session_account_connect_attrs.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/setup_timers.frm to /dbdata/data/performance_schema/setup_timers.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /dbdata/data/performance_schema/events_statements_summary_by_thread_by_event_name.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /dbdata/data/performance_schema/events_stages_summary_by_user_by_event_name.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /dbdata/data/performance_schema/objects_summary_global_by_type.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./employees/dept_emp_latest_date.frm to /dbdata/data/employees/dept_emp_latest_date.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./employees/employees.frm to /dbdata/data/employees/employees.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./employees/dept_emp.ibd to /dbdata/data/employees/dept_emp.ibd
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./employees/dept_manager.frm to /dbdata/data/employees/dept_manager.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./employees/employees.ibd to /dbdata/data/employees/employees.ibd
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./employees/titles.frm to /dbdata/data/employees/titles.frm
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./employees/db.opt to /dbdata/data/employees/db.opt
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./employees/dept_manager.ibd to /dbdata/data/employees/dept_manager.ibd
151210 15:55:30 [01] ...done
151210 15:55:30 [01] Copying ./employees/titles.ibd to /dbdata/data/employees/titles.ibd
151210 15:55:30 [01] ...done
151210 15:55:31 [01] Copying ./employees/dept_emp.frm to /dbdata/data/employees/dept_emp.frm
151210 15:55:31 [01] ...done
151210 15:55:31 [01] Copying ./employees/departments.frm to /dbdata/data/employees/departments.frm
151210 15:55:31 [01] ...done
151210 15:55:31 [01] Copying ./employees/salaries.ibd to /dbdata/data/employees/salaries.ibd
151210 15:55:31 [01] ...done
151210 15:55:32 [01] Copying ./employees/salaries.frm to /dbdata/data/employees/salaries.frm
151210 15:55:32 [01] ...done
151210 15:55:32 [01] Copying ./employees/departments.ibd to /dbdata/data/employees/departments.ibd
151210 15:55:32 [01] ...done
151210 15:55:32 [01] Copying ./employees/current_dept_emp.frm to /dbdata/data/employees/current_dept_emp.frm
151210 15:55:32 [01] ...done
151210 15:55:32 [01] Copying ./test/db.opt to /dbdata/data/test/db.opt
151210 15:55:32 [01] ...done
151210 15:55:32 [01] Copying ./xtrabackup_info to /dbdata/data/xtrabackup_info
151210 15:55:32 [01] ...done
151210 15:55:32 [01] Copying ./lucien/lijingkuan.ibd to /dbdata/data/lucien/lijingkuan.ibd
151210 15:55:32 [01] ...done
151210 15:55:32 [01] Copying ./lucien/db.opt to /dbdata/data/lucien/db.opt
151210 15:55:32 [01] ...done
151210 15:55:32 [01] Copying ./lucien/lijingkuan.frm to /dbdata/data/lucien/lijingkuan.frm
151210 15:55:32 [01] ...done
151210 15:55:32 completed OK!
[root@myrep2 ~]#
[root@myrep2 ~]#
安装perl后恢复，一直报错，提示拷贝iblogs回目录../iblogs/时出错，文件已存在。
将my.cnf中的相对路径改成绝对路径后，copy back成功。
[root@myrep2 ~]# innobackupex --defaults-file=/etc/my.cnf --copy-back --rsync /dbdata/backup/full/<span style="font-family: Arial, Helvetica, sans-serif;">2015-12-13_07-03-45</span><span style="font-family: Arial, Helvetica, sans-serif;">/</span>
修改数据目录及文件权限（由于是root用户执行的copy back，所以目录及文件权限都是root，要改回mysql。）
注：/dbdata目录下所有的文件都要改成mysql:mysql，否则启动报错，且不易排错。
[root@myrep2 ~]#
[root@myrep2 ~]#
[root@myrep2 ~]# cd /dbdata/data/
[root@myrep2 data]# ll
total 28
drwx------. 2 root root 4096 Dec 10 15:55 employees
drwx------. 2 root root 4096 Dec 10 15:55 lucien
drwx------. 2 root root 4096 Dec 10 15:55 mysql
drwx------. 2 root root 4096 Dec 10 15:55 performance_schema
drwx------. 2 root root 4096 Dec 10 15:55 test
-rw-r-----. 1 root root 27 Dec 10 15:55 xtrabackup_binlog_pos_innodb
-rw-r-----. 1 root root 486 Dec 10 15:55 xtrabackup_info
[root@myrep2 data]#
[root@myrep2 data]#
[root@myrep2 data]# cd ..
[root@myrep2 dbdata]# ll
total 28
drwxr-xr-x. 2 mysql mysql 4096 Dec 10 07:16 aux
drwxr-xr-x. 3 mysql mysql 4096 Dec 10 15:26 backup
drwxr-xr-x. 2 mysql mysql 4096 Dec 10 07:16 binlogs
drwxr-xr-x. 7 mysql mysql 4096 Dec 10 15:55 data
drwxr-xr-x. 2 mysql mysql 4096 Dec 10 15:20 ibdata
drwxr-xr-x. 2 mysql mysql 4096 Dec 10 15:21 iblogs
drwxr-xr-x. 2 mysql mysql 4096 Dec 10 07:16 logs
[root@myrep2 dbdata]#
[root@myrep2 dbdata]#
[root@myrep2 dbdata]# chown -R mysql:mysql *
[root@myrep2 dbdata]#
[root@myrep2 dbdata]# [root@myrep2 dbdata]#
[root@myrep2 dbdata]#
[root@myrep2 dbdata]# cd data/
[root@myrep2 data]# ll
total 28
drwx------. 2 mysql mysql 4096 Dec 10 15:55 employees
drwx------. 2 mysql mysql 4096 Dec 10 15:55 lucien
drwx------. 2 mysql mysql 4096 Dec 10 15:55 mysql
drwx------. 2 mysql mysql 4096 Dec 10 15:55 performance_schema
drwx------. 2 mysql mysql 4096 Dec 10 15:55 test
-rw-r-----. 1 mysql mysql 27 Dec 10 15:55 xtrabackup_binlog_pos_innodb
-rw-r-----. 1 mysql mysql 486 Dec 10 15:55 xtrabackup_info
[root@myrep2 data]#
[root@myrep2 data]# 恢复到这里，检查数据一致性，发现了错误：
mysql>
mysql>
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| employees |
| lucien |
| mysql |
| performance_schema |
| test |
+--------------------+
6 rows in set (0.01 sec)
mysql>
mysql>
mysql> use lucien;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>
mysql>
mysql> show tables;
+------------------+
| Tables_in_lucien |
+------------------+
| lijingkuan |
+------------------+
1 row in set (0.00 sec)
mysql>
mysql> select * from lijingkuan;
ERROR 1146 (42S02): Table 'lucien.lijingkuan' doesn't exist
mysql> select * from lijingkuan;
ERROR 1146 (42S02): Table 'lucien.lijingkuan' doesn't exist
mysql>
mysql> 系统里能看到表，数据文件路径中也有表的文件，但却提示表不存在。
后续检查，发现所有innodb的表提示不存在，MyISAM的表都正常。
暂未解决！！！
=========================================================================================================================
安装perl模块备份，然后恢复到异机，恢复正常，数据可以正常读取。
从以上操作过程来看，应该是没有安装perl模块导致备份除了问题，从而恢复的时候数据出错。
mysql>
mysql>
mysql> select * from lijingkuan;
+----+----------+
| id | name |
+----+----------+
| 1 | shandong |
| 2 | beijing |
| 3 | hebei |
| 4 | perl |
+----+----------+
4 rows in set (0.00 sec)
mysql>
2774
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
