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

zhaoke0727 发表于 2018-9-30 12:05:53

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:45version_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).
　　
# 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:59version_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:59version_check Connected to MySQL server
　　
151028 14:26:59version_check Executing a version check against the server...
　　
151028 14:26:59version_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 Copying ./ibdata1 to /data/mysql/backup/full/ibdata1
　　
151028 14:27:00    ...done
　　
151028 14:27:00 >> log scanned up to (13254537)
　　
151028 14:27:00 Copying ./ibdata2 to /data/mysql/backup/full/ibdata2
　　
151028 14:27:01    ...done
　　
151028 14:27:01 Copying ./prod/t2.ibd to /data/mysql/backup/full/prod/t2.ibd
　　
151028 14:27:01    ...done
　　
151028 14:27: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    ...done
　　
151028 14:27:01 Copying ./prod/t3.ibd to /data/mysql/backup/full/prod/t3.ibd
　　
151028 14:27:01    ...done
　　
151028 14:27:02 Copying ./mysql/slave_worker_info.ibd to /data/mysql/backup/full/mysql/slave_worker_info.ibd
　　
151028 14:27:02    ...done
　　
151028 14:27:02 Copying ./mysql/slave_master_info.ibd to /data/mysql/backup/full/mysql/slave_master_info.ibd
　　
151028 14:27:02    ...done
　　
151028 14:27:02 Copying ./mysql/slave_relay_log_info.ibd to /data/mysql/backup/full/mysql/slave_relay_log_info.ibd
　　
151028 14:27:02    ...done
　　
151028 14:27:02 Copying ./mysql/innodb_index_stats.ibd to /data/mysql/backup/full/mysql/innodb_index_stats.ibd
　　
151028 14:27:02    ...done
　　
151028 14:27:02 Copying ./mysql/innodb_table_stats.ibd to /data/mysql/backup/full/mysql/innodb_table_stats.ibd
　　
151028 14:27:02    ...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
　　
# 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:47version_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:47version_check Connected to MySQL server
　　
151028 14:34:47version_check Executing a version check against the server...
　　
151028 14:34:47version_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'.
　　
# ls
　　
bak.shfullprodt.txt
　　
# rm -rf full
　　
# 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:09version_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:09version_check Connected to MySQL server
　　
151028 14:35:09version_check Executing a version check against the server...
　　
151028 14:35:09version_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 Copying ./ibdata1 to /data/mysql/backup/full/ibdata1
　　
151028 14:35:10 >> log scanned up to (13254537)
　　
151028 14:35:10    ...done
　　
151028 14:35:11 Copying ./ibdata2 to /data/mysql/backup/full/ibdata2
　　
151028 14:35:11    ...done
　　
151028 14:35:11 >> log scanned up to (13254537)
　　
151028 14:35:11 Copying ./prod/t2.ibd to /data/mysql/backup/full/prod/t2.ibd
　　
151028 14:35:11    ...done
　　
151028 14:35:11 Copying ./prod/t1.ibd to /data/mysql/backup/full/prod/t1.ibd
　　
151028 14:35:12    ...done
　　
151028 14:35:12 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    ...done
　　
151028 14:35:12 Copying ./mysql/slave_worker_info.ibd to /data/mysql/backup/full/mysql/slave_worker_info.ibd
　　
151028 14:35:12    ...done
　　
151028 14:35:12 Copying ./mysql/slave_master_info.ibd to /data/mysql/backup/full/mysql/slave_master_info.ibd
　　
151028 14:35:12    ...done
　　
151028 14:35:12 Copying ./mysql/slave_relay_log_info.ibd to /data/mysql/backup/full/mysql/slave_relay_log_info.ibd
　　
151028 14:35:12    ...done
　　
151028 14:35:12 Copying ./mysql/innodb_index_stats.ibd to /data/mysql/backup/full/mysql/innodb_index_stats.ibd
　　
151028 14:35:12    ...done
　　
151028 14:35:12 Copying ./mysql/innodb_table_stats.ibd to /data/mysql/backup/full/mysql/innodb_table_stats.ibd
　　
151028 14:35:12    ...done
　　
151028 14:35:12 Starting to backup non-InnoDB tables and files
　　
151028 14:35:12 Copying ./prod/t1.frm to /data/mysql/backup/full/prod/t1.frm
　　
151028 14:35:13    ...done
　　
151028 14:35:13 Copying ./prod/t2.frm to /data/mysql/backup/full/prod/t2.frm
　　
151028 14:35:13    ...done
　　
151028 14:35:13 Copying ./prod/t3.frm to /data/mysql/backup/full/prod/t3.frm
　　
151028 14:35:13    ...done
　　
151028 14:35:13 Copying ./prod/db.opt to /data/mysql/backup/full/prod/db.opt
　　
151028 14:35:13    ...done
　　
151028 14:35:13 >> log scanned up to (13254537)
　　
151028 14:35:13 Writing test/db.opt
　　
151028 14:35:13    ...done
　　
151028 14:35:13 Copying ./mysql/time_zone_name.MYD to /data/mysql/backup/full/mysql/time_zone_name.MYD
　　
151028 14:35:13    ...done
　　
151028 14:35:13 Copying ./mysql/help_topic.frm to /data/mysql/backup/full/mysql/help_topic.frm
　　
151028 14:35:13    ...done
　　
151028 14:35:13 Copying ./mysql/event.frm to /data/mysql/backup/full/mysql/event.frm
　　
151028 14:35:13    ...done
　　
151028 14:35:13 Copying ./mysql/time_zone.MYD to /data/mysql/backup/full/mysql/time_zone.MYD
　　
151028 14:35:13    ...done
　　
151028 14:35:13 Copying ./mysql/slow_log.CSV to /data/mysql/backup/full/mysql/slow_log.CSV
　　
151028 14:35:13    ...done
　　
151028 14:35:13 Copying ./mysql/innodb_index_stats.frm to /data/mysql/backup/full/mysql/innodb_index_stats.frm
　　
151028 14:35:13    ...done
　　
151028 14:35:14 Copying ./mysql/columns_priv.MYI to /data/mysql/backup/full/mysql/columns_priv.MYI
　　
151028 14:35:14    ...done
　　
151028 14:35:14 Copying ./mysql/plugin.MYI to /data/mysql/backup/full/mysql/plugin.MYI
　　
151028 14:35:14    ...done
　　
151028 14:35:14 Copying ./mysql/time_zone_leap_second.frm to /data/mysql/backup/full/mysql/time_zone_leap_second.frm
　　
151028 14:35:14    ...done
　　
151028 14:35:14 Copying ./mysql/time_zone_transition_type.MYI to /data/mysql/backup/full/mysql/time_zone_transition_type.MYI
　　
151028 14:35:14    ...done
　　
151028 14:35:14 >> log scanned up to (13254537)
　　
151028 14:35:14 Copying ./mysql/proc.frm to /data/mysql/backup/full/mysql/proc.frm
　　
151028 14:35:14    ...done
　　
151028 14:35:14 Copying ./mysql/procs_priv.MYD to /data/mysql/backup/full/mysql/procs_priv.MYD
　　
151028 14:35:14    ...done
　　
151028 14:35:14 Copying ./mysql/proxies_priv.MYI to /data/mysql/backup/full/mysql/proxies_priv.MYI
　　
151028 14:35:14    ...done
　　
151028 14:35:14 Copying ./mysql/ndb_binlog_index.MYI to /data/mysql/backup/full/mysql/ndb_binlog_index.MYI
　　
151028 14:35:14    ...done
　　
151028 14:35:14 Copying ./mysql/servers.MYI to /data/mysql/backup/full/mysql/servers.MYI
　　
151028 14:35:14    ...done
　　
151028 14:35:15 Copying ./mysql/slow_log.frm to /data/mysql/backup/full/mysql/slow_log.frm
　　
151028 14:35:15    ...done
　　
151028 14:35:15 Copying ./mysql/help_relation.MYD to /data/mysql/backup/full/mysql/help_relation.MYD
　　
151028 14:35:15    ...done
　　
151028 14:35:15 Copying ./mysql/user.frm to /data/mysql/backup/full/mysql/user.frm
　　
151028 14:35:15    ...done
　　
151028 14:35:15 >> log scanned up to (13254537)
　　
151028 14:35:15 Copying ./mysql/plugin.frm to /data/mysql/backup/full/mysql/plugin.frm
　　
151028 14:35:15    ...done
　　
151028 14:35:15 Copying ./mysql/time_zone_name.frm to /data/mysql/backup/full/mysql/time_zone_name.frm
　　
151028 14:35:15    ...done
　　
151028 14:35:15 Copying ./mysql/user.MYI to /data/mysql/backup/full/mysql/user.MYI
　　
151028 14:35:15    ...done
　　
151028 14:35:15 Copying ./mysql/help_relation.frm to /data/mysql/backup/full/mysql/help_relation.frm
　　
151028 14:35:15    ...done
　　
151028 14:35:15 Copying ./mysql/slow_log.CSM to /data/mysql/backup/full/mysql/slow_log.CSM
　　
151028 14:35:15    ...done
　　
151028 14:35:16 Copying ./mysql/time_zone_transition.MYD to /data/mysql/backup/full/mysql/time_zone_transition.MYD
　　
151028 14:35:16    ...done
　　
151028 14:35:16 Copying ./mysql/help_category.MYI to /data/mysql/backup/full/mysql/help_category.MYI
　　
151028 14:35:16    ...done
　　
151028 14:35:16 Copying ./mysql/proc.MYD to /data/mysql/backup/full/mysql/proc.MYD
　　
151028 14:35:16    ...done
　　
151028 14:35:16 Copying ./mysql/db.MYD to /data/mysql/backup/full/mysql/db.MYD
　　
151028 14:35:16    ...done
　　
151028 14:35:16 >> log scanned up to (13254537)
　　
151028 14:35:16 Copying ./mysql/tables_priv.MYD to /data/mysql/backup/full/mysql/tables_priv.MYD
　　
151028 14:35:16    ...done
　　
151028 14:35:16 Copying ./mysql/time_zone_leap_second.MYI to /data/mysql/backup/full/mysql/time_zone_leap_second.MYI
　　
151028 14:35:16    ...done
　　
151028 14:35:16 Copying ./mysql/help_relation.MYI to /data/mysql/backup/full/mysql/help_relation.MYI
　　
151028 14:35:16    ...done
　　
151028 14:35:16 Copying ./mysql/ndb_binlog_index.MYD to /data/mysql/backup/full/mysql/ndb_binlog_index.MYD
　　
151028 14:35:16    ...done
　　
151028 14:35:16 Copying ./mysql/slave_worker_info.frm to /data/mysql/backup/full/mysql/slave_worker_info.frm
　　
151028 14:35:16    ...done
　　
151028 14:35:17 Copying ./mysql/time_zone.frm to /data/mysql/backup/full/mysql/time_zone.frm
　　
151028 14:35:17    ...done
　　
151028 14:35:17 Copying ./mysql/slave_relay_log_info.frm to /data/mysql/backup/full/mysql/slave_relay_log_info.frm
　　
151028 14:35:17    ...done
　　
151028 14:35:17 Copying ./mysql/columns_priv.MYD to /data/mysql/backup/full/mysql/columns_priv.MYD
　　
151028 14:35:17    ...done
　　
151028 14:35:17 >> log scanned up to (13254537)
　　
151028 14:35:17 Copying ./mysql/time_zone_transition_type.MYD to /data/mysql/backup/full/mysql/time_zone_transition_type.MYD
　　
151028 14:35:17    ...done
　　
151028 14:35:17 Copying ./mysql/user.MYD to /data/mysql/backup/full/mysql/user.MYD
　　
151028 14:35:17    ...done
　　
151028 14:35:17 Copying ./mysql/tables_priv.frm to /data/mysql/backup/full/mysql/tables_priv.frm
　　
151028 14:35:17    ...done
　　
151028 14:35:17 Copying ./mysql/help_category.MYD to /data/mysql/backup/full/mysql/help_category.MYD
　　
151028 14:35:17    ...done
　　
151028 14:35:17 Copying ./mysql/help_keyword.MYD to /data/mysql/backup/full/mysql/help_keyword.MYD
　　
151028 14:35:18    ...done
　　
151028 14:35:18 Copying ./mysql/time_zone_transition.frm to /data/mysql/backup/full/mysql/time_zone_transition.frm
　　
151028 14:35:18    ...done
　　
151028 14:35:18 Copying ./mysql/servers.frm to /data/mysql/backup/full/mysql/servers.frm
　　
151028 14:35:18    ...done
　　
151028 14:35:18 Copying ./mysql/general_log.frm to /data/mysql/backup/full/mysql/general_log.frm
　　
151028 14:35:18    ...done
　　
151028 14:35:18 >> log scanned up to (13254537)
　　
151028 14:35:18 Copying ./mysql/help_keyword.frm to /data/mysql/backup/full/mysql/help_keyword.frm
　　
151028 14:35:18    ...done
　　
151028 14:35:18 Copying ./mysql/time_zone_transition_type.frm to /data/mysql/backup/full/mysql/time_zone_transition_type.frm
　　
151028 14:35:18    ...done
　　
151028 14:35:18 Copying ./mysql/columns_priv.frm to /data/mysql/backup/full/mysql/columns_priv.frm
　　
151028 14:35:18    ...done
　　
151028 14:35:18 Copying ./mysql/proxies_priv.frm to /data/mysql/backup/full/mysql/proxies_priv.frm
　　
151028 14:35:18    ...done
　　
151028 14:35:19 Copying ./mysql/help_keyword.MYI to /data/mysql/backup/full/mysql/help_keyword.MYI
　　
151028 14:35:19    ...done
　　
151028 14:35:19 Copying ./mysql/general_log.CSV to /data/mysql/backup/full/mysql/general_log.CSV
　　
151028 14:35:19    ...done
　　
151028 14:35:19 Copying ./mysql/event.MYD to /data/mysql/backup/full/mysql/event.MYD
　　
151028 14:35:19    ...done
　　
151028 14:35:19 Copying ./mysql/plugin.MYD to /data/mysql/backup/full/mysql/plugin.MYD
　　
151028 14:35:19    ...done
　　
151028 14:35:19 Copying ./mysql/proxies_priv.MYD to /data/mysql/backup/full/mysql/proxies_priv.MYD
　　
151028 14:35:19    ...done
　　
151028 14:35:19 >> log scanned up to (13254537)
　　
151028 14:35:19 Copying ./mysql/servers.MYD to /data/mysql/backup/full/mysql/servers.MYD
　　
151028 14:35:19    ...done
　　
151028 14:35:19 Copying ./mysql/event.MYI to /data/mysql/backup/full/mysql/event.MYI
　　
151028 14:35:19    ...done
　　
151028 14:35:19 Copying ./mysql/time_zone_transition.MYI to /data/mysql/backup/full/mysql/time_zone_transition.MYI
　　
151028 14:35:19    ...done
　　
151028 14:35:19 Copying ./mysql/tables_priv.MYI to /data/mysql/backup/full/mysql/tables_priv.MYI
　　
151028 14:35:19    ...done
　　
151028 14:35:19 Copying ./mysql/ndb_binlog_index.frm to /data/mysql/backup/full/mysql/ndb_binlog_index.frm
　　
151028 14:35:19    ...done
　　
151028 14:35:20 Copying ./mysql/db.MYI to /data/mysql/backup/full/mysql/db.MYI
　　
151028 14:35:20    ...done
　　
151028 14:35:20 Copying ./mysql/time_zone_name.MYI to /data/mysql/backup/full/mysql/time_zone_name.MYI
　　
151028 14:35:20    ...done
　　
151028 14:35:20 Copying ./mysql/time_zone_leap_second.MYD to /data/mysql/backup/full/mysql/time_zone_leap_second.MYD
　　
151028 14:35:20    ...done
　　
151028 14:35:20 >> log scanned up to (13254537)
　　
151028 14:35:20 Copying ./mysql/help_topic.MYD to /data/mysql/backup/full/mysql/help_topic.MYD
　　
151028 14:35:20    ...done
　　
151028 14:35:20 Copying ./mysql/help_topic.MYI to /data/mysql/backup/full/mysql/help_topic.MYI
　　
151028 14:35:20    ...done
　　
151028 14:35:20 Copying ./mysql/db.frm to /data/mysql/backup/full/mysql/db.frm
　　
151028 14:35:20    ...done
　　
151028 14:35:20 Copying ./mysql/func.MYI to /data/mysql/backup/full/mysql/func.MYI
　　
151028 14:35:20    ...done
　　
151028 14:35:20 Copying ./mysql/procs_priv.MYI to /data/mysql/backup/full/mysql/procs_priv.MYI
　　
151028 14:35:21    ...done
　　
151028 14:35:21 Copying ./mysql/help_category.frm to /data/mysql/backup/full/mysql/help_category.frm
　　
151028 14:35:21    ...done
　　
151028 14:35:21 Copying ./mysql/procs_priv.frm to /data/mysql/backup/full/mysql/procs_priv.frm
　　
151028 14:35:21    ...done
　　
151028 14:35:21 Copying ./mysql/func.MYD to /data/mysql/backup/full/mysql/func.MYD
　　
151028 14:35:21    ...done
　　
151028 14:35:21 >> log scanned up to (13254537)
　　
151028 14:35:21 Copying ./mysql/func.frm to /data/mysql/backup/full/mysql/func.frm
　　
151028 14:35:21    ...done
　　
151028 14:35:21 Copying ./mysql/proc.MYI to /data/mysql/backup/full/mysql/proc.MYI
　　
151028 14:35:21    ...done
　　
151028 14:35:21 Copying ./mysql/general_log.CSM to /data/mysql/backup/full/mysql/general_log.CSM
　　
151028 14:35:21    ...done
　　
151028 14:35:21 Copying ./mysql/time_zone.MYI to /data/mysql/backup/full/mysql/time_zone.MYI
　　
151028 14:35:21    ...done
　　
151028 14:35:21 Copying ./mysql/slave_master_info.frm to /data/mysql/backup/full/mysql/slave_master_info.frm
　　
151028 14:35:21    ...done
　　
151028 14:35:22 Copying ./mysql/innodb_table_stats.frm to /data/mysql/backup/full/mysql/innodb_table_stats.frm
　　
151028 14:35:22    ...done
　　
151028 14:35:22 Copying ./performance_schema/users.frm to /data/mysql/backup/full/performance_schema/users.frm
　　
151028 14:35:22    ...done
　　
151028 14:35:22 Copying ./performance_schema/events_waits_history_long.frm to /data/mysql/backup/full/performance_schema/events_waits_history_long.frm
　　
151028 14:35:22    ...done
　　
151028 14:35:22 >> log scanned up to (13254537)
　　
151028 14:35:22 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    ...done
　　
151028 14:35:22 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    ...done
　　
151028 14:35:22 Copying ./performance_schema/events_waits_history.frm to /data/mysql/backup/full/performance_schema/events_waits_history.frm
　　
151028 14:35:22    ...done
　　
151028 14:35:22 Copying ./performance_schema/host_cache.frm to /data/mysql/backup/full/performance_schema/host_cache.frm
　　
151028 14:35:22    ...done
　　
151028 14:35:22 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    ...done
　　
151028 14:35:23 Copying ./performance_schema/session_connect_attrs.frm to /data/mysql/backup/full/performance_schema/session_connect_attrs.frm
　　
151028 14:35:23    ...done
　　
151028 14:35:23 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    ...done
　　
151028 14:35:23 Copying ./performance_schema/session_account_connect_attrs.frm to /data/mysql/backup/full/performance_schema/session_account_connect_attrs.frm
　　
151028 14:35:23    ...done
　　
151028 14:35:23 >> log scanned up to (13254537)
　　
151028 14:35:23 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    ...done
　　
151028 14:35:23 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    ...done
　　
151028 14:35:23 Copying ./performance_schema/rwlock_instances.frm to /data/mysql/backup/full/performance_schema/rwlock_instances.frm
　　
151028 14:35:23    ...done
　　
151028 14:35:23 Copying ./performance_schema/events_stages_current.frm to /data/mysql/backup/full/performance_schema/events_stages_current.frm
　　
151028 14:35:23    ...done
　　
151028 14:35:23 Copying ./performance_schema/file_summary_by_instance.frm to /data/mysql/backup/full/performance_schema/file_summary_by_instance.frm
　　
151028 14:35:23    ...done
　　
151028 14:35:24 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    ...done
　　
151028 14:35:24 Copying ./performance_schema/performance_timers.frm to /data/mysql/backup/full/performance_schema/performance_timers.frm
　　
151028 14:35:24    ...done
　　
151028 14:35:24 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    ...done
　　
151028 14:35:24 >> log scanned up to (13254537)
　　
151028 14:35:24 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    ...done
　　
151028 14:35:24 Copying ./performance_schema/cond_instances.frm to /data/mysql/backup/full/performance_schema/cond_instances.frm
　　
151028 14:35:24    ...done
　　
151028 14:35:24 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    ...done
　　
151028 14:35:24 Copying ./performance_schema/setup_timers.frm to /data/mysql/backup/full/performance_schema/setup_timers.frm
　　
151028 14:35:24    ...done
　　
151028 14:35:24 Copying ./performance_schema/hosts.frm to /data/mysql/backup/full/performance_schema/hosts.frm
　　
151028 14:35:24    ...done
　　
151028 14:35:25 Copying ./performance_schema/socket_summary_by_instance.frm to /data/mysql/backup/full/performance_schema/socket_summary_by_instance.frm
　　
151028 14:35:25    ...done
　　
151028 14:35:25 Copying ./performance_schema/file_instances.frm to /data/mysql/backup/full/performance_schema/file_instances.frm
　　
151028 14:35:25    ...done
　　
151028 14:35:25 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    ...done
　　
151028 14:35:25 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    ...done
　　
151028 14:35:25 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    ...done
　　
151028 14:35:25 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    ...done
　　
151028 14:35:25 Copying ./performance_schema/events_stages_history.frm to /data/mysql/backup/full/performance_schema/events_stages_history.frm
　　
151028 14:35:25    ...done
　　
151028 14:35:25 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    ...done
　　
151028 14:35:25 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    ...done
　　
151028 14:35:25 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    ...done
　　
151028 14:35:26 Copying ./performance_schema/threads.frm to /data/mysql/backup/full/performance_schema/threads.frm
　　
151028 14:35:26    ...done
　　
151028 14:35:26 Copying ./performance_schema/accounts.frm to /data/mysql/backup/full/performance_schema/accounts.frm
　　
151028 14:35:26    ...done
　　
151028 14:35:26 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    ...done
　　
151028 14:35:26 >> log scanned up to (13254537)
　　
151028 14:35:26 Copying ./performance_schema/setup_objects.frm to /data/mysql/backup/full/performance_schema/setup_objects.frm
　　
151028 14:35:26    ...done
　　
151028 14:35:26 Copying ./performance_schema/events_statements_current.frm to /data/mysql/backup/full/performance_schema/events_statements_current.frm
　　
151028 14:35:26    ...done
　　
151028 14:35:26 Copying ./performance_schema/socket_instances.frm to /data/mysql/backup/full/performance_schema/socket_instances.frm
　　
151028 14:35:26    ...done
　　
151028 14:35:26 Copying ./performance_schema/setup_actors.frm to /data/mysql/backup/full/performance_schema/setup_actors.frm
　　
151028 14:35:26    ...done
　　
151028 14:35:27 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    ...done
　　
151028 14:35:27 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    ...done
　　
151028 14:35:27 Copying ./performance_schema/db.opt to /data/mysql/backup/full/performance_schema/db.opt
　　
151028 14:35:27    ...done
　　
151028 14:35:27 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    ...done
　　
151028 14:35:27 >> log scanned up to (13254537)
　　
151028 14:35:27 Copying ./performance_schema/events_statements_history.frm to /data/mysql/backup/full/performance_schema/events_statements_history.frm
　　
151028 14:35:27    ...done
　　
151028 14:35:27 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    ...done
　　
151028 14:35:27 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    ...done
　　
151028 14:35:27 Copying ./performance_schema/setup_consumers.frm to /data/mysql/backup/full/performance_schema/setup_consumers.frm
　　
151028 14:35:27    ...done
　　
151028 14:35:28 Copying ./performance_schema/setup_instruments.frm to /data/mysql/backup/full/performance_schema/setup_instruments.frm
　　
151028 14:35:28    ...done
　　
151028 14:35:28 Copying ./performance_schema/mutex_instances.frm to /data/mysql/backup/full/performance_schema/mutex_instances.frm
　　
151028 14:35:28    ...done
　　
151028 14:35:28 Copying ./performance_schema/events_statements_history_long.frm to /data/mysql/backup/full/performance_schema/events_statements_history_long.frm
　　
151028 14:35:28    ...done
　　
151028 14:35:28 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    ...done
　　
151028 14:35:28 >> log scanned up to (13254537)
　　
151028 14:35:28 Copying ./performance_schema/events_stages_history_long.frm to /data/mysql/backup/full/performance_schema/events_stages_history_long.frm
　　
151028 14:35:28    ...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 Writing backup-my.cnf
　　
151028 14:35:28    ...done
　　
151028 14:35:29 Writing xtrabackup_info
　　
151028 14:35:29    ...done
　　
xtrabackup: Transaction log of lsn (13254537) to (13254537) was copied.
　　
151028 14:35:29 completed OK!

页: [1]

运维网's Archiver

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