MySQL Study之--MySQL innodb引擎备份工具XtraBackup之二（数据库全备）

zhaoke0727

151028 14:26: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!".
　　
151028 14:26:45  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/lib/mysql/mysql.sock' as 'usrbak'  (using password: YES).
　　
Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup;mysql_socket=/var/lib/mysql/mysql.sock','usrbak',...) failed: Access denied for user 'usrbak'@'localhost' (using password: YES) at - line 1314
　　
151028 14:26:45 Connecting to MySQL server host: localhost, user: usrbak, password: set, port: 0, socket: /var/lib/mysql/mysql.sock
　　
Failed to connect to MySQL server: Access denied for user 'usrbak'@'localhost' (using password: YES).
　　
[root@rh64 backup]# innobackupex --defaults-file=/etc/my.cnf --user=bakusr --password='oracle'  --socket=/var/lib/mysql/mysql.sock  /data/mysql/backup/full --no-timestamp
　　
151028 14:26:59 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!".
　　
151028 14:26:59  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/lib/mysql/mysql.sock' as 'bakusr'  (using password: YES).
　　
151028 14:26:59  version_check Connected to MySQL server
　　
151028 14:26:59  version_check Executing a version check against the server...
　　
151028 14:26:59  version_check Done.
　　
151028 14:26:59 Connecting to MySQL server host: localhost, user: bakusr, password: set, port: 0, socket: /var/lib/mysql/mysql.sock
　　
Using server version 5.6.25-73.1
　　
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 /var/lib/mysql
　　
xtrabackup: open files limit requested 0, set to 1024
　　
xtrabackup: using the following InnoDB configuration:
　　
xtrabackup:   innodb_data_home_dir = ./
　　
xtrabackup:   innodb_data_file_path = ibdata1:12M;ibdata2:10M:autoextend
　　
xtrabackup:   innodb_log_group_home_dir = ./
　　
xtrabackup:   innodb_log_files_in_group = 2
　　
xtrabackup:   innodb_log_file_size = 50331648
　　
151028 14:26:59 >> log scanned up to (13254537)
　　
xtrabackup: Generating a list of tablespaces
　　
151028 14:27:00 [01] Copying ./ibdata1 to /data/mysql/backup/full/ibdata1
　　
151028 14:27:00 [01]        ...done
　　
151028 14:27:00 >> log scanned up to (13254537)
　　
151028 14:27:00 [01] Copying ./ibdata2 to /data/mysql/backup/full/ibdata2
　　
151028 14:27:01 [01]        ...done
　　
151028 14:27:01 [01] Copying ./prod/t2.ibd to /data/mysql/backup/full/prod/t2.ibd
　　
151028 14:27:01 [01]        ...done
　　
151028 14:27:01 [01] Copying ./prod/t1.ibd to /data/mysql/backup/full/prod/t1.ibd
　　
151028 14:27:01 >> log scanned up to (13254537)
　　
151028 14:27:01 [01]        ...done
　　
151028 14:27:01 [01] Copying ./prod/t3.ibd to /data/mysql/backup/full/prod/t3.ibd
　　
151028 14:27:01 [01]        ...done
　　
151028 14:27:02 [01] Copying ./mysql/slave_worker_info.ibd to /data/mysql/backup/full/mysql/slave_worker_info.ibd
　　
151028 14:27:02 [01]        ...done
　　
151028 14:27:02 [01] Copying ./mysql/slave_master_info.ibd to /data/mysql/backup/full/mysql/slave_master_info.ibd
　　
151028 14:27:02 [01]        ...done
　　
151028 14:27:02 [01] Copying ./mysql/slave_relay_log_info.ibd to /data/mysql/backup/full/mysql/slave_relay_log_info.ibd
　　
151028 14:27:02 [01]        ...done
　　
151028 14:27:02 [01] Copying ./mysql/innodb_index_stats.ibd to /data/mysql/backup/full/mysql/innodb_index_stats.ibd
　　
151028 14:27:02 [01]        ...done
　　
151028 14:27:02 [01] Copying ./mysql/innodb_table_stats.ibd to /data/mysql/backup/full/mysql/innodb_table_stats.ibd
　　
151028 14:27:02 [01]        ...done
　　
151028 14:27:02 >> log scanned up to (13254537)
　　
Error: failed to execute query LOCK TABLES FOR BACKUP: Access denied; you need (at least one of) the RELOAD privilege(s) for this operation
　　
[root@rh64 backup]# innobackupex --defaults-file=/etc/my.cnf --user=bakusr --password='oracle'  --socket=/var/lib/mysql/mysql.sock  /data/mysql/backup/full --no-timestamp
　　
151028 14:34:47 innobackupex: Starting the backup operation
　　
IMPORTANT: Please check that the backup run completes successfully.
　　
           At the end of a successful backup run innobackupex
　　
           prints "completed OK!".
　　
