xtrabackupバックアップリカバリテスト

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.

解決策:perl関連モジュールのインストール
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 ~]# 

生成されたバックアップファイルの表示(perlモジュールをインストールする前に)

[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 [email protected]:/dbdata/backup/full/
[email protected]'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 [email protected]:/dbdata/backup/full/
[email protected]'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 ~]# 

copy backファイルを指定した場所に復元

[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>