151028 14:34:47  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/lib/mysql/mysql.sock' as 'bakusr'  (using password: YES).
　　
151028 14:34:47  version_check Connected to MySQL server
　　
151028 14:34:47  version_check Executing a version check against the server...
　　
151028 14:34:47  version_check Done.
　　
151028 14:34:47 Connecting to MySQL server host: localhost, user: bakusr, password: set, port: 0, socket: /var/lib/mysql/mysql.sock
　　
Using server version 5.6.25-73.1
　　
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 /var/lib/mysql
　　
xtrabackup: open files limit requested 0, set to 1024
　　
xtrabackup: using the following InnoDB configuration:
　　
xtrabackup:   innodb_data_home_dir = ./
　　
xtrabackup:   innodb_data_file_path = ibdata1:12M;ibdata2:10M:autoextend
　　
xtrabackup:   innodb_log_group_home_dir = ./
　　
xtrabackup:   innodb_log_files_in_group = 2
　　
xtrabackup:   innodb_log_file_size = 50331648
　　
innobackupex: Can't create/write to file '/data/mysql/backup/full/xtrabackup_logfile' (Errcode: 17 - File exists)
　　
xtrabackup: error: failed to open the target stream for 'xtrabackup_logfile'.
　　
[root@rh64 backup]# ls
　　
bak.sh  full  prod  t.txt
　　
[root@rh64 backup]# rm -rf full
　　
[root@rh64 backup]# innobackupex --defaults-file=/etc/my.cnf --user=bakusr --password='oracle'  --socket=/var/lib/mysql/mysql.sock  /data/mysql/backup/full --no-timestamp
　　
151028 14:35:09 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!".
　　
151028 14:35:09  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/lib/mysql/mysql.sock' as 'bakusr'  (using password: YES).
　　
151028 14:35:09  version_check Connected to MySQL server
　　
151028 14:35:09  version_check Executing a version check against the server...
　　
151028 14:35:09  version_check Done.
　　
151028 14:35:09 Connecting to MySQL server host: localhost, user: bakusr, password: set, port: 0, socket: /var/lib/mysql/mysql.sock
　　
Using server version 5.6.25-73.1
　　
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 /var/lib/mysql
　　
xtrabackup: open files limit requested 0, set to 1024
　　
xtrabackup: using the following InnoDB configuration:
　　
xtrabackup:   innodb_data_home_dir = ./
　　
xtrabackup:   innodb_data_file_path = ibdata1:12M;ibdata2:10M:autoextend
　　
xtrabackup:   innodb_log_group_home_dir = ./
　　
xtrabackup:   innodb_log_files_in_group = 2
　　
xtrabackup:   innodb_log_file_size = 50331648
　　
151028 14:35:09 >> log scanned up to (13254537)
　　
xtrabackup: Generating a list of tablespaces
　　
151028 14:35:09 [01] Copying ./ibdata1 to /data/mysql/backup/full/ibdata1
　　
151028 14:35:10 >> log scanned up to (13254537)
　　
151028 14:35:10 [01]        ...done
　　
151028 14:35:11 [01] Copying ./ibdata2 to /data/mysql/backup/full/ibdata2
　　
151028 14:35:11 [01]        ...done
　　
151028 14:35:11 >> log scanned up to (13254537)
　　
151028 14:35:11 [01] Copying ./prod/t2.ibd to /data/mysql/backup/full/prod/t2.ibd
　　
151028 14:35:11 [01]        ...done
　　
151028 14:35:11 [01] Copying ./prod/t1.ibd to /data/mysql/backup/full/prod/t1.ibd
　　
151028 14:35:12 [01]        ...done
　　
151028 14:35:12 [01] Copying ./prod/t3.ibd to /data/mysql/backup/full/prod/t3.ibd
　　
151028 14:35:12 >> log scanned up to (13254537)
　　
151028 14:35:12 [01]        ...done
　　
151028 14:35:12 [01] Copying ./mysql/slave_worker_info.ibd to /data/mysql/backup/full/mysql/slave_worker_info.ibd
　　
151028 14:35:12 [01]        ...done
　　
151028 14:35:12 [01] Copying ./mysql/slave_master_info.ibd to /data/mysql/backup/full/mysql/slave_master_info.ibd
　　
151028 14:35:12 [01]        ...done
　　
151028 14:35:12 [01] Copying ./mysql/slave_relay_log_info.ibd to /data/mysql/backup/full/mysql/slave_relay_log_info.ibd
　　
151028 14:35:12 [01]        ...done
　　
151028 14:35:12 [01] Copying ./mysql/innodb_index_stats.ibd to /data/mysql/backup/full/mysql/innodb_index_stats.ibd
　　
151028 14:35:12 [01]        ...done
　　
151028 14:35:12 [01] Copying ./mysql/innodb_table_stats.ibd to /data/mysql/backup/full/mysql/innodb_table_stats.ibd
　　
151028 14:35:12 [01]        ...done
　　
151028 14:35:12 Starting to backup non-InnoDB tables and files
　　
151028 14:35:12 [01] Copying ./prod/t1.frm to /data/mysql/backup/full/prod/t1.frm
　　
151028 14:35:13 [01]        ...done
　　
151028 14:35:13 [01] Copying ./prod/t2.frm to /data/mysql/backup/full/prod/t2.frm
　　
151028 14:35:13 [01]        ...done
　　
151028 14:35:13 [01] Copying ./prod/t3.frm to /data/mysql/backup/full/prod/t3.frm
　　
151028 14:35:13 [01]        ...done
　　
151028 14:35:13 [01] Copying ./prod/db.opt to /data/mysql/backup/full/prod/db.opt
　　
151028 14:35:13 [01]        ...done
　　
151028 14:35:13 >> log scanned up to (13254537)
　　
151028 14:35:13 [00] Writing test/db.opt
　　
151028 14:35:13 [00]        ...done
　　
151028 14:35:13 [01] Copying ./mysql/time_zone_name.MYD to /data/mysql/backup/full/mysql/time_zone_name.MYD
　　
151028 14:35:13 [01]        ...done
　　
151028 14:35:13 [01] Copying ./mysql/help_topic.frm to /data/mysql/backup/full/mysql/help_topic.frm
　　
151028 14:35:13 [01]        ...done
　　
151028 14:35:13 [01] Copying ./mysql/event.frm to /data/mysql/backup/full/mysql/event.frm
　　
151028 14:35:13 [01]        ...done
　　
151028 14:35:13 [01] Copying ./mysql/time_zone.MYD to /data/mysql/backup/full/mysql/time_zone.MYD
　　
151028 14:35:13 [01]        ...done
　　
151028 14:35:13 [01] Copying ./mysql/slow_log.CSV to /data/mysql/backup/full/mysql/slow_log.CSV
　　
151028 14:35:13 [01]        ...done
　　
151028 14:35:13 [01] Copying ./mysql/innodb_index_stats.frm to /data/mysql/backup/full/mysql/innodb_index_stats.frm
　　
151028 14:35:13 [01]        ...done
　　
151028 14:35:14 [01] Copying ./mysql/columns_priv.MYI to /data/mysql/backup/full/mysql/columns_priv.MYI
　　
151028 14:35:14 [01]        ...done
　　
151028 14:35:14 [01] Copying ./mysql/plugin.MYI to /data/mysql/backup/full/mysql/plugin.MYI
　　
151028 14:35:14 [01]        ...done
　　
151028 14:35:14 [01] Copying ./mysql/time_zone_leap_second.frm to /data/mysql/backup/full/mysql/time_zone_leap_second.frm
　　
151028 14:35:14 [01]        ...done
　　
151028 14:35:14 [01] Copying ./mysql/time_zone_transition_type.MYI to /data/mysql/backup/full/mysql/time_zone_transition_type.MYI
　　
151028 14:35:14 [01]        ...done
　　
151028 14:35:14 >> log scanned up to (13254537)
　　
151028 14:35:14 [01] Copying ./mysql/proc.frm to /data/mysql/backup/full/mysql/proc.frm
　　
151028 14:35:14 [01]        ...done
　　
151028 14:35:14 [01] Copying ./mysql/procs_priv.MYD to /data/mysql/backup/full/mysql/procs_priv.MYD
　　
151028 14:35:14 [01]        ...done
　　
151028 14:35:14 [01] Copying ./mysql/proxies_priv.MYI to /data/mysql/backup/full/mysql/proxies_priv.MYI
　　
151028 14:35:14 [01]        ...done
　　
151028 14:35:14 [01] Copying ./mysql/ndb_binlog_index.MYI to /data/mysql/backup/full/mysql/ndb_binlog_index.MYI
　　
151028 14:35:14 [01]        ...done
　　
151028 14:35:14 [01] Copying ./mysql/servers.MYI to /data/mysql/backup/full/mysql/servers.MYI
　　
151028 14:35:14 [01]        ...done
　　
151028 14:35:15 [01] Copying ./mysql/slow_log.frm to /data/mysql/backup/full/mysql/slow_log.frm
　　
151028 14:35:15 [01]        ...done
　　
151028 14:35:15 [01] Copying ./mysql/help_relation.MYD to /data/mysql/backup/full/mysql/help_relation.MYD
　　
151028 14:35:15 [01]        ...done
　　
151028 14:35:15 [01] Copying ./mysql/user.frm to /data/mysql/backup/full/mysql/user.frm
　　
151028 14:35:15 [01]        ...done
　　
151028 14:35:15 >> log scanned up to (13254537)
　　
151028 14:35:15 [01] Copying ./mysql/plugin.frm to /data/mysql/backup/full/mysql/plugin.frm
　　
151028 14:35:15 [01]        ...done
　　
151028 14:35:15 [01] Copying ./mysql/time_zone_name.frm to /data/mysql/backup/full/mysql/time_zone_name.frm
　　
151028 14:35:15 [01]        ...done
　　
151028 14:35:15 [01] Copying ./mysql/user.MYI to /data/mysql/backup/full/mysql/user.MYI
　　
151028 14:35:15 [01]        ...done
　　
151028 14:35:15 [01] Copying ./mysql/help_relation.frm to /data/mysql/backup/full/mysql/help_relation.frm
　　
151028 14:35:15 [01]        ...done
　　
151028 14:35:15 [01] Copying ./mysql/slow_log.CSM to /data/mysql/backup/full/mysql/slow_log.CSM
　　
151028 14:35:15 [01]        ...done
　　
151028 14:35:16 [01] Copying ./mysql/time_zone_transition.MYD to /data/mysql/backup/full/mysql/time_zone_transition.MYD
　　
151028 14:35:16 [01]        ...done
　　
151028 14:35:16 [01] Copying ./mysql/help_category.MYI to /data/mysql/backup/full/mysql/help_category.MYI
　　
151028 14:35:16 [01]        ...done
　　
151028 14:35:16 [01] Copying ./mysql/proc.MYD to /data/mysql/backup/full/mysql/proc.MYD
　　
151028 14:35:16 [01]        ...done
　　
151028 14:35:16 [01] Copying ./mysql/db.MYD to /data/mysql/backup/full/mysql/db.MYD
　　
151028 14:35:16 [01]        ...done
　　
151028 14:35:16 >> log scanned up to (13254537)
　　
151028 14:35:16 [01] Copying ./mysql/tables_priv.MYD to /data/mysql/backup/full/mysql/tables_priv.MYD
　　
151028 14:35:16 [01]        ...done
　　
151028 14:35:16 [01] Copying ./mysql/time_zone_leap_second.MYI to /data/mysql/backup/full/mysql/time_zone_leap_second.MYI
　　
151028 14:35:16 [01]        ...done
　　
151028 14:35:16 [01] Copying ./mysql/help_relation.MYI to /data/mysql/backup/full/mysql/help_relation.MYI
　　
151028 14:35:16 [01]        ...done
　　
151028 14:35:16 [01] Copying ./mysql/ndb_binlog_index.MYD to /data/mysql/backup/full/mysql/ndb_binlog_index.MYD
　　
151028 14:35:16 [01]        ...done
　　
151028 14:35:16 [01] Copying ./mysql/slave_worker_info.frm to /data/mysql/backup/full/mysql/slave_worker_info.frm
　　
151028 14:35:16 [01]        ...done
　　
151028 14:35:17 [01] Copying ./mysql/time_zone.frm to /data/mysql/backup/full/mysql/time_zone.frm
　　
151028 14:35:17 [01]        ...done
　　
151028 14:35:17 [01] Copying ./mysql/slave_relay_log_info.frm to /data/mysql/backup/full/mysql/slave_relay_log_info.frm
　　
151028 14:35:17 [01]        ...done
　　
151028 14:35:17 [01] Copying ./mysql/columns_priv.MYD to /data/mysql/backup/full/mysql/columns_priv.MYD
　　
151028 14:35:17 [01]        ...done
　　
151028 14:35:17 >> log scanned up to (13254537)
　　
151028 14:35:17 [01] Copying ./mysql/time_zone_transition_type.MYD to /data/mysql/backup/full/mysql/time_zone_transition_type.MYD
　　
151028 14:35:17 [01]        ...done
　　
151028 14:35:17 [01] Copying ./mysql/user.MYD to /data/mysql/backup/full/mysql/user.MYD
　　
151028 14:35:17 [01]        ...done
　　
151028 14:35:17 [01] Copying ./mysql/tables_priv.frm to /data/mysql/backup/full/mysql/tables_priv.frm
　　
151028 14:35:17 [01]        ...done
　　
151028 14:35:17 [01] Copying ./mysql/help_category.MYD to /data/mysql/backup/full/mysql/help_category.MYD
　　
151028 14:35:17 [01]        ...done
　　
151028 14:35:17 [01] Copying ./mysql/help_keyword.MYD to /data/mysql/backup/full/mysql/help_keyword.MYD
　　
151028 14:35:18 [01]        ...done
　　
151028 14:35:18 [01] Copying ./mysql/time_zone_transition.frm to /data/mysql/backup/full/mysql/time_zone_transition.frm
　　
151028 14:35:18 [01]        ...done
　　
151028 14:35:18 [01] Copying ./mysql/servers.frm to /data/mysql/backup/full/mysql/servers.frm
　　
151028 14:35:18 [01]        ...done
　　
151028 14:35:18 [01] Copying ./mysql/general_log.frm to /data/mysql/backup/full/mysql/general_log.frm
　　
151028 14:35:18 [01]        ...done
　　
151028 14:35:18 >> log scanned up to (13254537)
　　
151028 14:35:18 [01] Copying ./mysql/help_keyword.frm to /data/mysql/backup/full/mysql/help_keyword.frm
　　
151028 14:35:18 [01]        ...done
　　
151028 14:35:18 [01] Copying ./mysql/time_zone_transition_type.frm to /data/mysql/backup/full/mysql/time_zone_transition_type.frm
　　
151028 14:35:18 [01]        ...done
　　
151028 14:35:18 [01] Copying ./mysql/columns_priv.frm to /data/mysql/backup/full/mysql/columns_priv.frm
　　
151028 14:35:18 [01]        ...done
　　
151028 14:35:18 [01] Copying ./mysql/proxies_priv.frm to /data/mysql/backup/full/mysql/proxies_priv.frm
　　
151028 14:35:18 [01]        ...done
　　
151028 14:35:19 [01] Copying ./mysql/help_keyword.MYI to /data/mysql/backup/full/mysql/help_keyword.MYI
　　
151028 14:35:19 [01]        ...done
　　
151028 14:35:19 [01] Copying ./mysql/general_log.CSV to /data/mysql/backup/full/mysql/general_log.CSV
　　
151028 14:35:19 [01]        ...done
　　
151028 14:35:19 [01] Copying ./mysql/event.MYD to /data/mysql/backup/full/mysql/event.MYD
　　
151028 14:35:19 [01]        ...done
　　
151028 14:35:19 [01] Copying ./mysql/plugin.MYD to /data/mysql/backup/full/mysql/plugin.MYD
　　
151028 14:35:19 [01]        ...done
　　
151028 14:35:19 [01] Copying ./mysql/proxies_priv.MYD to /data/mysql/backup/full/mysql/proxies_priv.MYD
　　
151028 14:35:19 [01]        ...done
　　
151028 14:35:19 >> log scanned up to (13254537)
　　
151028 14:35:19 [01] Copying ./mysql/servers.MYD to /data/mysql/backup/full/mysql/servers.MYD
　　
151028 14:35:19 [01]        ...done
　　
151028 14:35:19 [01] Copying ./mysql/event.MYI to /data/mysql/backup/full/mysql/event.MYI
　　
151028 14:35:19 [01]        ...done
　　
151028 14:35:19 [01] Copying ./mysql/time_zone_transition.MYI to /data/mysql/backup/full/mysql/time_zone_transition.MYI
　　
151028 14:35:19 [01]        ...done
　　
151028 14:35:19 [01] Copying ./mysql/tables_priv.MYI to /data/mysql/backup/full/mysql/tables_priv.MYI
　　
151028 14:35:19 [01]        ...done
　　
151028 14:35:19 [01] Copying ./mysql/ndb_binlog_index.frm to /data/mysql/backup/full/mysql/ndb_binlog_index.frm
　　
151028 14:35:19 [01]        ...done
　　
151028 14:35:20 [01] Copying ./mysql/db.MYI to /data/mysql/backup/full/mysql/db.MYI
　　
151028 14:35:20 [01]        ...done
　　
151028 14:35:20 [01] Copying ./mysql/time_zone_name.MYI to /data/mysql/backup/full/mysql/time_zone_name.MYI
　　
151028 14:35:20 [01]        ...done
　　
151028 14:35:20 [01] Copying ./mysql/time_zone_leap_second.MYD to /data/mysql/backup/full/mysql/time_zone_leap_second.MYD
　　
151028 14:35:20 [01]        ...done
　　
151028 14:35:20 >> log scanned up to (13254537)
　　
151028 14:35:20 [01] Copying ./mysql/help_topic.MYD to /data/mysql/backup/full/mysql/help_topic.MYD
　　
151028 14:35:20 [01]        ...done
　　
151028 14:35:20 [01] Copying ./mysql/help_topic.MYI to /data/mysql/backup/full/mysql/help_topic.MYI
　　
151028 14:35:20 [01]        ...done
　　
151028 14:35:20 [01] Copying ./mysql/db.frm to /data/mysql/backup/full/mysql/db.frm
　　
151028 14:35:20 [01]        ...done
　　
151028 14:35:20 [01] Copying ./mysql/func.MYI to /data/mysql/backup/full/mysql/func.MYI
　　
151028 14:35:20 [01]        ...done
　　
151028 14:35:20 [01] Copying ./mysql/procs_priv.MYI to /data/mysql/backup/full/mysql/procs_priv.MYI
　　
151028 14:35:21 [01]        ...done
　　
151028 14:35:21 [01] Copying ./mysql/help_category.frm to /data/mysql/backup/full/mysql/help_category.frm
　　
151028 14:35:21 [01]        ...done
　　
151028 14:35:21 [01] Copying ./mysql/procs_priv.frm to /data/mysql/backup/full/mysql/procs_priv.frm
　　
151028 14:35:21 [01]        ...done
　　
151028 14:35:21 [01] Copying ./mysql/func.MYD to /data/mysql/backup/full/mysql/func.MYD
　　
151028 14:35:21 [01]        ...done
　　
151028 14:35:21 >> log scanned up to (13254537)
　　
151028 14:35:21 [01] Copying ./mysql/func.frm to /data/mysql/backup/full/mysql/func.frm
　　
151028 14:35:21 [01]        ...done
　　
151028 14:35:21 [01] Copying ./mysql/proc.MYI to /data/mysql/backup/full/mysql/proc.MYI
　　
151028 14:35:21 [01]        ...done
　　
151028 14:35:21 [01] Copying ./mysql/general_log.CSM to /data/mysql/backup/full/mysql/general_log.CSM
　　
151028 14:35:21 [01]        ...done
　　
151028 14:35:21 [01] Copying ./mysql/time_zone.MYI to /data/mysql/backup/full/mysql/time_zone.MYI
　　
151028 14:35:21 [01]        ...done
　　
151028 14:35:21 [01] Copying ./mysql/slave_master_info.frm to /data/mysql/backup/full/mysql/slave_master_info.frm
　　
151028 14:35:21 [01]        ...done
　　
151028 14:35:22 [01] Copying ./mysql/innodb_table_stats.frm to /data/mysql/backup/full/mysql/innodb_table_stats.frm
　　
151028 14:35:22 [01]        ...done
　　
151028 14:35:22 [01] Copying ./performance_schema/users.frm to /data/mysql/backup/full/performance_schema/users.frm
　　
151028 14:35:22 [01]        ...done
　　
151028 14:35:22 [01] Copying ./performance_schema/events_waits_history_long.frm to /data/mysql/backup/full/performance_schema/events_waits_history_long.frm
　　
151028 14:35:22 [01]        ...done
　　
151028 14:35:22 >> log scanned up to (13254537)
　　
151028 14:35:22 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_statements_summary_by_host_by_event_name.frm
　　
151028 14:35:22 [01]        ...done
　　
151028 14:35:22 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /data/mysql/backup/full/performance_schema/table_io_waits_summary_by_index_usage.frm
　　
151028 14:35:22 [01]        ...done
　　
151028 14:35:22 [01] Copying ./performance_schema/events_waits_history.frm to /data/mysql/backup/full/performance_schema/events_waits_history.frm
　　
151028 14:35:22 [01]        ...done
　　
151028 14:35:22 [01] Copying ./performance_schema/host_cache.frm to /data/mysql/backup/full/performance_schema/host_cache.frm
　　
151028 14:35:22 [01]        ...done
　　
151028 14:35:22 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_statements_summary_by_thread_by_event_name.frm
　　
151028 14:35:22 [01]        ...done
　　
151028 14:35:23 [01] Copying ./performance_schema/session_connect_attrs.frm to /data/mysql/backup/full/performance_schema/session_connect_attrs.frm
　　
151028 14:35:23 [01]        ...done
　　
151028 14:35:23 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /data/mysql/backup/full/performance_schema/objects_summary_global_by_type.frm
　　
151028 14:35:23 [01]        ...done
　　
151028 14:35:23 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /data/mysql/backup/full/performance_schema/session_account_connect_attrs.frm
　　
151028 14:35:23 [01]        ...done
　　
151028 14:35:23 >> log scanned up to (13254537)
　　
151028 14:35:23 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /data/mysql/backup/full/performance_schema/socket_summary_by_event_name.frm
　　
151028 14:35:23 [01]        ...done
　　
151028 14:35:23 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_stages_summary_global_by_event_name.frm
　　
151028 14:35:23 [01]        ...done
　　
151028 14:35:23 [01] Copying ./performance_schema/rwlock_instances.frm to /data/mysql/backup/full/performance_schema/rwlock_instances.frm
　　
151028 14:35:23 [01]        ...done
　　
151028 14:35:23 [01] Copying ./performance_schema/events_stages_current.frm to /data/mysql/backup/full/performance_schema/events_stages_current.frm
　　
151028 14:35:23 [01]        ...done
　　
151028 14:35:23 [01] Copying ./performance_schema/file_summary_by_instance.frm to /data/mysql/backup/full/performance_schema/file_summary_by_instance.frm
　　
151028 14:35:23 [01]        ...done
　　
151028 14:35:24 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_waits_summary_by_host_by_event_name.frm
　　
151028 14:35:24 [01]        ...done
　　
151028 14:35:24 [01] Copying ./performance_schema/performance_timers.frm to /data/mysql/backup/full/performance_schema/performance_timers.frm
　　
151028 14:35:24 [01]        ...done
　　
151028 14:35:24 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_waits_summary_by_thread_by_event_name.frm
　　
151028 14:35:24 [01]        ...done
　　
151028 14:35:24 >> log scanned up to (13254537)
　　
151028 14:35:24 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_waits_summary_by_user_by_event_name.frm
　　
151028 14:35:24 [01]        ...done
　　
151028 14:35:24 [01] Copying ./performance_schema/cond_instances.frm to /data/mysql/backup/full/performance_schema/cond_instances.frm
　　
151028 14:35:24 [01]        ...done
　　
151028 14:35:24 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_statements_summary_global_by_event_name.frm
　　
151028 14:35:24 [01]        ...done
　　
151028 14:35:24 [01] Copying ./performance_schema/setup_timers.frm to /data/mysql/backup/full/performance_schema/setup_timers.frm
　　
151028 14:35:24 [01]        ...done
　　
151028 14:35:24 [01] Copying ./performance_schema/hosts.frm to /data/mysql/backup/full/performance_schema/hosts.frm
　　
151028 14:35:24 [01]        ...done
　　
151028 14:35:25 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /data/mysql/backup/full/performance_schema/socket_summary_by_instance.frm
　　
151028 14:35:25 [01]        ...done
　　
151028 14:35:25 [01] Copying ./performance_schema/file_instances.frm to /data/mysql/backup/full/performance_schema/file_instances.frm
　　
151028 14:35:25 [01]        ...done
　　
151028 14:35:25 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /data/mysql/backup/full/performance_schema/table_lock_waits_summary_by_table.frm
　　
151028 14:35:25 [01]        ...done
　　
151028 14:35:25 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_statements_summary_by_user_by_event_name.frm
　　
151028 14:35:25 [01]        ...done
　　
151028 14:35:25 [01] Copying ./performance_schema/events_waits_current.frm to /data/mysql/backup/full/performance_schema/events_waits_current.frm
　　
151028 14:35:25 >> log scanned up to (13254537)
　　
151028 14:35:25 [01]        ...done
　　
151028 14:35:25 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /data/mysql/backup/full/performance_schema/events_statements_summary_by_digest.frm
　　
151028 14:35:25 [01]        ...done
　　
151028 14:35:25 [01] Copying ./performance_schema/events_stages_history.frm to /data/mysql/backup/full/performance_schema/events_stages_history.frm
　　
151028 14:35:25 [01]        ...done
　　
151028 14:35:25 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /data/mysql/backup/full/performance_schema/file_summary_by_event_name.frm
　　
151028 14:35:25 [01]        ...done
　　
151028 14:35:25 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /data/mysql/backup/full/performance_schema/table_io_waits_summary_by_table.frm
　　
151028 14:35:25 [01]        ...done
　　
151028 14:35:25 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_stages_summary_by_thread_by_event_name.frm
　　
151028 14:35:25 [01]        ...done
　　
151028 14:35:26 [01] Copying ./performance_schema/threads.frm to /data/mysql/backup/full/performance_schema/threads.frm
　　
151028 14:35:26 [01]        ...done
　　
151028 14:35:26 [01] Copying ./performance_schema/accounts.frm to /data/mysql/backup/full/performance_schema/accounts.frm
　　
151028 14:35:26 [01]        ...done
　　
151028 14:35:26 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_waits_summary_global_by_event_name.frm
　　
151028 14:35:26 [01]        ...done
　　
151028 14:35:26 >> log scanned up to (13254537)
　　
151028 14:35:26 [01] Copying ./performance_schema/setup_objects.frm to /data/mysql/backup/full/performance_schema/setup_objects.frm
　　
151028 14:35:26 [01]        ...done
　　
151028 14:35:26 [01] Copying ./performance_schema/events_statements_current.frm to /data/mysql/backup/full/performance_schema/events_statements_current.frm
　　
151028 14:35:26 [01]        ...done
　　
151028 14:35:26 [01] Copying ./performance_schema/socket_instances.frm to /data/mysql/backup/full/performance_schema/socket_instances.frm
　　
151028 14:35:26 [01]        ...done
　　
151028 14:35:26 [01] Copying ./performance_schema/setup_actors.frm to /data/mysql/backup/full/performance_schema/setup_actors.frm
　　
151028 14:35:26 [01]        ...done
　　
151028 14:35:27 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_stages_summary_by_account_by_event_name.frm
　　
151028 14:35:27 [01]        ...done
　　
151028 14:35:27 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_stages_summary_by_host_by_event_name.frm
　　
151028 14:35:27 [01]        ...done
　　
151028 14:35:27 [01] Copying ./performance_schema/db.opt to /data/mysql/backup/full/performance_schema/db.opt
　　
151028 14:35:27 [01]        ...done
　　
151028 14:35:27 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_stages_summary_by_user_by_event_name.frm
　　
151028 14:35:27 [01]        ...done
　　
151028 14:35:27 >> log scanned up to (13254537)
　　
151028 14:35:27 [01] Copying ./performance_schema/events_statements_history.frm to /data/mysql/backup/full/performance_schema/events_statements_history.frm
　　
151028 14:35:27 [01]        ...done
　　
151028 14:35:27 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_waits_summary_by_account_by_event_name.frm
　　
151028 14:35:27 [01]        ...done
　　
151028 14:35:27 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /data/mysql/backup/full/performance_schema/events_waits_summary_by_instance.frm
　　
151028 14:35:27 [01]        ...done
　　
151028 14:35:27 [01] Copying ./performance_schema/setup_consumers.frm to /data/mysql/backup/full/performance_schema/setup_consumers.frm
　　
151028 14:35:27 [01]        ...done
　　
151028 14:35:28 [01] Copying ./performance_schema/setup_instruments.frm to /data/mysql/backup/full/performance_schema/setup_instruments.frm
　　
151028 14:35:28 [01]        ...done
　　
151028 14:35:28 [01] Copying ./performance_schema/mutex_instances.frm to /data/mysql/backup/full/performance_schema/mutex_instances.frm
　　
151028 14:35:28 [01]        ...done
　　
151028 14:35:28 [01] Copying ./performance_schema/events_statements_history_long.frm to /data/mysql/backup/full/performance_schema/events_statements_history_long.frm
　　
151028 14:35:28 [01]        ...done
　　
151028 14:35:28 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /data/mysql/backup/full/performance_schema/events_statements_summary_by_account_by_event_name.frm
　　
151028 14:35:28 [01]        ...done
　　
151028 14:35:28 >> log scanned up to (13254537)
　　
151028 14:35:28 [01] Copying ./performance_schema/events_stages_history_long.frm to /data/mysql/backup/full/performance_schema/events_stages_history_long.frm
　　
151028 14:35:28 [01]        ...done
　　
151028 14:35:28 Finished backing up non-InnoDB tables and files
　　
151028 14:35:28 Executing LOCK BINLOG FOR BACKUP...
　　
151028 14:35:28 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
　　
xtrabackup: The latest check point (for incremental): '13254537'
　　
xtrabackup: Stopping log copying thread.
　　
.151028 14:35:28 >> log scanned up to (13254537)
　　
151028 14:35:28 Executing UNLOCK BINLOG
　　
151028 14:35:28 Executing UNLOCK TABLES
　　
151028 14:35:28 All tables unlocked
　　
151028 14:35:28 Backup created in directory '/data/mysql/backup/full'
　　
151028 14:35:28 [00] Writing backup-my.cnf
　　
151028 14:35:28 [00]        ...done
　　
151028 14:35:29 [00] Writing xtrabackup_info
　　
151028 14:35:29 [00]        ...done
　　
xtrabackup: Transaction log of lsn (13254537) to (13254537) was copied.
　　
151028 14:35:29 completed OK!