mysql备份之Xtrabackup

最新推荐文章于 2024-06-01 15:29:46 发布

BOBO_Free

最新推荐文章于 2024-06-01 15:29:46 发布

阅读量2.6k

点赞数

分类专栏： Mysql基础文章标签： Xtrabackup

Mysql基础专栏收录该内容

14 篇文章 0 订阅

订阅专栏

Xtrabackup是一个对InnoDB,做数据备份的工具，支持在线热备份（备份时不影响数据读写），是商业备份工具InnoDB Hotbackup的一个很好的替代品。

Xtrabackup中包含两个工具：

* xtrabackup - 用于热备份innodb, xtradb表的工具，不能备份其他表。
* innobackupex - 对xtrabackup封装的perl脚本，提供了myisam表备份的能力。

Xtrabackup可以做什么

    * 在线(热)备份整个库的InnoDB, XtraDB表
    * 在xtrabackup的上一次整库备份基础上做增量备份（innodb only）
    * 以流的形式产生备份，可以直接保存到远程机器上（本机硬盘空间不足时很有用）

Xtrabackup如何工作的

    * xtrabackup - 具体原理有待研究。。。
    * innobackupex整库备份
         1. 调用xtrabackup对innodb表空间文件（这一瞬间的映像Time1）备份，而在这个innodb表备份期间数据库是不加锁的，外部可以继续往库里增减数据（这才能叫热备份）。而在Time1和Time2这两个时间点之间的改动由一个线程不断地扫innodb log获得(ChangeSet1)。
         2. 锁所有库。
         3. 以直接拷贝的方式备份frm,MYD,MYI,MRG,TRG,TRN,opt格式的文件。
         4. 步骤3中的数据备份完毕时(Time2)，停止扫innodb log的线程，把ChangeSet1的数据拷贝到备份中。
         5. 解锁所有库。
         6. 终止挂起，备份完毕。

注意要点

    * 根据innobackupex的原理可知它不是真正的热备份，MyISAM表越少越小就越有利。要利用Xtrabackup的好处就尽量用innodb表。
    * 还原备份前关闭mysql服务；还原备份后检查数据文件权限是否正确。
    * 性能：备份一个数据目录总大小5.6G，其中ibdata 2G，总时间4分钟，锁表时间2.5分钟。如果用mysqldump做这个库的备份锁表时间是5-8倍。

Xtrabackup备份原理：

在InnoDB内部会维护一个redo日志文件，我们也可以叫做事务日志文件。事务日志会存储每一个InnoDB表数据的记录修改。当InnoDB启动时，InnoDB会检查数据文件和事务日志，并执行两个步骤：它应用（前滚）已经提交的事务日志到数据文件，并将修改过但没有提交的数据进行回滚操作。

xtrabackup在启动时会记住log sequence number（LSN），并且复制所有的数据文件。复制过程需要一些时间，所以这期间如果数据文件有改动，那么将会使数据库处于一个不同的时间点。这时，xtrabackup会运行一个后台进程，用于监视事务日志，并从事务日志复制最新的修改。xtrabackup必须持续的做这个操作，是因为事务日志是会轮转重复的写入，并且事务日志可以被重用。所以xtrabackup自启动开始，就不停的将事务日志中每个数据文件的修改都记录下来。

上面就是xtrabackup的备份过程。接下来是准备（prepare）过程。在这个过程中，xtrabackup使用之前复制的事务日志，对各个数据文件执行灾难恢复（就像MySQL刚启动时要做的一样）。当这个过程结束后，数据库就可以做恢复还原了。

以上的过程在xtrabackup的编译二进制程序中实现。程序innobackupex可以允许我们备份MyISAM表和frm文件从而增加了便捷和功能。Innobackupex会启动xtrabackup，直到xtrabackup复制数据文件后，然后执行FLUSH TABLES WITH READ LOCK来阻止新的写入进来并把MyISAM表数据刷到硬盘上，之后复制MyISAM数据文件，最后释放锁。

备份MyISAM和InnoDB表最终会处于一致，在准备（prepare）过程结束后，InnoDB表数据已经前滚到整个备份结束的点，而不是回滚到xtrabackup刚开始时的点。这个时间点与执行FLUSH TABLES WITH READ LOCK的时间点相同，所以MyISAM表数据与InnoDB表数据是同步的。类似Oracle的，InnoDB的prepare过程可以称为recover（恢复），MyISAM的数据复制过程可以称为restore（还原）。

xtrabackup和innobackupex这两个工具都提供了许多前文没有提到的功能特点。手册上有对各个功能都有详细的介绍。简单介绍下，这些工具提供了如流（streaming）备份，增量（incremental）备份等，通过复制数据文件，复制日志文件和提交日志到数据文件（前滚）实现了各种复合备份方式。

如下图所示：

案例分析：

一、数据库全备

1、创建配置文件

[root@rh64 ~]# cat /tmp/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
innodb_data_file_path=ibdata1:12M;ibdata2:10M:autoextend
innodb_log_files_in_group=2
innodb_log_file_size=50331648

2、创建备份目录
[root@rh64 ~]# ls -ld /data/mysql/backup/
drwxrwxrwx. 3 mysql mysql 4096 Oct 15 12:13 /data/mysql/backup/

3、测试
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| prod |
| test |
+--------------------+
5 rows in set (0.06 sec)

mysql> use prod;
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> show tables;
+----------------+
| Tables_in_prod |
+----------------+
| t1 |
| t2 |
| t3 |
+----------------+
3 rows in set (0.00 sec)

mysql> select count(*) from t1;
+----------+
| count(*) |
+----------+
| 49152 |
+----------+
1 row in set (0.13 sec)

插入数据：
mysql> insert into t1 select * from t1;
Query OK, 49152 rows affected (0.69 sec)
Records: 49152 Duplicates: 0 Warnings: 0
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql> select count(*) from t1;
+----------+
| count(*) |
+----------+
| 98304 |
+----------+
1 row in set (0.03 sec)

4、创建备份用户并授权
mysql> create user 'bkusr'@'%' identified by 'oracle';
Query OK, 0 rows affected (0.00 sec)
mysql> grant reload,create tablespace,lock tables ,replication client,super on *.* to 'bakusr'@'%';
Query OK, 0 rows affected (0.00 sec
mysql> create user 'bakusr'@localhost identified by 'oracle';
Query OK, 0 rows affected (0.00 sec)

5、进行数据库全备
[root@rh64 ~]# innobackupex --user=bakusr --password='oracle' --socket=/var/lib/mysql/mysql.sock --defaults-file=/tmp/my.cnf /data/mysql/backup/full
xtrabackup: Error: --defaults-file must be specified first on the command line
----提示配置文件参数必须放在第一位

以root用户备份：
[root@rh64 ~]# innobackupex --defaults-file=/etc/my.cnf --user=root --password='oracle' --socket=/var/lib/mysql/mysql.sock /data/mysql/backup/full

[html] view plain copy print ?

151028 14:18:16 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:18:16 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:18:16 version_check Connected to MySQL server
151028 14:18:16 version_check Executing a version check against the server...
151028 14:18:16 version_check Done.
151028 14:18:16 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:18:16 >> log scanned up to (13254527)
xtrabackup: Generating a list of tablespaces
151028 14:18:16 [01] Copying ./ibdata1 to /data/mysql/backup/full/2015-10-28_14-18-16/ibdata1
151028 14:18:17 [01] ...done
151028 14:18:17 [01] Copying ./ibdata2 to /data/mysql/backup/full/2015-10-28_14-18-16/ibdata2
151028 14:18:17 >> log scanned up to (13254527)
151028 14:18:17 [01] ...done
151028 14:18:17 [01] Copying ./prod/t2.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/prod/t2.ibd
151028 14:18:17 [01] ...done
151028 14:18:17 [01] Copying ./prod/t1.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/prod/t1.ibd
151028 14:18:18 [01] ...done
151028 14:18:18 >> log scanned up to (13254527)
151028 14:18:18 [01] Copying ./prod/t3.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/prod/t3.ibd
151028 14:18:18 [01] ...done
151028 14:18:18 [01] Copying ./mysql/slave_worker_info.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/slave_worker_info.ibd
151028 14:18:18 [01] ...done
151028 14:18:18 [01] Copying ./mysql/slave_master_info.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/slave_master_info.ibd
151028 14:18:18 [01] ...done
151028 14:18:18 [01] Copying ./mysql/slave_relay_log_info.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/slave_relay_log_info.ibd
151028 14:18:18 [01] ...done
151028 14:18:18 [01] Copying ./mysql/innodb_index_stats.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/innodb_index_stats.ibd
151028 14:18:19 [01] ...done
151028 14:18:19 [01] Copying ./mysql/innodb_table_stats.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/innodb_table_stats.ibd
151028 14:18:19 [01] ...done
......
151028 14:21:39 Executing UNLOCK BINLOG
151028 14:21:39 Executing UNLOCK TABLES
151028 14:21:39 All tables unlocked
151028 14:21:39 Backup created in directory '/data/mysql/backup/full/2015-10-28_14-21-20'
151028 14:21:39 [00] Writing backup-my.cnf
151028 14:21:39 [00] ...done
151028 14:21:39 [00] Writing xtrabackup_info
151028 14:21:39 [00] ...done
xtrabackup: Transaction log of lsn (13254537) to (13254537) was copied.
151028 14:21:39 completed OK!

151028 14:18:16 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:18:16  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:18:16  version_check Connected to MySQL server
151028 14:18:16  version_check Executing a version check against the server...
151028 14:18:16  version_check Done.
151028 14:18:16 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:18:16 >> log scanned up to (13254527)
xtrabackup: Generating a list of tablespaces
151028 14:18:16 [01] Copying ./ibdata1 to /data/mysql/backup/full/2015-10-28_14-18-16/ibdata1
151028 14:18:17 [01]        ...done
151028 14:18:17 [01] Copying ./ibdata2 to /data/mysql/backup/full/2015-10-28_14-18-16/ibdata2
151028 14:18:17 >> log scanned up to (13254527)
151028 14:18:17 [01]        ...done
151028 14:18:17 [01] Copying ./prod/t2.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/prod/t2.ibd
151028 14:18:17 [01]        ...done
151028 14:18:17 [01] Copying ./prod/t1.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/prod/t1.ibd
151028 14:18:18 [01]        ...done
151028 14:18:18 >> log scanned up to (13254527)
151028 14:18:18 [01] Copying ./prod/t3.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/prod/t3.ibd
151028 14:18:18 [01]        ...done
151028 14:18:18 [01] Copying ./mysql/slave_worker_info.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/slave_worker_info.ibd
151028 14:18:18 [01]        ...done
151028 14:18:18 [01] Copying ./mysql/slave_master_info.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/slave_master_info.ibd
151028 14:18:18 [01]        ...done
151028 14:18:18 [01] Copying ./mysql/slave_relay_log_info.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/slave_relay_log_info.ibd
151028 14:18:18 [01]        ...done
151028 14:18:18 [01] Copying ./mysql/innodb_index_stats.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/innodb_index_stats.ibd
151028 14:18:19 [01]        ...done
151028 14:18:19 [01] Copying ./mysql/innodb_table_stats.ibd to /data/mysql/backup/full/2015-10-28_14-18-16/mysql/innodb_table_stats.ibd
151028 14:18:19 [01]        ...done
......
151028 14:21:39 Executing UNLOCK BINLOG
151028 14:21:39 Executing UNLOCK TABLES
151028 14:21:39 All tables unlocked
151028 14:21:39 Backup created in directory '/data/mysql/backup/full/2015-10-28_14-21-20'
151028 14:21:39 [00] Writing backup-my.cnf
151028 14:21:39 [00]        ...done
151028 14:21:39 [00] Writing xtrabackup_info
151028 14:21:39 [00]        ...done
xtrabackup: Transaction log of lsn (13254537) to (13254537) was copied.
151028 14:21:39 completed OK!

查看备份：
[root@rh64 backup]# ls
bak.sh full prod t.txt
[root@rh64 backup]# cd full
[root@rh64 full]# ls
2015-10-28_14-23-23
[root@rh64 full]# cd 2015-10-28_14-23-23/
[root@rh64 2015-10-28_14-23-23]# ls -lt
total 22560
-rw-r----- 1 root root 507 Oct 28 14:23 xtrabackup_info
-rw-r----- 1 root root 398 Oct 28 14:23 backup-my.cnf
-rw-r----- 1 root root 115 Oct 28 14:23 xtrabackup_checkpoints
-rw-r----- 1 root root 2560 Oct 28 14:23 xtrabackup_logfile
drwx------ 2 root root 4096 Oct 28 14:23 performance_schema
drwx------ 2 root root 4096 Oct 28 14:23 mysql
drwx------ 2 root root 4096 Oct 28 14:23 test
drwx------ 2 root root 4096 Oct 28 14:23 prod
-rw-r----- 1 root root 10485760 Oct 28 14:23 ibdata2
-rw-r----- 1 root root 12582912 Oct 28 14:23 ibdata1
[root@rh64 2015-10-28_14-23-23]#

使用参数：--no-timestamp
[root@rh64 backup]# innobackupex --defaults-file=/etc/my.cnf --user=root --password='oracle' --socket=/var/lib/mysql/mysql.sock /data/mysql/backup/full --no-timestamp

则不建立时间相关的目录：
[root@rh64 backup]# ls
bak.sh full prod t.txt
[root@rh64 backup]# cd full
[root@rh64 full]# ls
backup-my.cnf ibdata2 performance_schema test xtrabackup_info
ibdata1 mysql prod xtrabackup_checkpoints xtrabackup_logfile
[root@rh64 full]# ls -l
total 22560
-rw-r----- 1 root root 398 Oct 28 14:25 backup-my.cnf
-rw-r----- 1 root root 12582912 Oct 28 14:25 ibdata1
-rw-r----- 1 root root 10485760 Oct 28 14:25 ibdata2
drwx------ 2 root root 4096 Oct 28 14:25 mysql
drwx------ 2 root root 4096 Oct 28 14:25 performance_schema
drwx------ 2 root root 4096 Oct 28 14:25 prod
drwx------ 2 root root 4096 Oct 28 14:25 test
-rw-r----- 1 root root 115 Oct 28 14:25 xtrabackup_checkpoints
-rw-r----- 1 root root 522 Oct 28 14:25 xtrabackup_info
-rw-r----- 1 root root 2560 Oct 28 14:25 xtrabackup_logfile

使用普通用户备份：
[root@rh64 ~]# innobackupex --defaults-file=/etc/my.cnf --user=bakusr --password='oracle' --socket=/var/lib/mysql/mysql.sock /data/mysql/backup/full
Error: failed to execute query LOCK TABLES FOR BACKUP: Access denied; you need (at least one of) the RELOAD privilege(s) for this operation

----提示：缺少reload权限

查看用户权限：
mysql> select user,host,Reload_priv from user where user='bakusr';
+--------+-----------+-------------+
| user | host | Reload_priv |
+--------+-----------+-------------+
| bakusr | % | Y |
| bakusr | localhost | N |
+--------+-----------+-------------+
2 rows in set (0.04 sec)

授权：
mysql> grant reload,create tablespace,lock tables ,replication client,super on *.* to 'bakusr'@localhost;
Query OK, 0 rows affected (0.08 sec)

mysql> select user,host,Reload_priv from user where user='bakusr';
+--------+-----------+-------------+
| user | host | Reload_priv |
+--------+-----------+-------------+
| bakusr | % | Y |
| bakusr | localhost | Y |
+--------+-----------+-------------+
2 rows in set (0.15 sec)

备份：

[root@rh64 ~]# innobackupex --defaults-file=/etc/my.cnf --user=bakusr --password='oracle' --socket=/var/lib/mysql/mysql.sock /data/mysql/backup/full --no-timestamp

[html] view plain copy print ?

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!

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!

[root@rh64 backup]# ls -l full
total 22560
-rw-r----- 1 root root 398 Oct 28 14:35 backup-my.cnf
-rw-r----- 1 root root 12582912 Oct 28 14:35 ibdata1
-rw-r----- 1 root root 10485760 Oct 28 14:35 ibdata2
drwx------ 2 root root 4096 Oct 28 14:35 mysql
drwx------ 2 root root 4096 Oct 28 14:35 performance_schema
drwx------ 2 root root 4096 Oct 28 14:35 prod
drwx------ 2 root root 4096 Oct 28 14:35 test
-rw-r----- 1 root root 115 Oct 28 14:35 xtrabackup_checkpoints
-rw-r----- 1 root root 524 Oct 28 14:35 xtrabackup_info
-rw-r----- 1 root root 2560 Oct 28 14:35 xtrabackup_logfile

二、数据库恢复

1、测试

关闭数据库，更改datadir目录

[mysql@rh64 ~]$ service mysql stop
Shutting down MySQL (Percona Server)...[ OK ]
rm: cannot remove `/var/lock/subsys/mysql': Permission denied

[root@rh64 ~]# mv /var/lib/mysql /var/lib/mysql.bak
[root@rh64 ~]# cd /var/lib/mysql.bak
[root@rh64 mysql.bak]# ls
auto.cnf ibdata2 ib_logfile1 mysql prod RPM_UPGRADE_HISTORY test
ibdata1 ib_logfile0 ib_logfile101 performance_schema rh64.pid RPM_UPGRADE_MARKER-LAST

创建新的datadir:
[root@rh64 mysql.bak]# mkdir /var/lib/mysql

数据库恢复：
[root@rh64 backup]# innobackupex --defaults-file=/etc/my.cnf --copy-back --rsync /data/mysql/backup/full
......
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
......
151028 14:41:53 [01] ...done
151028 14:41:53 [01] Copying ./performance_schema/events_stages_history_long.frm to /var/lib/mysql/performance_schema/events_stages_history_long.frm
151028 14:41:53 [01] ...done
151028 14:41:53 [01] Copying ./xtrabackup_info to /var/lib/mysql/xtrabackup_info
151028 14:41:53 [01] ...done
151028 14:41:54 completed OK!

重新授权datadir：

[root@rh64 lib]# ls -ld mysql.bak/
drwxr-xr-x. 6 mysql mysql 4096 Oct 28 14:38 mysql.bak/
[root@rh64 lib]# ls -ld mysql
drwxr-xr-x 6 root root 4096 Oct 28 14:45 mysql
[root@rh64 lib]# ls -l mysql.bak/
total 170020
-rw-rw----. 1 mysql mysql 56 Sep 6 18:08 auto.cnf
-rw-rw----. 1 mysql mysql 12582912 Oct 28 14:38 ibdata1
-rw-rw----. 1 mysql mysql 10485760 Oct 28 14:38 ibdata2
-rw-rw----. 1 mysql mysql 50331648 Oct 28 14:38 ib_logfile0
-rw-rw----. 1 mysql mysql 50331648 Sep 6 18:06 ib_logfile1
-rw-rw----. 1 mysql mysql 50331648 Sep 11 11:50 ib_logfile101
drwx------. 2 mysql mysql 4096 Sep 6 18:06 mysql
drwx------. 2 mysql mysql 4096 Sep 6 18:06 performance_schema
drwx------. 2 mysql mysql 4096 Oct 13 16:41 prod
-rw-rw----. 1 mysql mysql 5 Oct 15 11:36 rh64.pid
-rw-r--r--. 1 root root 293 Sep 6 18:07 RPM_UPGRADE_HISTORY
-rw-r--r--. 1 mysql mysql 293 Sep 6 18:07 RPM_UPGRADE_MARKER-LAST
drwx------. 2 mysql mysql 4096 Sep 6 18:06 test
[root@rh64 lib]# chown -R mysql.mysql mysql

验证数据恢复：
[root@rh64 lib]# service mysql start
Starting MySQL (Percona Server)....[ OK ]
[root@rh64 lib]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.25-73.1 Percona Server (GPL), Release 73.1, Revision 07b797f
Copyright (c) 2009-2015 Percona LLC and/or its affiliates
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

mysql> use prod;
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> select count(*) from t1;
+----------+
| count(*) |
+----------+
| 98304 |
+----------+
1 row in set (0.04 sec)

---至此，数据恢复成功！！！

在MySQL中进行增量备份时，首先要进行一次全量备份，第一次增量备份是基于全备的，之后的增量备份是基于上一次的增量备份。

备份案例：

一、建立增量备份

1、构建测试环境：

[root@rh64 full]# service mysql start
Starting MySQL (Percona Server)[ OK ]
[root@rh64 full]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.25-73.1 Percona Server (GPL), Release 73.1, Revision 07b797f
Copyright (c) 2009-2015 Percona LLC and/or its affiliates
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use prod;
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> select count(*) from t1;
+----------+
| count(*) |
+----------+
| 98304 |
+----------+
1 row in set (0.12 sec)

对数据库做一次全备：
【root@rh64 ~]# innobackupex --defaults-file=/etc/my.cnf --user=bakusr --password='oracle' --socket=/var/lib/mysql/mysql.sock /data/mysql/backup/full --no-timestamp

2、插入新的数据，做增量备份

mysql> insert into t1 select * from t1 order by 1 limit 10000;
Query OK, 10000 rows affected (0.46 sec)
Records: 10000 Duplicates: 0 Warnings: 0
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql> select count(*) from t1;
+----------+
| count(*) |
+----------+
| 108304 |
+----------+
1 row in set (0.03 sec)

第一次增量备份：
[root@rh64 full]# innobackupex --defaults-file=/tmp/my.cnf --user=bakusr --password='oracle' --socket=/var/lib/mysql/mysql.sock --incremental-basedir=/data/mysql/backup/full --incremental /data/mysql/backup/inc_1 --no-timestamp --parallel=2

[html] view plain copy print ?

.....
151029 15:11:38 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /data/mysql/backup/inc_1/performance_schema/events_statements_summary_by_account_by_event_name.frm
151029 15:11:38 [01] ...done
151029 15:11:38 [01] Copying ./performance_schema/events_stages_history_long.frm to /data/mysql/backup/inc_1/performance_schema/events_stages_history_long.frm
151029 15:11:38 [01] ...done
151029 15:11:38 Finished backing up non-InnoDB tables and files
151029 15:11:38 Executing LOCK BINLOG FOR BACKUP...
151029 15:11:38 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '13869220'
xtrabackup: Stopping log copying thread.
.151029 15:11:38 >> log scanned up to (13869220)
......
151029 15:11:38 Executing UNLOCK BINLOG
151029 15:11:38 Executing UNLOCK TABLES
151029 15:11:38 All tables unlocked
151029 15:11:38 Backup created in directory '/data/mysql/backup/inc_1'
151029 15:11:38 [00] Writing backup-my.cnf
151029 15:11:38 [00] ...done
151029 15:11:38 [00] Writing xtrabackup_info
151029 15:11:38 [00] ...done
xtrabackup: Transaction log of lsn (13869220) to (13869220) was copied.
151029 15:11:38 completed OK!

.....
151029 15:11:38 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /data/mysql/backup/inc_1/performance_schema/events_statements_summary_by_account_by_event_name.frm
151029 15:11:38 [01]        ...done
151029 15:11:38 [01] Copying ./performance_schema/events_stages_history_long.frm to /data/mysql/backup/inc_1/performance_schema/events_stages_history_long.frm
151029 15:11:38 [01]        ...done
151029 15:11:38 Finished backing up non-InnoDB tables and files
151029 15:11:38 Executing LOCK BINLOG FOR BACKUP...
151029 15:11:38 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '13869220'
xtrabackup: Stopping log copying thread.
.151029 15:11:38 >> log scanned up to (13869220)
......
151029 15:11:38 Executing UNLOCK BINLOG
151029 15:11:38 Executing UNLOCK TABLES
151029 15:11:38 All tables unlocked
151029 15:11:38 Backup created in directory '/data/mysql/backup/inc_1'
151029 15:11:38 [00] Writing backup-my.cnf
151029 15:11:38 [00]        ...done
151029 15:11:38 [00] Writing xtrabackup_info
151029 15:11:38 [00]        ...done
xtrabackup: Transaction log of lsn (13869220) to (13869220) was copied.
151029 15:11:38 completed OK!

查看全备的信息：
[root@rh64 full]# cat xtrabackup_checkpoints
backup_type = full-backuped
from_lsn = 0
to_lsn = 13254537
last_lsn = 13254537
compact = 0
recover_binlog_info = 0

[root@rh64 full]# cat xtrabackup_info
uuid = 14899a5d-7d3e-11e5-acbc-0800273dfa7f
name =
tool_name = innobackupex
tool_command = --defaults-file=/etc/my.cnf --user=bakusr --password=... --socket=/var/lib/mysql/mysql.sock /data/mysql/backup/full --no-timestamp
tool_version = 2.3.2
ibbackup_version = 2.3.2
server_version = 5.6.25-73.1
start_time = 2015-10-28 14:35:09
end_time = 2015-10-28 14:35:29
lock_time = 0
binlog_pos = (null)
innodb_from_lsn = 0
innodb_to_lsn = 13254537
partial = N
incremental = N
format = file
compact = N
compressed = N
encrypted = N
查看增量的备份信息：
[root@rh64 inc_1]# cat xtrabackup_checkpoints
backup_type = incremental
from_lsn = 13254537
to_lsn = 13869220
last_lsn = 13869220
compact = 0
recover_binlog_info = 0
[root@rh64 inc_1]# cat xtrabackup_info
uuid = 4c3a7567-7e0c-11e5-ba68-0800273dfa7f
name =
tool_name = innobackupex
tool_command = --defaults-file=/tmp/my.cnf --user=bakusr --password=... --socket=/var/lib/mysql/mysql.sock --incremental-basedir=/data/mysql/backup/full --incremental /data/mysql/backup/inc_1 --no-timestamp --parallel=2
tool_version = 2.3.2
ibbackup_version = 2.3.2
server_version = 5.6.25-73.1
start_time = 2015-10-29 15:11:19
end_time = 2015-10-29 15:11:38
lock_time = 0
binlog_pos = (null)

第二次增量备份：
mysql> insert into t1 select * from t1 order by 1 limit 10000;
Query OK, 10000 rows affected (0.43 sec)
Records: 10000 Duplicates: 0 Warnings: 0
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql> select count(*) from t1;
+----------+
| count(*) |
+----------+
| 118304 |
+----------+
1 row in set (0.03 sec)

[root@rh64 full]# innobackupex --defaults-file=/tmp/my.cnf --user=bakusr --password='oracle' --socket=/var/lib/mysql/mysql.sock --incremental-basedir=/data/mysql/backup/inc_1 --incremental /data/mysql/backup/inc_2 --no-timestamp --parallel=2

[html] view plain copy print ?

151029 15:18:07 [01] Copying ./performance_schema/events_stages_history_long.frm to /data/mysql/backup/inc_2/performance_schema/events_stages_history_long.frm
151029 15:18:07 [01] ...done
151029 15:18:07 Finished backing up non-InnoDB tables and files
151029 15:18:07 Executing LOCK BINLOG FOR BACKUP...
151029 15:18:07 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '14484422'
xtrabackup: Stopping log copying thread.
.151029 15:18:07 >> log scanned up to (14484422)
......
151029 15:18:08 Executing UNLOCK BINLOG
151029 15:18:08 Executing UNLOCK TABLES
151029 15:18:08 All tables unlocked
151029 15:18:08 Backup created in directory '/data/mysql/backup/inc_2'
151029 15:18:08 [00] Writing backup-my.cnf
151029 15:18:08 [00] ...done
151029 15:18:08 [00] Writing xtrabackup_info
151029 15:18:08 [00] ...done
xtrabackup: Transaction log of lsn (14484422) to (14484422) was copied.
151029 15:18:08 completed OK!

151029 15:18:07 [01] Copying ./performance_schema/events_stages_history_long.frm to /data/mysql/backup/inc_2/performance_schema/events_stages_history_long.frm
151029 15:18:07 [01]        ...done
151029 15:18:07 Finished backing up non-InnoDB tables and files
151029 15:18:07 Executing LOCK BINLOG FOR BACKUP...
151029 15:18:07 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '14484422'
xtrabackup: Stopping log copying thread.
.151029 15:18:07 >> log scanned up to (14484422)
......
151029 15:18:08 Executing UNLOCK BINLOG
151029 15:18:08 Executing UNLOCK TABLES
151029 15:18:08 All tables unlocked
151029 15:18:08 Backup created in directory '/data/mysql/backup/inc_2'
151029 15:18:08 [00] Writing backup-my.cnf
151029 15:18:08 [00]        ...done
151029 15:18:08 [00] Writing xtrabackup_info
151029 15:18:08 [00]        ...done
xtrabackup: Transaction log of lsn (14484422) to (14484422) was copied.
151029 15:18:08 completed OK!

第二次增量备份信息：
[root@rh64 inc_2]# cat xtrabackup_checkpoints
backup_type = incremental
from_lsn = 13869220
to_lsn = 14484422
last_lsn = 14484422
compact = 0
recover_binlog_info = 0
[root@rh64 inc_2]# cat xtrabackup_info
uuid = 3456821a-7e0d-11e5-ba68-0800273dfa7f
name =
tool_name = innobackupex
tool_command = --defaults-file=/tmp/my.cnf --user=bakusr --password=... --socket=/var/lib/mysql/mysql.sock --incremental-basedir=/data/mysql/backup/inc_1 --incremental /data/mysql/backup/inc_2 --no-timestamp --parallel=2
tool_version = 2.3.2
ibbackup_version = 2.3.2
server_version = 5.6.25-73.1
start_time = 2015-10-29 15:17:48
end_time = 2015-10-29 15:18:08
lock_time = 0
binlog_pos = (null)
innodb_from_lsn = 13869220
innodb_to_lsn = 14484422
partial = N
incremental = Y
format = file
compact = N
compressed = N
encrypted = N
[root@rh64 inc_2]#
innodb_from_lsn = 13254537
innodb_to_lsn = 13869220
partial = N
incremental = Y
format = file
compact = N
compressed = N
encrypted = N

二、通过备份恢复数据

增量备份的恢复大体分为三个步骤：

1、恢复基础备份（全备）

2、恢复增量备份到基础备份（开始恢复的增量备份要添加--redo-only参数，到最后一次增量备份去掉--redo-only参数）

3、对整体基础备份进行恢复，回滚那些未提交的数据

1、测试环境

数据被误删除：
mysql> truncate table t1;
Query OK, 0 rows affected (0.60 sec)

mysql> select count(*) from t1;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)

2、数据恢复：

基础恢复prepare：
[root@rh64 inc_2]# innobackupex --apply-log --redo-only --use-memory=1g /data/mysql/backup/full

[html] view plain copy print ?

151029 15:27:00 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 /data/mysql/backup/full
xtrabackup: This target seems to be not prepared yet.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(13254537)
xtrabackup: using the following InnoDB configuration for recovery:
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 = 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:12M;ibdata2: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 1073741824 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: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 1.0G
InnoDB: Completed initialization of buffer pool
InnoDB: Highest supported file format is Barracuda.
InnoDB: The log sequence numbers 13254527 and 13254527 in ibdata files do not match the log sequence number 13254537 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 13254537
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 13254547
xtrabackup: using the following InnoDB configuration for recovery:
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
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: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 1.0G
InnoDB: Completed initialization of buffer pool
InnoDB: Setting log file ./ib_logfile101 size to 48 MB
InnoDB: Setting log file ./ib_logfile1 size to 48 MB
InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
InnoDB: New log files created, LSN=13254547
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 13254668
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 13254678
151029 15:27:07 completed OK!

151029 15:27:00 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 /data/mysql/backup/full
xtrabackup: This target seems to be not prepared yet.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(13254537)
xtrabackup: using the following InnoDB configuration for recovery:
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 = 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:12M;ibdata2: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 1073741824 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: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 1.0G
InnoDB: Completed initialization of buffer pool
InnoDB: Highest supported file format is Barracuda.
InnoDB: The log sequence numbers 13254527 and 13254527 in ibdata files do not match the log sequence number 13254537 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 13254537

xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 13254547
xtrabackup: using the following InnoDB configuration for recovery:
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
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: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 1.0G
InnoDB: Completed initialization of buffer pool
InnoDB: Setting log file ./ib_logfile101 size to 48 MB
InnoDB: Setting log file ./ib_logfile1 size to 48 MB
InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
InnoDB: New log files created, LSN=13254547
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 13254668
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 13254678
151029 15:27:07 completed OK!

将增量备份inc_1应用到基础备份full：（使用redo-only参数，只应用那些已经提交的事物，而不回滚那些未提交的事务）

[root@rh64 inc_2]# innobackupex --user='bakusr' --password='oracle' --apply-log --use-memory=1g /data/mysql/backup/full --redo-only --incremental-dir=/data/mysql/backup/inc_1

[html] view plain copy print ?

151029 15:37:54 [01] Copying ./performance_schema/events_statements_history_long.frm to /data/mysql/backup/full/2015-10-29_15-37-38/performance_schema/events_statements_history_long.frm
151029 15:37:54 [01] ...done
151029 15:37:54 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-37-38/performance_schema/events_statements_summary_by_account_by_event_name.frm
151029 15:37:54 [01] ...done
151029 15:37:54 [01] Copying ./performance_schema/events_stages_history_long.frm to /data/mysql/backup/full/2015-10-29_15-37-38/performance_schema/events_stages_history_long.frm
151029 15:37:54 [01] ...done
151029 15:37:55 Finished backing up non-InnoDB tables and files
151029 15:37:55 Executing LOCK BINLOG FOR BACKUP...
151029 15:37:55 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '14489531'
xtrabackup: Stopping log copying thread.
.151029 15:37:55 >> log scanned up to (14489531)
151029 15:37:55 Executing UNLOCK BINLOG
151029 15:37:55 Executing UNLOCK TABLES
151029 15:37:55 All tables unlocked
151029 15:37:55 Backup created in directory '/data/mysql/backup/full/2015-10-29_15-37-38'
151029 15:37:55 [00] Writing backup-my.cnf
151029 15:37:55 [00] ...done
151029 15:37:55 [00] Writing xtrabackup_info
151029 15:37:55 [00] ...done
xtrabackup: Transaction log of lsn (14489531) to (14489531) was copied.
151029 15:37:55 completed OK!

151029 15:37:54 [01] Copying ./performance_schema/events_statements_history_long.frm to /data/mysql/backup/full/2015-10-29_15-37-38/performance_schema/events_statements_history_long.frm
151029 15:37:54 [01]        ...done
151029 15:37:54 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-37-38/performance_schema/events_statements_summary_by_account_by_event_name.frm
151029 15:37:54 [01]        ...done
151029 15:37:54 [01] Copying ./performance_schema/events_stages_history_long.frm to /data/mysql/backup/full/2015-10-29_15-37-38/performance_schema/events_stages_history_long.frm
151029 15:37:54 [01]        ...done
151029 15:37:55 Finished backing up non-InnoDB tables and files
151029 15:37:55 Executing LOCK BINLOG FOR BACKUP...
151029 15:37:55 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '14489531'
xtrabackup: Stopping log copying thread.
.151029 15:37:55 >> log scanned up to (14489531)

151029 15:37:55 Executing UNLOCK BINLOG
151029 15:37:55 Executing UNLOCK TABLES
151029 15:37:55 All tables unlocked
151029 15:37:55 Backup created in directory '/data/mysql/backup/full/2015-10-29_15-37-38'
151029 15:37:55 [00] Writing backup-my.cnf
151029 15:37:55 [00]        ...done
151029 15:37:55 [00] Writing xtrabackup_info
151029 15:37:55 [00]        ...done
xtrabackup: Transaction log of lsn (14489531) to (14489531) was copied.
151029 15:37:55 completed OK!

将增量备份inc_2应用到全备full（不使用redo-only，回滚那些未提交的事务）：
[root@rh64 inc_2]# innobackupex --user='bakusr' --password='oracle' --apply-log --use-memory=1g /data/mysql/backup/full --incremental-dir=/data/mysql/backup/inc_2

[html] view plain copy print ?

51029 15:39:38 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!".
151029 15:39:38 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).
151029 15:39:38 version_check Connected to MySQL server
151029 15:39:38 version_check Executing a version check against the server...
151029 15:39:38 version_check Done.
151029 15:39:38 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
151029 15:39:38 >> log scanned up to (14489531)
xtrabackup: Generating a list of tablespaces
151029 15:39:38 [01] Copying ./ibdata1 to /data/mysql/backup/full/2015-10-29_15-39-38/ibdata1
151029 15:39:39 >> log scanned up to (14489531)
151029 15:39:39 [01] ...done
151029 15:39:39 [01] Copying ./ibdata2 to /data/mysql/backup/full/2015-10-29_15-39-38/ibdata2
151029 15:39:39 [01] ...done
151029 15:39:40 [01] Copying ./prod/t2.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/prod/t2.ibd
151029 15:39:40 [01] ...done
151029 15:39:40 >> log scanned up to (14489531)
151029 15:39:40 [01] Copying ./prod/t1.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/prod/t1.ibd
151029 15:39:40 [01] ...done
151029 15:39:40 [01] Copying ./prod/t3.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/prod/t3.ibd
151029 15:39:40 [01] ...done
151029 15:39:40 [01] Copying ./mysql/slave_worker_info.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slave_worker_info.ibd
151029 15:39:40 [01] ...done
151029 15:39:40 [01] Copying ./mysql/slave_master_info.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slave_master_info.ibd
151029 15:39:40 [01] ...done
151029 15:39:40 [01] Copying ./mysql/slave_relay_log_info.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slave_relay_log_info.ibd
151029 15:39:40 [01] ...done
151029 15:39:40 [01] Copying ./mysql/innodb_index_stats.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/innodb_index_stats.ibd
151029 15:39:40 [01] ...done
151029 15:39:41 [01] Copying ./mysql/innodb_table_stats.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/innodb_table_stats.ibd
151029 15:39:41 [01] ...done
151029 15:39:41 >> log scanned up to (14489531)
151029 15:39:41 Starting to backup non-InnoDB tables and files
151029 15:39:41 [01] Copying ./prod/t1.frm to /data/mysql/backup/full/2015-10-29_15-39-38/prod/t1.frm
151029 15:39:41 [01] ...done
151029 15:39:41 [01] Copying ./prod/t2.frm to /data/mysql/backup/full/2015-10-29_15-39-38/prod/t2.frm
151029 15:39:41 [01] ...done
151029 15:39:41 [01] Copying ./prod/t3.frm to /data/mysql/backup/full/2015-10-29_15-39-38/prod/t3.frm
151029 15:39:41 [01] ...done
151029 15:39:42 [01] Copying ./prod/db.opt to /data/mysql/backup/full/2015-10-29_15-39-38/prod/db.opt
151029 15:39:42 [01] ...done
151029 15:39:42 [01] Copying ./test/db.opt to /data/mysql/backup/full/2015-10-29_15-39-38/test/db.opt
151029 15:39:42 [01] ...done
151029 15:39:42 [01] Copying ./mysql/time_zone_name.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_name.MYD
151029 15:39:42 [01] ...done
151029 15:39:42 [01] Copying ./mysql/help_topic.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_topic.frm
151029 15:39:42 [01] ...done
151029 15:39:42 >> log scanned up to (14489531)
151029 15:39:42 [01] Copying ./mysql/event.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/event.frm
151029 15:39:42 [01] ...done
151029 15:39:42 [01] Copying ./mysql/time_zone.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone.MYD
151029 15:39:42 [01] ...done
151029 15:39:42 [01] Copying ./mysql/slow_log.CSV to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slow_log.CSV
151029 15:39:42 [01] ...done
151029 15:39:42 [01] Copying ./mysql/innodb_index_stats.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/innodb_index_stats.frm
151029 15:39:42 [01] ...done
151029 15:39:42 [01] Copying ./mysql/columns_priv.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/columns_priv.MYI
151029 15:39:42 [01] ...done
151029 15:39:42 [01] Copying ./mysql/plugin.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/plugin.MYI
151029 15:39:42 [01] ...done
151029 15:39:43 [01] Copying ./mysql/time_zone_leap_second.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_leap_second.frm
151029 15:39:43 [01] ...done
151029 15:39:43 [01] Copying ./mysql/time_zone_transition_type.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_transition_type.MYI
151029 15:39:43 [01] ...done
151029 15:39:43 [01] Copying ./mysql/proc.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/proc.frm
151029 15:39:43 >> log scanned up to (14489531)
151029 15:39:43 [01] ...done
151029 15:39:43 [01] Copying ./mysql/procs_priv.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/procs_priv.MYD
151029 15:39:43 [01] ...done
151029 15:39:43 [01] Copying ./mysql/proxies_priv.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/proxies_priv.MYI
151029 15:39:43 [01] ...done
151029 15:39:43 [01] Copying ./mysql/ndb_binlog_index.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/ndb_binlog_index.MYI
151029 15:39:43 [01] ...done
151029 15:39:43 [01] Copying ./mysql/servers.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/servers.MYI
151029 15:39:43 [01] ...done
151029 15:39:43 [01] Copying ./mysql/slow_log.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slow_log.frm
151029 15:39:43 [01] ...done
151029 15:39:44 [01] Copying ./mysql/help_relation.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_relation.MYD
151029 15:39:44 [01] ...done
151029 15:39:44 [01] Copying ./mysql/user.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/user.frm
151029 15:39:44 [01] ...done
151029 15:39:44 [01] Copying ./mysql/plugin.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/plugin.frm
151029 15:39:44 [01] ...done
151029 15:39:44 >> log scanned up to (14489531)
151029 15:39:44 [01] Copying ./mysql/time_zone_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_name.frm
151029 15:39:44 [01] ...done
151029 15:39:44 [01] Copying ./mysql/user.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/user.MYI
151029 15:39:44 [01] ...done
151029 15:39:44 [01] Copying ./mysql/help_relation.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_relation.frm
151029 15:39:44 [01] ...done
151029 15:39:44 [01] Copying ./mysql/slow_log.CSM to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slow_log.CSM
151029 15:39:44 [01] ...done
151029 15:39:44 [01] Copying ./mysql/time_zone_transition.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_transition.MYD
151029 15:39:44 [01] ...done
151029 15:39:44 [01] Copying ./mysql/help_category.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_category.MYI
151029 15:39:44 [01] ...done
151029 15:39:45 [01] Copying ./mysql/proc.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/proc.MYD
151029 15:39:45 [01] ...done
151029 15:39:45 [01] Copying ./mysql/db.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/db.MYD
151029 15:39:45 [01] ...done
151029 15:39:45 [01] Copying ./mysql/tables_priv.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/tables_priv.MYD
151029 15:39:45 [01] ...done
151029 15:39:45 >> log scanned up to (14489531)
151029 15:39:45 [01] Copying ./mysql/time_zone_leap_second.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_leap_second.MYI
151029 15:39:45 [01] ...done
151029 15:39:45 [01] Copying ./mysql/help_relation.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_relation.MYI
151029 15:39:46 [01] ...done
151029 15:39:46 [01] Copying ./mysql/ndb_binlog_index.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/ndb_binlog_index.MYD
151029 15:39:46 [01] ...done
151029 15:39:46 [01] Copying ./mysql/slave_worker_info.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slave_worker_info.frm
151029 15:39:46 [01] ...done
151029 15:39:46 >> log scanned up to (14489531)
151029 15:39:46 [01] Copying ./mysql/time_zone.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone.frm
151029 15:39:46 [01] ...done
151029 15:39:46 [01] Copying ./mysql/slave_relay_log_info.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slave_relay_log_info.frm
151029 15:39:46 [01] ...done
151029 15:39:46 [01] Copying ./mysql/columns_priv.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/columns_priv.MYD
151029 15:39:46 [01] ...done
151029 15:39:47 [01] Copying ./mysql/time_zone_transition_type.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_transition_type.MYD
151029 15:39:47 [01] ...done
151029 15:39:47 [01] Copying ./mysql/user.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/user.MYD
151029 15:39:47 [01] ...done
151029 15:39:47 [01] Copying ./mysql/tables_priv.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/tables_priv.frm
151029 15:39:47 [01] ...done
151029 15:39:47 >> log scanned up to (14489531)
151029 15:39:47 [01] Copying ./mysql/help_category.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_category.MYD
151029 15:39:47 [01] ...done
151029 15:39:47 [01] Copying ./mysql/help_keyword.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_keyword.MYD
151029 15:39:47 [01] ...done
151029 15:39:47 [01] Copying ./mysql/time_zone_transition.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_transition.frm
151029 15:39:47 [01] ...done
151029 15:39:47 [01] Copying ./mysql/servers.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/servers.frm
151029 15:39:47 [01] ...done
151029 15:39:47 [01] Copying ./mysql/general_log.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/general_log.frm
151029 15:39:47 [01] ...done
151029 15:39:48 [01] Copying ./mysql/help_keyword.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_keyword.frm
151029 15:39:48 [01] ...done
151029 15:39:48 [01] Copying ./mysql/time_zone_transition_type.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_transition_type.frm
151029 15:39:48 [01] ...done
151029 15:39:48 [01] Copying ./mysql/columns_priv.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/columns_priv.frm
151029 15:39:48 [01] ...done
151029 15:39:48 >> log scanned up to (14489531)
151029 15:39:48 [01] Copying ./mysql/proxies_priv.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/proxies_priv.frm
151029 15:39:48 [01] ...done
151029 15:39:48 [01] Copying ./mysql/help_keyword.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_keyword.MYI
151029 15:39:48 [01] ...done
151029 15:39:48 [01] Copying ./mysql/general_log.CSV to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/general_log.CSV
151029 15:39:48 [01] ...done
151029 15:39:48 [01] Copying ./mysql/event.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/event.MYD
151029 15:39:48 [01] ...done
151029 15:39:48 [01] Copying ./mysql/plugin.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/plugin.MYD
151029 15:39:48 [01] ...done
151029 15:39:48 [01] Copying ./mysql/proxies_priv.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/proxies_priv.MYD
151029 15:39:48 [01] ...done
151029 15:39:49 [01] Copying ./mysql/servers.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/servers.MYD
151029 15:39:49 [01] ...done
151029 15:39:49 [01] Copying ./mysql/event.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/event.MYI
151029 15:39:49 [01] ...done
151029 15:39:49 [01] Copying ./mysql/time_zone_transition.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_transition.MYI
151029 15:39:49 [01] ...done
151029 15:39:49 >> log scanned up to (14489531)
151029 15:39:49 [01] Copying ./mysql/tables_priv.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/tables_priv.MYI
151029 15:39:49 [01] ...done
151029 15:39:49 [01] Copying ./mysql/ndb_binlog_index.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/ndb_binlog_index.frm
151029 15:39:49 [01] ...done
151029 15:39:49 [01] Copying ./mysql/db.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/db.MYI
151029 15:39:49 [01] ...done
151029 15:39:49 [01] Copying ./mysql/time_zone_name.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_name.MYI
151029 15:39:49 [01] ...done
151029 15:39:49 [01] Copying ./mysql/time_zone_leap_second.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_leap_second.MYD
151029 15:39:49 [01] ...done
151029 15:39:49 [01] Copying ./mysql/help_topic.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_topic.MYD
151029 15:39:49 [01] ...done
151029 15:39:50 [01] Copying ./mysql/help_topic.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_topic.MYI
151029 15:39:50 [01] ...done
151029 15:39:50 [01] Copying ./mysql/db.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/db.frm
151029 15:39:50 [01] ...done
151029 15:39:50 >> log scanned up to (14489531)
151029 15:39:50 [01] Copying ./mysql/func.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/func.MYI
151029 15:39:50 [01] ...done
151029 15:39:50 [01] Copying ./mysql/procs_priv.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/procs_priv.MYI
151029 15:39:50 [01] ...done
151029 15:39:50 [01] Copying ./mysql/help_category.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_category.frm
151029 15:39:50 [01] ...done
151029 15:39:50 [01] Copying ./mysql/procs_priv.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/procs_priv.frm
151029 15:39:50 [01] ...done
151029 15:39:50 [01] Copying ./mysql/func.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/func.MYD
151029 15:39:50 [01] ...done
151029 15:39:50 [01] Copying ./mysql/func.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/func.frm
151029 15:39:50 [01] ...done
151029 15:39:51 [01] Copying ./mysql/proc.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/proc.MYI
151029 15:39:51 [01] ...done
151029 15:39:51 [01] Copying ./mysql/general_log.CSM to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/general_log.CSM
151029 15:39:51 [01] ...done
151029 15:39:51 [01] Copying ./mysql/time_zone.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone.MYI
151029 15:39:51 >> log scanned up to (14489531)
151029 15:39:51 [01] ...done
151029 15:39:51 [01] Copying ./mysql/slave_master_info.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slave_master_info.frm
151029 15:39:51 [01] ...done
151029 15:39:51 [01] Copying ./mysql/innodb_table_stats.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/innodb_table_stats.frm
151029 15:39:51 [01] ...done
151029 15:39:51 [01] Copying ./performance_schema/users.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/users.frm
151029 15:39:51 [01] ...done
151029 15:39:51 [01] Copying ./performance_schema/events_waits_history_long.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_history_long.frm
151029 15:39:51 [01] ...done
151029 15:39:51 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_summary_by_host_by_event_name.frm
151029 15:39:51 [01] ...done
151029 15:39:51 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/table_io_waits_summary_by_index_usage.frm
151029 15:39:51 [01] ...done
151029 15:39:52 [01] Copying ./performance_schema/events_waits_history.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_history.frm
151029 15:39:52 [01] ...done
151029 15:39:52 [01] Copying ./performance_schema/host_cache.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/host_cache.frm
151029 15:39:52 [01] ...done
151029 15:39:52 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_summary_by_thread_by_event_name.frm
151029 15:39:52 [01] ...done
151029 15:39:52 >> log scanned up to (14489531)
151029 15:39:52 [01] Copying ./performance_schema/session_connect_attrs.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/session_connect_attrs.frm
151029 15:39:52 [01] ...done
151029 15:39:52 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/objects_summary_global_by_type.frm
151029 15:39:52 [01] ...done
151029 15:39:52 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/session_account_connect_attrs.frm
151029 15:39:52 [01] ...done
151029 15:39:52 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/socket_summary_by_event_name.frm
151029 15:39:52 [01] ...done
151029 15:39:52 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_summary_global_by_event_name.frm
151029 15:39:52 [01] ...done
151029 15:39:53 [01] Copying ./performance_schema/rwlock_instances.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/rwlock_instances.frm
151029 15:39:53 [01] ...done
151029 15:39:53 [01] Copying ./performance_schema/events_stages_current.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_current.frm
151029 15:39:53 [01] ...done
151029 15:39:53 [01] Copying ./performance_schema/file_summary_by_instance.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/file_summary_by_instance.frm
151029 15:39:53 [01] ...done
151029 15:39:53 >> log scanned up to (14489531)
151029 15:39:53 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_summary_by_host_by_event_name.frm
151029 15:39:53 [01] ...done
151029 15:39:53 [01] Copying ./performance_schema/performance_timers.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/performance_timers.frm
151029 15:39:53 [01] ...done
151029 15:39:53 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_summary_by_thread_by_event_name.frm
151029 15:39:53 [01] ...done
151029 15:39:53 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_summary_by_user_by_event_name.frm
151029 15:39:53 [01] ...done
151029 15:39:53 [01] Copying ./performance_schema/cond_instances.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/cond_instances.frm
151029 15:39:53 [01] ...done
151029 15:39:53 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_summary_global_by_event_name.frm
151029 15:39:53 [01] ...done
151029 15:39:54 [01] Copying ./performance_schema/setup_timers.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/setup_timers.frm
151029 15:39:54 [01] ...done
151029 15:39:54 [01] Copying ./performance_schema/hosts.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/hosts.frm
151029 15:39:54 [01] ...done
151029 15:39:54 >> log scanned up to (14489531)
151029 15:39:54 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/socket_summary_by_instance.frm
151029 15:39:54 [01] ...done
151029 15:39:54 [01] Copying ./performance_schema/file_instances.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/file_instances.frm
151029 15:39:54 [01] ...done
151029 15:39:54 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/table_lock_waits_summary_by_table.frm
151029 15:39:54 [01] ...done
151029 15:39:54 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_summary_by_user_by_event_name.frm
151029 15:39:54 [01] ...done
151029 15:39:54 [01] Copying ./performance_schema/events_waits_current.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_current.frm
151029 15:39:55 [01] ...done
151029 15:39:55 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_summary_by_digest.frm
151029 15:39:55 [01] ...done
151029 15:39:55 [01] Copying ./performance_schema/events_stages_history.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_history.frm
151029 15:39:55 [01] ...done
151029 15:39:55 >> log scanned up to (14489531)
151029 15:39:55 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/file_summary_by_event_name.frm
151029 15:39:55 [01] ...done
151029 15:39:55 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/table_io_waits_summary_by_table.frm
151029 15:39:55 [01] ...done
151029 15:39:55 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_summary_by_thread_by_event_name.frm
151029 15:39:55 [01] ...done
151029 15:39:55 [01] Copying ./performance_schema/threads.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/threads.frm
151029 15:39:55 [01] ...done
151029 15:39:55 [01] Copying ./performance_schema/accounts.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/accounts.frm
151029 15:39:55 [01] ...done
151029 15:39:56 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_summary_global_by_event_name.frm
151029 15:39:56 [01] ...done
151029 15:39:56 [01] Copying ./performance_schema/setup_objects.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/setup_objects.frm
151029 15:39:56 [01] ...done
151029 15:39:56 [01] Copying ./performance_schema/events_statements_current.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_current.frm
151029 15:39:56 [01] ...done
151029 15:39:56 >> log scanned up to (14489531)
151029 15:39:56 [01] Copying ./performance_schema/socket_instances.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/socket_instances.frm
151029 15:39:56 [01] ...done
151029 15:39:56 [01] Copying ./performance_schema/setup_actors.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/setup_actors.frm
151029 15:39:56 [01] ...done
151029 15:39:56 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_summary_by_account_by_event_name.frm
151029 15:39:56 [01] ...done
151029 15:39:56 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_summary_by_host_by_event_name.frm
151029 15:39:56 [01] ...done
151029 15:39:56 [01] Copying ./performance_schema/db.opt to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/db.opt
151029 15:39:56 [01] ...done
151029 15:39:57 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_summary_by_user_by_event_name.frm
151029 15:39:57 [01] ...done
151029 15:39:57 [01] Copying ./performance_schema/events_statements_history.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_history.frm
151029 15:39:57 [01] ...done
151029 15:39:57 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_summary_by_account_by_event_name.frm
151029 15:39:57 [01] ...done
151029 15:39:57 >> log scanned up to (14489531)
151029 15:39:57 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_summary_by_instance.frm
151029 15:39:57 [01] ...done
151029 15:39:57 [01] Copying ./performance_schema/setup_consumers.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/setup_consumers.frm
151029 15:39:57 [01] ...done
151029 15:39:57 [01] Copying ./performance_schema/setup_instruments.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/setup_instruments.frm
151029 15:39:57 [01] ...done
151029 15:39:57 [01] Copying ./performance_schema/mutex_instances.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/mutex_instances.frm
151029 15:39:57 [01] ...done
151029 15:39:57 [01] Copying ./performance_schema/events_statements_history_long.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_history_long.frm
151029 15:39:57 [01] ...done
151029 15:39:57 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_summary_by_account_by_event_name.frm
151029 15:39:58 [01] ...done
151029 15:39:58 [01] Copying ./performance_schema/events_stages_history_long.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_history_long.frm
151029 15:39:58 [01] ...done
151029 15:39:58 Finished backing up non-InnoDB tables and files
151029 15:39:58 Executing LOCK BINLOG FOR BACKUP...
151029 15:39:58 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '14489531'
xtrabackup: Stopping log copying thread.
.151029 15:39:58 >> log scanned up to (14489531)
151029 15:39:58 Executing UNLOCK BINLOG
151029 15:39:58 Executing UNLOCK TABLES
151029 15:39:58 All tables unlocked
151029 15:39:58 Backup created in directory '/data/mysql/backup/full/2015-10-29_15-39-38'
151029 15:39:58 [00] Writing backup-my.cnf
151029 15:39:58 [00] ...done
151029 15:39:58 [00] Writing xtrabackup_info
151029 15:39:58 [00] ...done
xtrabackup: Transaction log of lsn (14489531) to (14489531) was copied.
151029 15:39:58 completed OK!

51029 15:39:38 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!".
151029 15:39:38  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).
151029 15:39:38  version_check Connected to MySQL server
151029 15:39:38  version_check Executing a version check against the server...
151029 15:39:38  version_check Done.
151029 15:39:38 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
151029 15:39:38 >> log scanned up to (14489531)
xtrabackup: Generating a list of tablespaces
151029 15:39:38 [01] Copying ./ibdata1 to /data/mysql/backup/full/2015-10-29_15-39-38/ibdata1
151029 15:39:39 >> log scanned up to (14489531)
151029 15:39:39 [01]        ...done
151029 15:39:39 [01] Copying ./ibdata2 to /data/mysql/backup/full/2015-10-29_15-39-38/ibdata2
151029 15:39:39 [01]        ...done
151029 15:39:40 [01] Copying ./prod/t2.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/prod/t2.ibd
151029 15:39:40 [01]        ...done
151029 15:39:40 >> log scanned up to (14489531)
151029 15:39:40 [01] Copying ./prod/t1.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/prod/t1.ibd
151029 15:39:40 [01]        ...done
151029 15:39:40 [01] Copying ./prod/t3.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/prod/t3.ibd
151029 15:39:40 [01]        ...done
151029 15:39:40 [01] Copying ./mysql/slave_worker_info.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slave_worker_info.ibd
151029 15:39:40 [01]        ...done
151029 15:39:40 [01] Copying ./mysql/slave_master_info.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slave_master_info.ibd
151029 15:39:40 [01]        ...done
151029 15:39:40 [01] Copying ./mysql/slave_relay_log_info.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slave_relay_log_info.ibd
151029 15:39:40 [01]        ...done
151029 15:39:40 [01] Copying ./mysql/innodb_index_stats.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/innodb_index_stats.ibd
151029 15:39:40 [01]        ...done
151029 15:39:41 [01] Copying ./mysql/innodb_table_stats.ibd to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/innodb_table_stats.ibd
151029 15:39:41 [01]        ...done
151029 15:39:41 >> log scanned up to (14489531)
151029 15:39:41 Starting to backup non-InnoDB tables and files
151029 15:39:41 [01] Copying ./prod/t1.frm to /data/mysql/backup/full/2015-10-29_15-39-38/prod/t1.frm
151029 15:39:41 [01]        ...done
151029 15:39:41 [01] Copying ./prod/t2.frm to /data/mysql/backup/full/2015-10-29_15-39-38/prod/t2.frm
151029 15:39:41 [01]        ...done
151029 15:39:41 [01] Copying ./prod/t3.frm to /data/mysql/backup/full/2015-10-29_15-39-38/prod/t3.frm
151029 15:39:41 [01]        ...done
151029 15:39:42 [01] Copying ./prod/db.opt to /data/mysql/backup/full/2015-10-29_15-39-38/prod/db.opt
151029 15:39:42 [01]        ...done
151029 15:39:42 [01] Copying ./test/db.opt to /data/mysql/backup/full/2015-10-29_15-39-38/test/db.opt
151029 15:39:42 [01]        ...done
151029 15:39:42 [01] Copying ./mysql/time_zone_name.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_name.MYD
151029 15:39:42 [01]        ...done
151029 15:39:42 [01] Copying ./mysql/help_topic.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_topic.frm
151029 15:39:42 [01]        ...done
151029 15:39:42 >> log scanned up to (14489531)
151029 15:39:42 [01] Copying ./mysql/event.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/event.frm
151029 15:39:42 [01]        ...done
151029 15:39:42 [01] Copying ./mysql/time_zone.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone.MYD
151029 15:39:42 [01]        ...done
151029 15:39:42 [01] Copying ./mysql/slow_log.CSV to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slow_log.CSV
151029 15:39:42 [01]        ...done
151029 15:39:42 [01] Copying ./mysql/innodb_index_stats.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/innodb_index_stats.frm
151029 15:39:42 [01]        ...done
151029 15:39:42 [01] Copying ./mysql/columns_priv.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/columns_priv.MYI
151029 15:39:42 [01]        ...done
151029 15:39:42 [01] Copying ./mysql/plugin.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/plugin.MYI
151029 15:39:42 [01]        ...done
151029 15:39:43 [01] Copying ./mysql/time_zone_leap_second.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_leap_second.frm
151029 15:39:43 [01]        ...done
151029 15:39:43 [01] Copying ./mysql/time_zone_transition_type.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_transition_type.MYI
151029 15:39:43 [01]        ...done
151029 15:39:43 [01] Copying ./mysql/proc.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/proc.frm
151029 15:39:43 >> log scanned up to (14489531)
151029 15:39:43 [01]        ...done
151029 15:39:43 [01] Copying ./mysql/procs_priv.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/procs_priv.MYD
151029 15:39:43 [01]        ...done
151029 15:39:43 [01] Copying ./mysql/proxies_priv.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/proxies_priv.MYI
151029 15:39:43 [01]        ...done
151029 15:39:43 [01] Copying ./mysql/ndb_binlog_index.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/ndb_binlog_index.MYI
151029 15:39:43 [01]        ...done
151029 15:39:43 [01] Copying ./mysql/servers.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/servers.MYI
151029 15:39:43 [01]        ...done
151029 15:39:43 [01] Copying ./mysql/slow_log.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slow_log.frm
151029 15:39:43 [01]        ...done
151029 15:39:44 [01] Copying ./mysql/help_relation.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_relation.MYD
151029 15:39:44 [01]        ...done
151029 15:39:44 [01] Copying ./mysql/user.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/user.frm
151029 15:39:44 [01]        ...done
151029 15:39:44 [01] Copying ./mysql/plugin.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/plugin.frm
151029 15:39:44 [01]        ...done
151029 15:39:44 >> log scanned up to (14489531)
151029 15:39:44 [01] Copying ./mysql/time_zone_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_name.frm
151029 15:39:44 [01]        ...done
151029 15:39:44 [01] Copying ./mysql/user.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/user.MYI
151029 15:39:44 [01]        ...done
151029 15:39:44 [01] Copying ./mysql/help_relation.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_relation.frm
151029 15:39:44 [01]        ...done
151029 15:39:44 [01] Copying ./mysql/slow_log.CSM to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slow_log.CSM
151029 15:39:44 [01]        ...done
151029 15:39:44 [01] Copying ./mysql/time_zone_transition.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_transition.MYD
151029 15:39:44 [01]        ...done
151029 15:39:44 [01] Copying ./mysql/help_category.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_category.MYI
151029 15:39:44 [01]        ...done
151029 15:39:45 [01] Copying ./mysql/proc.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/proc.MYD
151029 15:39:45 [01]        ...done
151029 15:39:45 [01] Copying ./mysql/db.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/db.MYD
151029 15:39:45 [01]        ...done
151029 15:39:45 [01] Copying ./mysql/tables_priv.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/tables_priv.MYD
151029 15:39:45 [01]        ...done
151029 15:39:45 >> log scanned up to (14489531)
151029 15:39:45 [01] Copying ./mysql/time_zone_leap_second.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_leap_second.MYI
151029 15:39:45 [01]        ...done
151029 15:39:45 [01] Copying ./mysql/help_relation.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_relation.MYI
151029 15:39:46 [01]        ...done
151029 15:39:46 [01] Copying ./mysql/ndb_binlog_index.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/ndb_binlog_index.MYD
151029 15:39:46 [01]        ...done
151029 15:39:46 [01] Copying ./mysql/slave_worker_info.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slave_worker_info.frm
151029 15:39:46 [01]        ...done
151029 15:39:46 >> log scanned up to (14489531)
151029 15:39:46 [01] Copying ./mysql/time_zone.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone.frm
151029 15:39:46 [01]        ...done
151029 15:39:46 [01] Copying ./mysql/slave_relay_log_info.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slave_relay_log_info.frm
151029 15:39:46 [01]        ...done
151029 15:39:46 [01] Copying ./mysql/columns_priv.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/columns_priv.MYD
151029 15:39:46 [01]        ...done
151029 15:39:47 [01] Copying ./mysql/time_zone_transition_type.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_transition_type.MYD
151029 15:39:47 [01]        ...done
151029 15:39:47 [01] Copying ./mysql/user.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/user.MYD
151029 15:39:47 [01]        ...done
151029 15:39:47 [01] Copying ./mysql/tables_priv.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/tables_priv.frm
151029 15:39:47 [01]        ...done
151029 15:39:47 >> log scanned up to (14489531)
151029 15:39:47 [01] Copying ./mysql/help_category.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_category.MYD
151029 15:39:47 [01]        ...done
151029 15:39:47 [01] Copying ./mysql/help_keyword.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_keyword.MYD
151029 15:39:47 [01]        ...done
151029 15:39:47 [01] Copying ./mysql/time_zone_transition.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_transition.frm
151029 15:39:47 [01]        ...done
151029 15:39:47 [01] Copying ./mysql/servers.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/servers.frm
151029 15:39:47 [01]        ...done
151029 15:39:47 [01] Copying ./mysql/general_log.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/general_log.frm
151029 15:39:47 [01]        ...done
151029 15:39:48 [01] Copying ./mysql/help_keyword.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_keyword.frm
151029 15:39:48 [01]        ...done
151029 15:39:48 [01] Copying ./mysql/time_zone_transition_type.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_transition_type.frm
151029 15:39:48 [01]        ...done
151029 15:39:48 [01] Copying ./mysql/columns_priv.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/columns_priv.frm
151029 15:39:48 [01]        ...done
151029 15:39:48 >> log scanned up to (14489531)
151029 15:39:48 [01] Copying ./mysql/proxies_priv.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/proxies_priv.frm
151029 15:39:48 [01]        ...done
151029 15:39:48 [01] Copying ./mysql/help_keyword.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_keyword.MYI
151029 15:39:48 [01]        ...done
151029 15:39:48 [01] Copying ./mysql/general_log.CSV to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/general_log.CSV
151029 15:39:48 [01]        ...done
151029 15:39:48 [01] Copying ./mysql/event.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/event.MYD
151029 15:39:48 [01]        ...done
151029 15:39:48 [01] Copying ./mysql/plugin.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/plugin.MYD
151029 15:39:48 [01]        ...done
151029 15:39:48 [01] Copying ./mysql/proxies_priv.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/proxies_priv.MYD
151029 15:39:48 [01]        ...done
151029 15:39:49 [01] Copying ./mysql/servers.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/servers.MYD
151029 15:39:49 [01]        ...done
151029 15:39:49 [01] Copying ./mysql/event.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/event.MYI
151029 15:39:49 [01]        ...done
151029 15:39:49 [01] Copying ./mysql/time_zone_transition.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_transition.MYI
151029 15:39:49 [01]        ...done
151029 15:39:49 >> log scanned up to (14489531)
151029 15:39:49 [01] Copying ./mysql/tables_priv.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/tables_priv.MYI
151029 15:39:49 [01]        ...done
151029 15:39:49 [01] Copying ./mysql/ndb_binlog_index.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/ndb_binlog_index.frm
151029 15:39:49 [01]        ...done
151029 15:39:49 [01] Copying ./mysql/db.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/db.MYI
151029 15:39:49 [01]        ...done
151029 15:39:49 [01] Copying ./mysql/time_zone_name.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_name.MYI
151029 15:39:49 [01]        ...done
151029 15:39:49 [01] Copying ./mysql/time_zone_leap_second.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone_leap_second.MYD
151029 15:39:49 [01]        ...done
151029 15:39:49 [01] Copying ./mysql/help_topic.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_topic.MYD
151029 15:39:49 [01]        ...done
151029 15:39:50 [01] Copying ./mysql/help_topic.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_topic.MYI
151029 15:39:50 [01]        ...done
151029 15:39:50 [01] Copying ./mysql/db.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/db.frm
151029 15:39:50 [01]        ...done
151029 15:39:50 >> log scanned up to (14489531)
151029 15:39:50 [01] Copying ./mysql/func.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/func.MYI
151029 15:39:50 [01]        ...done
151029 15:39:50 [01] Copying ./mysql/procs_priv.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/procs_priv.MYI
151029 15:39:50 [01]        ...done
151029 15:39:50 [01] Copying ./mysql/help_category.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/help_category.frm
151029 15:39:50 [01]        ...done
151029 15:39:50 [01] Copying ./mysql/procs_priv.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/procs_priv.frm
151029 15:39:50 [01]        ...done
151029 15:39:50 [01] Copying ./mysql/func.MYD to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/func.MYD
151029 15:39:50 [01]        ...done
151029 15:39:50 [01] Copying ./mysql/func.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/func.frm
151029 15:39:50 [01]        ...done
151029 15:39:51 [01] Copying ./mysql/proc.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/proc.MYI
151029 15:39:51 [01]        ...done
151029 15:39:51 [01] Copying ./mysql/general_log.CSM to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/general_log.CSM
151029 15:39:51 [01]        ...done
151029 15:39:51 [01] Copying ./mysql/time_zone.MYI to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/time_zone.MYI
151029 15:39:51 >> log scanned up to (14489531)
151029 15:39:51 [01]        ...done
151029 15:39:51 [01] Copying ./mysql/slave_master_info.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/slave_master_info.frm
151029 15:39:51 [01]        ...done
151029 15:39:51 [01] Copying ./mysql/innodb_table_stats.frm to /data/mysql/backup/full/2015-10-29_15-39-38/mysql/innodb_table_stats.frm
151029 15:39:51 [01]        ...done
151029 15:39:51 [01] Copying ./performance_schema/users.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/users.frm
151029 15:39:51 [01]        ...done
151029 15:39:51 [01] Copying ./performance_schema/events_waits_history_long.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_history_long.frm
151029 15:39:51 [01]        ...done
151029 15:39:51 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_summary_by_host_by_event_name.frm
151029 15:39:51 [01]        ...done
151029 15:39:51 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/table_io_waits_summary_by_index_usage.frm
151029 15:39:51 [01]        ...done
151029 15:39:52 [01] Copying ./performance_schema/events_waits_history.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_history.frm
151029 15:39:52 [01]        ...done
151029 15:39:52 [01] Copying ./performance_schema/host_cache.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/host_cache.frm
151029 15:39:52 [01]        ...done
151029 15:39:52 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_summary_by_thread_by_event_name.frm
151029 15:39:52 [01]        ...done
151029 15:39:52 >> log scanned up to (14489531)
151029 15:39:52 [01] Copying ./performance_schema/session_connect_attrs.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/session_connect_attrs.frm
151029 15:39:52 [01]        ...done
151029 15:39:52 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/objects_summary_global_by_type.frm
151029 15:39:52 [01]        ...done
151029 15:39:52 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/session_account_connect_attrs.frm
151029 15:39:52 [01]        ...done
151029 15:39:52 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/socket_summary_by_event_name.frm
151029 15:39:52 [01]        ...done
151029 15:39:52 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_summary_global_by_event_name.frm
151029 15:39:52 [01]        ...done
151029 15:39:53 [01] Copying ./performance_schema/rwlock_instances.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/rwlock_instances.frm
151029 15:39:53 [01]        ...done
151029 15:39:53 [01] Copying ./performance_schema/events_stages_current.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_current.frm
151029 15:39:53 [01]        ...done
151029 15:39:53 [01] Copying ./performance_schema/file_summary_by_instance.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/file_summary_by_instance.frm
151029 15:39:53 [01]        ...done
151029 15:39:53 >> log scanned up to (14489531)
151029 15:39:53 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_summary_by_host_by_event_name.frm
151029 15:39:53 [01]        ...done
151029 15:39:53 [01] Copying ./performance_schema/performance_timers.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/performance_timers.frm
151029 15:39:53 [01]        ...done
151029 15:39:53 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_summary_by_thread_by_event_name.frm
151029 15:39:53 [01]        ...done
151029 15:39:53 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_summary_by_user_by_event_name.frm
151029 15:39:53 [01]        ...done
151029 15:39:53 [01] Copying ./performance_schema/cond_instances.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/cond_instances.frm
151029 15:39:53 [01]        ...done
151029 15:39:53 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_summary_global_by_event_name.frm
151029 15:39:53 [01]        ...done
151029 15:39:54 [01] Copying ./performance_schema/setup_timers.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/setup_timers.frm
151029 15:39:54 [01]        ...done
151029 15:39:54 [01] Copying ./performance_schema/hosts.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/hosts.frm
151029 15:39:54 [01]        ...done
151029 15:39:54 >> log scanned up to (14489531)
151029 15:39:54 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/socket_summary_by_instance.frm
151029 15:39:54 [01]        ...done
151029 15:39:54 [01] Copying ./performance_schema/file_instances.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/file_instances.frm
151029 15:39:54 [01]        ...done
151029 15:39:54 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/table_lock_waits_summary_by_table.frm
151029 15:39:54 [01]        ...done
151029 15:39:54 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_summary_by_user_by_event_name.frm
151029 15:39:54 [01]        ...done
151029 15:39:54 [01] Copying ./performance_schema/events_waits_current.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_current.frm
151029 15:39:55 [01]        ...done
151029 15:39:55 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_summary_by_digest.frm
151029 15:39:55 [01]        ...done
151029 15:39:55 [01] Copying ./performance_schema/events_stages_history.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_history.frm
151029 15:39:55 [01]        ...done
151029 15:39:55 >> log scanned up to (14489531)
151029 15:39:55 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/file_summary_by_event_name.frm
151029 15:39:55 [01]        ...done
151029 15:39:55 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/table_io_waits_summary_by_table.frm
151029 15:39:55 [01]        ...done
151029 15:39:55 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_summary_by_thread_by_event_name.frm
151029 15:39:55 [01]        ...done
151029 15:39:55 [01] Copying ./performance_schema/threads.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/threads.frm
151029 15:39:55 [01]        ...done
151029 15:39:55 [01] Copying ./performance_schema/accounts.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/accounts.frm
151029 15:39:55 [01]        ...done
151029 15:39:56 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_summary_global_by_event_name.frm
151029 15:39:56 [01]        ...done
151029 15:39:56 [01] Copying ./performance_schema/setup_objects.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/setup_objects.frm
151029 15:39:56 [01]        ...done
151029 15:39:56 [01] Copying ./performance_schema/events_statements_current.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_current.frm
151029 15:39:56 [01]        ...done
151029 15:39:56 >> log scanned up to (14489531)
151029 15:39:56 [01] Copying ./performance_schema/socket_instances.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/socket_instances.frm
151029 15:39:56 [01]        ...done
151029 15:39:56 [01] Copying ./performance_schema/setup_actors.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/setup_actors.frm
151029 15:39:56 [01]        ...done
151029 15:39:56 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_summary_by_account_by_event_name.frm
151029 15:39:56 [01]        ...done
151029 15:39:56 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_summary_by_host_by_event_name.frm
151029 15:39:56 [01]        ...done
151029 15:39:56 [01] Copying ./performance_schema/db.opt to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/db.opt
151029 15:39:56 [01]        ...done
151029 15:39:57 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_summary_by_user_by_event_name.frm
151029 15:39:57 [01]        ...done
151029 15:39:57 [01] Copying ./performance_schema/events_statements_history.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_history.frm
151029 15:39:57 [01]        ...done
151029 15:39:57 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_summary_by_account_by_event_name.frm
151029 15:39:57 [01]        ...done
151029 15:39:57 >> log scanned up to (14489531)
151029 15:39:57 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_waits_summary_by_instance.frm
151029 15:39:57 [01]        ...done
151029 15:39:57 [01] Copying ./performance_schema/setup_consumers.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/setup_consumers.frm
151029 15:39:57 [01]        ...done
151029 15:39:57 [01] Copying ./performance_schema/setup_instruments.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/setup_instruments.frm
151029 15:39:57 [01]        ...done
151029 15:39:57 [01] Copying ./performance_schema/mutex_instances.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/mutex_instances.frm
151029 15:39:57 [01]        ...done
151029 15:39:57 [01] Copying ./performance_schema/events_statements_history_long.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_history_long.frm
151029 15:39:57 [01]        ...done
151029 15:39:57 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_statements_summary_by_account_by_event_name.frm
151029 15:39:58 [01]        ...done
151029 15:39:58 [01] Copying ./performance_schema/events_stages_history_long.frm to /data/mysql/backup/full/2015-10-29_15-39-38/performance_schema/events_stages_history_long.frm
151029 15:39:58 [01]        ...done
151029 15:39:58 Finished backing up non-InnoDB tables and files
151029 15:39:58 Executing LOCK BINLOG FOR BACKUP...
151029 15:39:58 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '14489531'
xtrabackup: Stopping log copying thread.
.151029 15:39:58 >> log scanned up to (14489531)

151029 15:39:58 Executing UNLOCK BINLOG
151029 15:39:58 Executing UNLOCK TABLES
151029 15:39:58 All tables unlocked
151029 15:39:58 Backup created in directory '/data/mysql/backup/full/2015-10-29_15-39-38'
151029 15:39:58 [00] Writing backup-my.cnf
151029 15:39:58 [00]        ...done
151029 15:39:58 [00] Writing xtrabackup_info
151029 15:39:58 [00]        ...done
xtrabackup: Transaction log of lsn (14489531) to (14489531) was copied.
151029 15:39:58 completed OK!

把所有那些合在一起的备份进行应用，并回滚未提交的事务：
[root@rh64 full]# innobackupex --user='bakusr' --password='oracle' --apply-log --use-memory=1g /data/mysql/backup/full

[html] view plain copy print ?

151029 16:31:54 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 /data/mysql/backup/full
xtrabackup: This target seems to be already prepared.
xtrabackup: notice: xtrabackup_logfile was already used to '--prepare'.
xtrabackup: using the following InnoDB configuration for recovery:
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
xtrabackup: using the following InnoDB configuration for recovery:
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
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 1073741824 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: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 1.0G
InnoDB: Completed initialization of buffer pool
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 13254698
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 13254708
xtrabackup: using the following InnoDB configuration for recovery:
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
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: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 1.0G
InnoDB: Completed initialization of buffer pool
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 13254708
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 13254718
151029 16:31:58 completed OK!

151029 16:31:54 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 /data/mysql/backup/full
xtrabackup: This target seems to be already prepared.
xtrabackup: notice: xtrabackup_logfile was already used to '--prepare'.
xtrabackup: using the following InnoDB configuration for recovery:
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
xtrabackup: using the following InnoDB configuration for recovery:
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
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 1073741824 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: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 1.0G
InnoDB: Completed initialization of buffer pool
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 13254698

xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 13254708
xtrabackup: using the following InnoDB configuration for recovery:
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
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: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 1.0G
InnoDB: Completed initialization of buffer pool
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 13254708
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 13254718
151029 16:31:58 completed OK!

3、把恢复完的备份数据拷贝到数据库数据存储的目录下：

1）关闭数据库
[root@rh64 inc_2]# mysqladmin shutdown -u root -p
Enter password:
[root@rh64 inc_2]# netstat -an |grep :3306
[root@rh64 inc_2]# mysqladmin status
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

建立新的数据库存储目录：

[root@rh64 inc_2]# mv mysql mysql.old

[root@rh64 inc_2]# mkdir -p /var/lib/mysql

查看最近的备份：
[root@rh64 full]# ls -lt
total 122928

[html] view plain copy print ?

-rw-r----- 1 root root 12582912 Oct 29 16:55 ibdata1
-rw-r----- 1 root root 10485760 Oct 29 16:55 ibdata2
-rw-r--r-- 1 root root 50331648 Oct 29 16:55 ib_logfile0
-rw-r----- 1 root root 115 Oct 29 16:55 xtrabackup_checkpoints
drwx------ 6 root root 4096 Oct 29 16:54 2015-10-29_16-54-06
drwx------ 6 root root 4096 Oct 29 16:53 2015-10-29_16-53-16
drwx------ 4 root root 4096 Oct 29 16:52 2015-10-29_16-52-46
drwx------ 2 root root 4096 Oct 29 16:51 2015-10-29_16-51-54
drwx------ 2 root root 4096 Oct 29 16:50 2015-10-29_16-50-51
-rw-r--r-- 1 root root 50331648 Oct 29 16:49 ib_logfile1
-rw-r----- 1 root root 2097152 Oct 29 16:49 xtrabackup_logfile
-rw-r----- 1 root root 524 Oct 29 16:43 xtrabackup_info
-rw-r----- 1 root root 398 Oct 29 16:43 backup-my.cnf
drwx------ 2 root root 4096 Oct 29 16:43 performance_schema
drwx------ 2 root root 4096 Oct 29 16:43 mysql
drwx------ 2 root root 4096 Oct 29 16:43 test
drwx------ 2 root root 4096 Oct 29 16:43 prod

-rw-r----- 1 root root 12582912 Oct 29 16:55 ibdata1
-rw-r----- 1 root root 10485760 Oct 29 16:55 ibdata2
-rw-r--r-- 1 root root 50331648 Oct 29 16:55 ib_logfile0
-rw-r----- 1 root root      115 Oct 29 16:55 xtrabackup_checkpoints
drwx------ 6 root root     4096 Oct 29 16:54 2015-10-29_16-54-06
drwx------ 6 root root     4096 Oct 29 16:53 2015-10-29_16-53-16
drwx------ 4 root root     4096 Oct 29 16:52 2015-10-29_16-52-46
drwx------ 2 root root     4096 Oct 29 16:51 2015-10-29_16-51-54
drwx------ 2 root root     4096 Oct 29 16:50 2015-10-29_16-50-51
-rw-r--r-- 1 root root 50331648 Oct 29 16:49 ib_logfile1
-rw-r----- 1 root root  2097152 Oct 29 16:49 xtrabackup_logfile
-rw-r----- 1 root root      524 Oct 29 16:43 xtrabackup_info
-rw-r----- 1 root root      398 Oct 29 16:43 backup-my.cnf
drwx------ 2 root root     4096 Oct 29 16:43 performance_schema
drwx------ 2 root root     4096 Oct 29 16:43 mysql
drwx------ 2 root root     4096 Oct 29 16:43 test
drwx------ 2 root root     4096 Oct 29 16:43 prod

选择最后合成的备份目录：2015-10-29_16-54-06

拷贝备份数据到数据库存储目录：
[root@rh64 lib]# innobackupex --default-files=/tmp/my.cnf --copy-back --resync /data/mysql/backup/full/2015-10-29_16-54-06

[html] view plain copy print ?

151029 15:45:46 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)
151029 15:45:46 [01] Copying ib_logfile0 to /var/lib/mysql/ib_logfile0
151029 15:45:46 [01] ...done
151029 15:45:47 [01] Copying ib_logfile1 to /var/lib/mysql/ib_logfile1
151029 15:45:47 [01] ...done
151029 15:45:48 [01] Copying ibdata1 to /var/lib/mysql/ibdata1
151029 15:45:49 [01] ...done
151029 15:45:49 [01] Copying ibdata2 to /var/lib/mysql/ibdata2
151029 15:45:49 [01] ...done
151029 15:45:49 [01] Copying ./2015-10-29_15-39-38/xtrabackup_info to /var/lib/mysql/2015-10-29_15-39-38/xtrabackup_info
151029 15:45:49 [01] ...done
151029 15:45:49 [01] Copying ./2015-10-29_15-37-38/xtrabackup_info to /var/lib/mysql/2015-10-29_15-37-38/xtrabackup_info
151029 15:45:49 [01] ...done
151029 15:45:50 [01] Copying ./prod/t1.frm to /var/lib/mysql/prod/t1.frm
151029 15:45:50 [01] ...done
151029 15:45:50 [01] Copying ./prod/t2.ibd to /var/lib/mysql/prod/t2.ibd
151029 15:45:50 [01] ...done
151029 15:45:50 [01] Copying ./prod/t2.frm to /var/lib/mysql/prod/t2.frm
151029 15:45:50 [01] ...done
151029 15:45:50 [01] Copying ./prod/t1.ibd to /var/lib/mysql/prod/t1.ibd
151029 15:45:50 [01] ...done
151029 15:45:51 [01] Copying ./prod/t3.frm to /var/lib/mysql/prod/t3.frm
151029 15:45:51 [01] ...done
151029 15:45:51 [01] Copying ./prod/db.opt to /var/lib/mysql/prod/db.opt
151029 15:45:51 [01] ...done
151029 15:45:51 [01] Copying ./prod/t3.ibd to /var/lib/mysql/prod/t3.ibd
151029 15:45:51 [01] ...done
151029 15:45:51 [01] Creating directory /var/lib/mysql/2015-10-29_15-36-34
151029 15:45:51 [01] ...done.151029 15:45:51 [01] Creating directory /var/lib/mysql/2015-10-29_15-34-59
151029 15:45:51 [01] ...done.151029 15:45:51 [01] Copying ./test/db.opt to /var/lib/mysql/test/db.opt
151029 15:45:51 [01] ...done
151029 15:45:51 [01] Copying ./mysql/time_zone_name.MYD to /var/lib/mysql/mysql/time_zone_name.MYD
151029 15:45:51 [01] ...done
151029 15:45:51 [01] Copying ./mysql/help_topic.frm to /var/lib/mysql/mysql/help_topic.frm
151029 15:45:51 [01] ...done
151029 15:45:51 [01] Copying ./mysql/event.frm to /var/lib/mysql/mysql/event.frm
151029 15:45:51 [01] ...done
151029 15:45:51 [01] Copying ./mysql/time_zone.MYD to /var/lib/mysql/mysql/time_zone.MYD
151029 15:45:51 [01] ...done
151029 15:45:51 [01] Copying ./mysql/slow_log.CSV to /var/lib/mysql/mysql/slow_log.CSV
151029 15:45:51 [01] ...done
151029 15:45:51 [01] Copying ./mysql/innodb_index_stats.frm to /var/lib/mysql/mysql/innodb_index_stats.frm
151029 15:45:51 [01] ...done
151029 15:45:51 [01] Copying ./mysql/columns_priv.MYI to /var/lib/mysql/mysql/columns_priv.MYI
151029 15:45:52 [01] ...done
151029 15:45:52 [01] Copying ./mysql/plugin.MYI to /var/lib/mysql/mysql/plugin.MYI
151029 15:45:52 [01] ...done
151029 15:45:52 [01] Copying ./mysql/time_zone_leap_second.frm to /var/lib/mysql/mysql/time_zone_leap_second.frm
151029 15:45:52 [01] ...done
151029 15:45:52 [01] Copying ./mysql/time_zone_transition_type.MYI to /var/lib/mysql/mysql/time_zone_transition_type.MYI
151029 15:45:52 [01] ...done
151029 15:45:52 [01] Copying ./mysql/proc.frm to /var/lib/mysql/mysql/proc.frm
151029 15:45:52 [01] ...done
151029 15:45:52 [01] Copying ./mysql/procs_priv.MYD to /var/lib/mysql/mysql/procs_priv.MYD
151029 15:45:52 [01] ...done
151029 15:45:52 [01] Copying ./mysql/proxies_priv.MYI to /var/lib/mysql/mysql/proxies_priv.MYI
151029 15:45:52 [01] ...done
151029 15:45:52 [01] Copying ./mysql/slave_worker_info.ibd to /var/lib/mysql/mysql/slave_worker_info.ibd
151029 15:45:52 [01] ...done
151029 15:45:52 [01] Copying ./mysql/ndb_binlog_index.MYI to /var/lib/mysql/mysql/ndb_binlog_index.MYI
151029 15:45:52 [01] ...done
151029 15:45:53 [01] Copying ./mysql/servers.MYI to /var/lib/mysql/mysql/servers.MYI
151029 15:45:53 [01] ...done
151029 15:45:53 [01] Copying ./mysql/slow_log.frm to /var/lib/mysql/mysql/slow_log.frm
151029 15:45:53 [01] ...done
151029 15:45:53 [01] Copying ./mysql/help_relation.MYD to /var/lib/mysql/mysql/help_relation.MYD
151029 15:45:53 [01] ...done
151029 15:45:53 [01] Copying ./mysql/user.frm to /var/lib/mysql/mysql/user.frm
151029 15:45:53 [01] ...done
151029 15:45:53 [01] Copying ./mysql/plugin.frm to /var/lib/mysql/mysql/plugin.frm
151029 15:45:53 [01] ...done
151029 15:45:53 [01] Copying ./mysql/time_zone_name.frm to /var/lib/mysql/mysql/time_zone_name.frm
151029 15:45:53 [01] ...done
151029 15:45:53 [01] Copying ./mysql/user.MYI to /var/lib/mysql/mysql/user.MYI
151029 15:45:53 [01] ...done
151029 15:45:53 [01] Copying ./mysql/slave_master_info.ibd to /var/lib/mysql/mysql/slave_master_info.ibd
151029 15:45:53 [01] ...done
151029 15:45:54 [01] Copying ./mysql/help_relation.frm to /var/lib/mysql/mysql/help_relation.frm
151029 15:45:54 [01] ...done
151029 15:45:54 [01] Copying ./mysql/slow_log.CSM to /var/lib/mysql/mysql/slow_log.CSM
151029 15:45:54 [01] ...done
151029 15:45:54 [01] Copying ./mysql/time_zone_transition.MYD to /var/lib/mysql/mysql/time_zone_transition.MYD
151029 15:45:54 [01] ...done
151029 15:45:54 [01] Copying ./mysql/help_category.MYI to /var/lib/mysql/mysql/help_category.MYI
151029 15:45:54 [01] ...done
151029 15:45:54 [01] Copying ./mysql/proc.MYD to /var/lib/mysql/mysql/proc.MYD
151029 15:45:54 [01] ...done
151029 15:45:54 [01] Copying ./mysql/slave_relay_log_info.ibd to /var/lib/mysql/mysql/slave_relay_log_info.ibd
151029 15:45:54 [01] ...done
151029 15:45:54 [01] Copying ./mysql/db.MYD to /var/lib/mysql/mysql/db.MYD
151029 15:45:54 [01] ...done
151029 15:45:54 [01] Copying ./mysql/tables_priv.MYD to /var/lib/mysql/mysql/tables_priv.MYD
151029 15:45:54 [01] ...done
151029 15:45:54 [01] Copying ./mysql/time_zone_leap_second.MYI to /var/lib/mysql/mysql/time_zone_leap_second.MYI
151029 15:45:54 [01] ...done
151029 15:45:55 [01] Copying ./mysql/help_relation.MYI to /var/lib/mysql/mysql/help_relation.MYI
151029 15:45:55 [01] ...done
151029 15:45:55 [01] Copying ./mysql/ndb_binlog_index.MYD to /var/lib/mysql/mysql/ndb_binlog_index.MYD
151029 15:45:55 [01] ...done
151029 15:45:55 [01] Copying ./mysql/slave_worker_info.frm to /var/lib/mysql/mysql/slave_worker_info.frm
151029 15:45:55 [01] ...done
151029 15:45:55 [01] Copying ./mysql/time_zone.frm to /var/lib/mysql/mysql/time_zone.frm
151029 15:45:55 [01] ...done
151029 15:45:55 [01] Copying ./mysql/slave_relay_log_info.frm to /var/lib/mysql/mysql/slave_relay_log_info.frm
151029 15:45:55 [01] ...done
151029 15:45:55 [01] Copying ./mysql/columns_priv.MYD to /var/lib/mysql/mysql/columns_priv.MYD
151029 15:45:55 [01] ...done
151029 15:45:55 [01] Copying ./mysql/time_zone_transition_type.MYD to /var/lib/mysql/mysql/time_zone_transition_type.MYD
151029 15:45:55 [01] ...done
151029 15:45:55 [01] Copying ./mysql/user.MYD to /var/lib/mysql/mysql/user.MYD
151029 15:45:55 [01] ...done
151029 15:45:55 [01] Copying ./mysql/tables_priv.frm to /var/lib/mysql/mysql/tables_priv.frm
151029 15:45:55 [01] ...done
151029 15:45:56 [01] Copying ./mysql/help_category.MYD to /var/lib/mysql/mysql/help_category.MYD
151029 15:45:56 [01] ...done
151029 15:45:56 [01] Copying ./mysql/help_keyword.MYD to /var/lib/mysql/mysql/help_keyword.MYD
151029 15:45:56 [01] ...done
151029 15:45:56 [01] Copying ./mysql/time_zone_transition.frm to /var/lib/mysql/mysql/time_zone_transition.frm
151029 15:45:56 [01] ...done
151029 15:45:56 [01] Copying ./mysql/servers.frm to /var/lib/mysql/mysql/servers.frm
151029 15:45:56 [01] ...done
151029 15:45:56 [01] Copying ./mysql/general_log.frm to /var/lib/mysql/mysql/general_log.frm
151029 15:45:56 [01] ...done
151029 15:45:56 [01] Copying ./mysql/help_keyword.frm to /var/lib/mysql/mysql/help_keyword.frm
151029 15:45:56 [01] ...done
151029 15:45:56 [01] Copying ./mysql/time_zone_transition_type.frm to /var/lib/mysql/mysql/time_zone_transition_type.frm
151029 15:45:56 [01] ...done
151029 15:45:56 [01] Copying ./mysql/columns_priv.frm to /var/lib/mysql/mysql/columns_priv.frm
151029 15:45:56 [01] ...done
151029 15:45:57 [01] Copying ./mysql/proxies_priv.frm to /var/lib/mysql/mysql/proxies_priv.frm
151029 15:45:57 [01] ...done
151029 15:45:57 [01] Copying ./mysql/help_keyword.MYI to /var/lib/mysql/mysql/help_keyword.MYI
151029 15:45:57 [01] ...done
151029 15:45:57 [01] Copying ./mysql/general_log.CSV to /var/lib/mysql/mysql/general_log.CSV
151029 15:45:57 [01] ...done
151029 15:45:57 [01] Copying ./mysql/event.MYD to /var/lib/mysql/mysql/event.MYD
151029 15:45:57 [01] ...done
151029 15:45:57 [01] Copying ./mysql/plugin.MYD to /var/lib/mysql/mysql/plugin.MYD
151029 15:45:57 [01] ...done
151029 15:45:57 [01] Copying ./mysql/proxies_priv.MYD to /var/lib/mysql/mysql/proxies_priv.MYD
151029 15:45:57 [01] ...done
151029 15:45:57 [01] Copying ./mysql/servers.MYD to /var/lib/mysql/mysql/servers.MYD
151029 15:45:57 [01] ...done
151029 15:45:57 [01] Copying ./mysql/innodb_index_stats.ibd to /var/lib/mysql/mysql/innodb_index_stats.ibd
151029 15:45:57 [01] ...done
151029 15:45:57 [01] Copying ./mysql/event.MYI to /var/lib/mysql/mysql/event.MYI
151029 15:45:57 [01] ...done
151029 15:45:58 [01] Copying ./mysql/time_zone_transition.MYI to /var/lib/mysql/mysql/time_zone_transition.MYI
151029 15:45:58 [01] ...done
151029 15:45:58 [01] Copying ./mysql/tables_priv.MYI to /var/lib/mysql/mysql/tables_priv.MYI
151029 15:45:58 [01] ...done
151029 15:45:58 [01] Copying ./mysql/ndb_binlog_index.frm to /var/lib/mysql/mysql/ndb_binlog_index.frm
151029 15:45:58 [01] ...done
151029 15:45:58 [01] Copying ./mysql/db.MYI to /var/lib/mysql/mysql/db.MYI
151029 15:45:58 [01] ...done
151029 15:45:58 [01] Copying ./mysql/time_zone_name.MYI to /var/lib/mysql/mysql/time_zone_name.MYI
151029 15:45:58 [01] ...done
151029 15:45:58 [01] Copying ./mysql/time_zone_leap_second.MYD to /var/lib/mysql/mysql/time_zone_leap_second.MYD
151029 15:45:58 [01] ...done
151029 15:45:58 [01] Copying ./mysql/help_topic.MYD to /var/lib/mysql/mysql/help_topic.MYD
151029 15:45:58 [01] ...done
151029 15:45:58 [01] Copying ./mysql/help_topic.MYI to /var/lib/mysql/mysql/help_topic.MYI
151029 15:45:58 [01] ...done
151029 15:45:59 [01] Copying ./mysql/db.frm to /var/lib/mysql/mysql/db.frm
151029 15:45:59 [01] ...done
151029 15:45:59 [01] Copying ./mysql/func.MYI to /var/lib/mysql/mysql/func.MYI
151029 15:45:59 [01] ...done
151029 15:45:59 [01] Copying ./mysql/procs_priv.MYI to /var/lib/mysql/mysql/procs_priv.MYI
151029 15:45:59 [01] ...done
151029 15:45:59 [01] Copying ./mysql/help_category.frm to /var/lib/mysql/mysql/help_category.frm
151029 15:45:59 [01] ...done
151029 15:45:59 [01] Copying ./mysql/procs_priv.frm to /var/lib/mysql/mysql/procs_priv.frm
151029 15:45:59 [01] ...done
151029 15:45:59 [01] Copying ./mysql/func.MYD to /var/lib/mysql/mysql/func.MYD
151029 15:45:59 [01] ...done
151029 15:45:59 [01] Copying ./mysql/func.frm to /var/lib/mysql/mysql/func.frm
151029 15:45:59 [01] ...done
151029 15:45:59 [01] Copying ./mysql/proc.MYI to /var/lib/mysql/mysql/proc.MYI
151029 15:45:59 [01] ...done
151029 15:46:00 [01] Copying ./mysql/innodb_table_stats.ibd to /var/lib/mysql/mysql/innodb_table_stats.ibd
151029 15:46:00 [01] ...done
151029 15:46:00 [01] Copying ./mysql/general_log.CSM to /var/lib/mysql/mysql/general_log.CSM
151029 15:46:00 [01] ...done
151029 15:46:00 [01] Copying ./mysql/time_zone.MYI to /var/lib/mysql/mysql/time_zone.MYI
151029 15:46:00 [01] ...done
151029 15:46:00 [01] Copying ./mysql/slave_master_info.frm to /var/lib/mysql/mysql/slave_master_info.frm
151029 15:46:00 [01] ...done
151029 15:46:00 [01] Copying ./mysql/innodb_table_stats.frm to /var/lib/mysql/mysql/innodb_table_stats.frm
151029 15:46:00 [01] ...done
151029 15:46:00 [01] Copying ./performance_schema/users.frm to /var/lib/mysql/performance_schema/users.frm
151029 15:46:00 [01] ...done
151029 15:46:00 [01] Copying ./performance_schema/events_waits_history_long.frm to /var/lib/mysql/performance_schema/events_waits_history_long.frm
151029 15:46:00 [01] ...done
151029 15:46:00 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_host_by_event_name.frm
151029 15:46:00 [01] ...done
151029 15:46:00 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /var/lib/mysql/performance_schema/table_io_waits_summary_by_index_usage.frm
151029 15:46:00 [01] ...done
151029 15:46:01 [01] Copying ./performance_schema/events_waits_history.frm to /var/lib/mysql/performance_schema/events_waits_history.frm
151029 15:46:01 [01] ...done
151029 15:46:01 [01] Copying ./performance_schema/host_cache.frm to /var/lib/mysql/performance_schema/host_cache.frm
151029 15:46:01 [01] ...done
151029 15:46:01 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_thread_by_event_name.frm
151029 15:46:01 [01] ...done
151029 15:46:01 [01] Copying ./performance_schema/session_connect_attrs.frm to /var/lib/mysql/performance_schema/session_connect_attrs.frm
151029 15:46:01 [01] ...done
151029 15:46:01 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /var/lib/mysql/performance_schema/objects_summary_global_by_type.frm
151029 15:46:01 [01] ...done
151029 15:46:01 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /var/lib/mysql/performance_schema/session_account_connect_attrs.frm
151029 15:46:01 [01] ...done
151029 15:46:01 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /var/lib/mysql/performance_schema/socket_summary_by_event_name.frm
151029 15:46:01 [01] ...done
151029 15:46:01 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_global_by_event_name.frm
151029 15:46:01 [01] ...done
151029 15:46:02 [01] Copying ./performance_schema/rwlock_instances.frm to /var/lib/mysql/performance_schema/rwlock_instances.frm
151029 15:46:02 [01] ...done
151029 15:46:02 [01] Copying ./performance_schema/events_stages_current.frm to /var/lib/mysql/performance_schema/events_stages_current.frm
151029 15:46:02 [01] ...done
151029 15:46:02 [01] Copying ./performance_schema/file_summary_by_instance.frm to /var/lib/mysql/performance_schema/file_summary_by_instance.frm
151029 15:46:02 [01] ...done
151029 15:46:02 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_host_by_event_name.frm
151029 15:46:02 [01] ...done
151029 15:46:02 [01] Copying ./performance_schema/performance_timers.frm to /var/lib/mysql/performance_schema/performance_timers.frm
151029 15:46:02 [01] ...done
151029 15:46:02 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_thread_by_event_name.frm
151029 15:46:02 [01] ...done
151029 15:46:02 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_user_by_event_name.frm
151029 15:46:02 [01] ...done
151029 15:46:02 [01] Copying ./performance_schema/cond_instances.frm to /var/lib/mysql/performance_schema/cond_instances.frm
151029 15:46:03 [01] ...done
151029 15:46:03 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_global_by_event_name.frm
151029 15:46:03 [01] ...done
151029 15:46:03 [01] Copying ./performance_schema/setup_timers.frm to /var/lib/mysql/performance_schema/setup_timers.frm
151029 15:46:03 [01] ...done
151029 15:46:03 [01] Copying ./performance_schema/hosts.frm to /var/lib/mysql/performance_schema/hosts.frm
151029 15:46:03 [01] ...done
151029 15:46:03 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /var/lib/mysql/performance_schema/socket_summary_by_instance.frm
151029 15:46:03 [01] ...done
151029 15:46:03 [01] Copying ./performance_schema/file_instances.frm to /var/lib/mysql/performance_schema/file_instances.frm
151029 15:46:03 [01] ...done
151029 15:46:03 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /var/lib/mysql/performance_schema/table_lock_waits_summary_by_table.frm
151029 15:46:03 [01] ...done
151029 15:46:03 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_user_by_event_name.frm
151029 15:46:03 [01] ...done
151029 15:46:04 [01] Copying ./performance_schema/events_waits_current.frm to /var/lib/mysql/performance_schema/events_waits_current.frm
151029 15:46:04 [01] ...done
151029 15:46:04 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_digest.frm
151029 15:46:04 [01] ...done
151029 15:46:04 [01] Copying ./performance_schema/events_stages_history.frm to /var/lib/mysql/performance_schema/events_stages_history.frm
151029 15:46:04 [01] ...done
151029 15:46:04 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /var/lib/mysql/performance_schema/file_summary_by_event_name.frm
151029 15:46:04 [01] ...done
151029 15:46:04 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /var/lib/mysql/performance_schema/table_io_waits_summary_by_table.frm
151029 15:46:04 [01] ...done
151029 15:46:04 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_thread_by_event_name.frm
151029 15:46:04 [01] ...done
151029 15:46:04 [01] Copying ./performance_schema/threads.frm to /var/lib/mysql/performance_schema/threads.frm
151029 15:46:04 [01] ...done
151029 15:46:04 [01] Copying ./performance_schema/accounts.frm to /var/lib/mysql/performance_schema/accounts.frm
151029 15:46:04 [01] ...done
151029 15:46:05 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_global_by_event_name.frm
151029 15:46:05 [01] ...done
151029 15:46:05 [01] Copying ./performance_schema/setup_objects.frm to /var/lib/mysql/performance_schema/setup_objects.frm
151029 15:46:05 [01] ...done
151029 15:46:05 [01] Copying ./performance_schema/events_statements_current.frm to /var/lib/mysql/performance_schema/events_statements_current.frm
151029 15:46:05 [01] ...done
151029 15:46:05 [01] Copying ./performance_schema/socket_instances.frm to /var/lib/mysql/performance_schema/socket_instances.frm
151029 15:46:05 [01] ...done
151029 15:46:05 [01] Copying ./performance_schema/setup_actors.frm to /var/lib/mysql/performance_schema/setup_actors.frm
151029 15:46:05 [01] ...done
151029 15:46:05 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_account_by_event_name.frm
151029 15:46:05 [01] ...done
151029 15:46:05 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_host_by_event_name.frm
151029 15:46:05 [01] ...done
151029 15:46:05 [01] Copying ./performance_schema/db.opt to /var/lib/mysql/performance_schema/db.opt
151029 15:46:05 [01] ...done
151029 15:46:06 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_user_by_event_name.frm
151029 15:46:06 [01] ...done
151029 15:46:06 [01] Copying ./performance_schema/events_statements_history.frm to /var/lib/mysql/performance_schema/events_statements_history.frm
151029 15:46:06 [01] ...done
151029 15:46:06 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_account_by_event_name.frm
151029 15:46:06 [01] ...done
151029 15:46:06 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_instance.frm
151029 15:46:06 [01] ...done
151029 15:46:06 [01] Copying ./performance_schema/setup_consumers.frm to /var/lib/mysql/performance_schema/setup_consumers.frm
151029 15:46:06 [01] ...done
151029 15:46:06 [01] Copying ./performance_schema/setup_instruments.frm to /var/lib/mysql/performance_schema/setup_instruments.frm
151029 15:46:06 [01] ...done
151029 15:46:06 [01] Copying ./performance_schema/mutex_instances.frm to /var/lib/mysql/performance_schema/mutex_instances.frm
151029 15:46:06 [01] ...done
151029 15:46:07 [01] Copying ./performance_schema/events_statements_history_long.frm to /var/lib/mysql/performance_schema/events_statements_history_long.frm
151029 15:46:07 [01] ...done
151029 15:46:07 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_account_by_event_name.frm
151029 15:46:07 [01] ...done
151029 15:46:07 [01] Copying ./performance_schema/events_stages_history_long.frm to /var/lib/mysql/performance_schema/events_stages_history_long.frm
151029 15:46:07 [01] ...done
151029 15:46:07 [01] Copying ./xtrabackup_info to /var/lib/mysql/xtrabackup_info
151029 15:46:07 [01] ...done
151029 15:46:07 completed OK!

151029 15:45:46 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)
151029 15:45:46 [01] Copying ib_logfile0 to /var/lib/mysql/ib_logfile0
151029 15:45:46 [01]        ...done
151029 15:45:47 [01] Copying ib_logfile1 to /var/lib/mysql/ib_logfile1
151029 15:45:47 [01]        ...done
151029 15:45:48 [01] Copying ibdata1 to /var/lib/mysql/ibdata1
151029 15:45:49 [01]        ...done
151029 15:45:49 [01] Copying ibdata2 to /var/lib/mysql/ibdata2
151029 15:45:49 [01]        ...done
151029 15:45:49 [01] Copying ./2015-10-29_15-39-38/xtrabackup_info to /var/lib/mysql/2015-10-29_15-39-38/xtrabackup_info
151029 15:45:49 [01]        ...done
151029 15:45:49 [01] Copying ./2015-10-29_15-37-38/xtrabackup_info to /var/lib/mysql/2015-10-29_15-37-38/xtrabackup_info
151029 15:45:49 [01]        ...done
151029 15:45:50 [01] Copying ./prod/t1.frm to /var/lib/mysql/prod/t1.frm
151029 15:45:50 [01]        ...done
151029 15:45:50 [01] Copying ./prod/t2.ibd to /var/lib/mysql/prod/t2.ibd
151029 15:45:50 [01]        ...done
151029 15:45:50 [01] Copying ./prod/t2.frm to /var/lib/mysql/prod/t2.frm
151029 15:45:50 [01]        ...done
151029 15:45:50 [01] Copying ./prod/t1.ibd to /var/lib/mysql/prod/t1.ibd
151029 15:45:50 [01]        ...done
151029 15:45:51 [01] Copying ./prod/t3.frm to /var/lib/mysql/prod/t3.frm
151029 15:45:51 [01]        ...done
151029 15:45:51 [01] Copying ./prod/db.opt to /var/lib/mysql/prod/db.opt
151029 15:45:51 [01]        ...done
151029 15:45:51 [01] Copying ./prod/t3.ibd to /var/lib/mysql/prod/t3.ibd
151029 15:45:51 [01]        ...done
151029 15:45:51 [01] Creating directory /var/lib/mysql/2015-10-29_15-36-34
151029 15:45:51 [01] ...done.151029 15:45:51 [01] Creating directory /var/lib/mysql/2015-10-29_15-34-59
151029 15:45:51 [01] ...done.151029 15:45:51 [01] Copying ./test/db.opt to /var/lib/mysql/test/db.opt
151029 15:45:51 [01]        ...done
151029 15:45:51 [01] Copying ./mysql/time_zone_name.MYD to /var/lib/mysql/mysql/time_zone_name.MYD
151029 15:45:51 [01]        ...done
151029 15:45:51 [01] Copying ./mysql/help_topic.frm to /var/lib/mysql/mysql/help_topic.frm
151029 15:45:51 [01]        ...done
151029 15:45:51 [01] Copying ./mysql/event.frm to /var/lib/mysql/mysql/event.frm
151029 15:45:51 [01]        ...done
151029 15:45:51 [01] Copying ./mysql/time_zone.MYD to /var/lib/mysql/mysql/time_zone.MYD
151029 15:45:51 [01]        ...done
151029 15:45:51 [01] Copying ./mysql/slow_log.CSV to /var/lib/mysql/mysql/slow_log.CSV
151029 15:45:51 [01]        ...done
151029 15:45:51 [01] Copying ./mysql/innodb_index_stats.frm to /var/lib/mysql/mysql/innodb_index_stats.frm
151029 15:45:51 [01]        ...done
151029 15:45:51 [01] Copying ./mysql/columns_priv.MYI to /var/lib/mysql/mysql/columns_priv.MYI
151029 15:45:52 [01]        ...done
151029 15:45:52 [01] Copying ./mysql/plugin.MYI to /var/lib/mysql/mysql/plugin.MYI
151029 15:45:52 [01]        ...done
151029 15:45:52 [01] Copying ./mysql/time_zone_leap_second.frm to /var/lib/mysql/mysql/time_zone_leap_second.frm
151029 15:45:52 [01]        ...done
151029 15:45:52 [01] Copying ./mysql/time_zone_transition_type.MYI to /var/lib/mysql/mysql/time_zone_transition_type.MYI
151029 15:45:52 [01]        ...done
151029 15:45:52 [01] Copying ./mysql/proc.frm to /var/lib/mysql/mysql/proc.frm
151029 15:45:52 [01]        ...done
151029 15:45:52 [01] Copying ./mysql/procs_priv.MYD to /var/lib/mysql/mysql/procs_priv.MYD
151029 15:45:52 [01]        ...done
151029 15:45:52 [01] Copying ./mysql/proxies_priv.MYI to /var/lib/mysql/mysql/proxies_priv.MYI
151029 15:45:52 [01]        ...done
151029 15:45:52 [01] Copying ./mysql/slave_worker_info.ibd to /var/lib/mysql/mysql/slave_worker_info.ibd
151029 15:45:52 [01]        ...done
151029 15:45:52 [01] Copying ./mysql/ndb_binlog_index.MYI to /var/lib/mysql/mysql/ndb_binlog_index.MYI
151029 15:45:52 [01]        ...done
151029 15:45:53 [01] Copying ./mysql/servers.MYI to /var/lib/mysql/mysql/servers.MYI
151029 15:45:53 [01]        ...done
151029 15:45:53 [01] Copying ./mysql/slow_log.frm to /var/lib/mysql/mysql/slow_log.frm
151029 15:45:53 [01]        ...done
151029 15:45:53 [01] Copying ./mysql/help_relation.MYD to /var/lib/mysql/mysql/help_relation.MYD
151029 15:45:53 [01]        ...done
151029 15:45:53 [01] Copying ./mysql/user.frm to /var/lib/mysql/mysql/user.frm
151029 15:45:53 [01]        ...done
151029 15:45:53 [01] Copying ./mysql/plugin.frm to /var/lib/mysql/mysql/plugin.frm
151029 15:45:53 [01]        ...done
151029 15:45:53 [01] Copying ./mysql/time_zone_name.frm to /var/lib/mysql/mysql/time_zone_name.frm
151029 15:45:53 [01]        ...done
151029 15:45:53 [01] Copying ./mysql/user.MYI to /var/lib/mysql/mysql/user.MYI
151029 15:45:53 [01]        ...done
151029 15:45:53 [01] Copying ./mysql/slave_master_info.ibd to /var/lib/mysql/mysql/slave_master_info.ibd
151029 15:45:53 [01]        ...done
151029 15:45:54 [01] Copying ./mysql/help_relation.frm to /var/lib/mysql/mysql/help_relation.frm
151029 15:45:54 [01]        ...done
151029 15:45:54 [01] Copying ./mysql/slow_log.CSM to /var/lib/mysql/mysql/slow_log.CSM
151029 15:45:54 [01]        ...done
151029 15:45:54 [01] Copying ./mysql/time_zone_transition.MYD to /var/lib/mysql/mysql/time_zone_transition.MYD
151029 15:45:54 [01]        ...done
151029 15:45:54 [01] Copying ./mysql/help_category.MYI to /var/lib/mysql/mysql/help_category.MYI
151029 15:45:54 [01]        ...done
151029 15:45:54 [01] Copying ./mysql/proc.MYD to /var/lib/mysql/mysql/proc.MYD
151029 15:45:54 [01]        ...done
151029 15:45:54 [01] Copying ./mysql/slave_relay_log_info.ibd to /var/lib/mysql/mysql/slave_relay_log_info.ibd
151029 15:45:54 [01]        ...done
151029 15:45:54 [01] Copying ./mysql/db.MYD to /var/lib/mysql/mysql/db.MYD
151029 15:45:54 [01]        ...done
151029 15:45:54 [01] Copying ./mysql/tables_priv.MYD to /var/lib/mysql/mysql/tables_priv.MYD
151029 15:45:54 [01]        ...done
151029 15:45:54 [01] Copying ./mysql/time_zone_leap_second.MYI to /var/lib/mysql/mysql/time_zone_leap_second.MYI
151029 15:45:54 [01]        ...done
151029 15:45:55 [01] Copying ./mysql/help_relation.MYI to /var/lib/mysql/mysql/help_relation.MYI
151029 15:45:55 [01]        ...done
151029 15:45:55 [01] Copying ./mysql/ndb_binlog_index.MYD to /var/lib/mysql/mysql/ndb_binlog_index.MYD
151029 15:45:55 [01]        ...done
151029 15:45:55 [01] Copying ./mysql/slave_worker_info.frm to /var/lib/mysql/mysql/slave_worker_info.frm
151029 15:45:55 [01]        ...done
151029 15:45:55 [01] Copying ./mysql/time_zone.frm to /var/lib/mysql/mysql/time_zone.frm
151029 15:45:55 [01]        ...done
151029 15:45:55 [01] Copying ./mysql/slave_relay_log_info.frm to /var/lib/mysql/mysql/slave_relay_log_info.frm
151029 15:45:55 [01]        ...done
151029 15:45:55 [01] Copying ./mysql/columns_priv.MYD to /var/lib/mysql/mysql/columns_priv.MYD
151029 15:45:55 [01]        ...done
151029 15:45:55 [01] Copying ./mysql/time_zone_transition_type.MYD to /var/lib/mysql/mysql/time_zone_transition_type.MYD
151029 15:45:55 [01]        ...done
151029 15:45:55 [01] Copying ./mysql/user.MYD to /var/lib/mysql/mysql/user.MYD
151029 15:45:55 [01]        ...done
151029 15:45:55 [01] Copying ./mysql/tables_priv.frm to /var/lib/mysql/mysql/tables_priv.frm
151029 15:45:55 [01]        ...done
151029 15:45:56 [01] Copying ./mysql/help_category.MYD to /var/lib/mysql/mysql/help_category.MYD
151029 15:45:56 [01]        ...done
151029 15:45:56 [01] Copying ./mysql/help_keyword.MYD to /var/lib/mysql/mysql/help_keyword.MYD
151029 15:45:56 [01]        ...done
151029 15:45:56 [01] Copying ./mysql/time_zone_transition.frm to /var/lib/mysql/mysql/time_zone_transition.frm
151029 15:45:56 [01]        ...done
151029 15:45:56 [01] Copying ./mysql/servers.frm to /var/lib/mysql/mysql/servers.frm
151029 15:45:56 [01]        ...done
151029 15:45:56 [01] Copying ./mysql/general_log.frm to /var/lib/mysql/mysql/general_log.frm
151029 15:45:56 [01]        ...done
151029 15:45:56 [01] Copying ./mysql/help_keyword.frm to /var/lib/mysql/mysql/help_keyword.frm
151029 15:45:56 [01]        ...done
151029 15:45:56 [01] Copying ./mysql/time_zone_transition_type.frm to /var/lib/mysql/mysql/time_zone_transition_type.frm
151029 15:45:56 [01]        ...done
151029 15:45:56 [01] Copying ./mysql/columns_priv.frm to /var/lib/mysql/mysql/columns_priv.frm
151029 15:45:56 [01]        ...done
151029 15:45:57 [01] Copying ./mysql/proxies_priv.frm to /var/lib/mysql/mysql/proxies_priv.frm
151029 15:45:57 [01]        ...done
151029 15:45:57 [01] Copying ./mysql/help_keyword.MYI to /var/lib/mysql/mysql/help_keyword.MYI
151029 15:45:57 [01]        ...done
151029 15:45:57 [01] Copying ./mysql/general_log.CSV to /var/lib/mysql/mysql/general_log.CSV
151029 15:45:57 [01]        ...done
151029 15:45:57 [01] Copying ./mysql/event.MYD to /var/lib/mysql/mysql/event.MYD
151029 15:45:57 [01]        ...done
151029 15:45:57 [01] Copying ./mysql/plugin.MYD to /var/lib/mysql/mysql/plugin.MYD
151029 15:45:57 [01]        ...done
151029 15:45:57 [01] Copying ./mysql/proxies_priv.MYD to /var/lib/mysql/mysql/proxies_priv.MYD
151029 15:45:57 [01]        ...done
151029 15:45:57 [01] Copying ./mysql/servers.MYD to /var/lib/mysql/mysql/servers.MYD
151029 15:45:57 [01]        ...done
151029 15:45:57 [01] Copying ./mysql/innodb_index_stats.ibd to /var/lib/mysql/mysql/innodb_index_stats.ibd
151029 15:45:57 [01]        ...done
151029 15:45:57 [01] Copying ./mysql/event.MYI to /var/lib/mysql/mysql/event.MYI
151029 15:45:57 [01]        ...done
151029 15:45:58 [01] Copying ./mysql/time_zone_transition.MYI to /var/lib/mysql/mysql/time_zone_transition.MYI
151029 15:45:58 [01]        ...done
151029 15:45:58 [01] Copying ./mysql/tables_priv.MYI to /var/lib/mysql/mysql/tables_priv.MYI
151029 15:45:58 [01]        ...done
151029 15:45:58 [01] Copying ./mysql/ndb_binlog_index.frm to /var/lib/mysql/mysql/ndb_binlog_index.frm
151029 15:45:58 [01]        ...done
151029 15:45:58 [01] Copying ./mysql/db.MYI to /var/lib/mysql/mysql/db.MYI
151029 15:45:58 [01]        ...done
151029 15:45:58 [01] Copying ./mysql/time_zone_name.MYI to /var/lib/mysql/mysql/time_zone_name.MYI
151029 15:45:58 [01]        ...done
151029 15:45:58 [01] Copying ./mysql/time_zone_leap_second.MYD to /var/lib/mysql/mysql/time_zone_leap_second.MYD
151029 15:45:58 [01]        ...done
151029 15:45:58 [01] Copying ./mysql/help_topic.MYD to /var/lib/mysql/mysql/help_topic.MYD
151029 15:45:58 [01]        ...done
151029 15:45:58 [01] Copying ./mysql/help_topic.MYI to /var/lib/mysql/mysql/help_topic.MYI
151029 15:45:58 [01]        ...done
151029 15:45:59 [01] Copying ./mysql/db.frm to /var/lib/mysql/mysql/db.frm
151029 15:45:59 [01]        ...done
151029 15:45:59 [01] Copying ./mysql/func.MYI to /var/lib/mysql/mysql/func.MYI
151029 15:45:59 [01]        ...done
151029 15:45:59 [01] Copying ./mysql/procs_priv.MYI to /var/lib/mysql/mysql/procs_priv.MYI
151029 15:45:59 [01]        ...done
151029 15:45:59 [01] Copying ./mysql/help_category.frm to /var/lib/mysql/mysql/help_category.frm
151029 15:45:59 [01]        ...done
151029 15:45:59 [01] Copying ./mysql/procs_priv.frm to /var/lib/mysql/mysql/procs_priv.frm
151029 15:45:59 [01]        ...done
151029 15:45:59 [01] Copying ./mysql/func.MYD to /var/lib/mysql/mysql/func.MYD
151029 15:45:59 [01]        ...done
151029 15:45:59 [01] Copying ./mysql/func.frm to /var/lib/mysql/mysql/func.frm
151029 15:45:59 [01]        ...done
151029 15:45:59 [01] Copying ./mysql/proc.MYI to /var/lib/mysql/mysql/proc.MYI
151029 15:45:59 [01]        ...done
151029 15:46:00 [01] Copying ./mysql/innodb_table_stats.ibd to /var/lib/mysql/mysql/innodb_table_stats.ibd
151029 15:46:00 [01]        ...done
151029 15:46:00 [01] Copying ./mysql/general_log.CSM to /var/lib/mysql/mysql/general_log.CSM
151029 15:46:00 [01]        ...done
151029 15:46:00 [01] Copying ./mysql/time_zone.MYI to /var/lib/mysql/mysql/time_zone.MYI
151029 15:46:00 [01]        ...done
151029 15:46:00 [01] Copying ./mysql/slave_master_info.frm to /var/lib/mysql/mysql/slave_master_info.frm
151029 15:46:00 [01]        ...done
151029 15:46:00 [01] Copying ./mysql/innodb_table_stats.frm to /var/lib/mysql/mysql/innodb_table_stats.frm
151029 15:46:00 [01]        ...done
151029 15:46:00 [01] Copying ./performance_schema/users.frm to /var/lib/mysql/performance_schema/users.frm
151029 15:46:00 [01]        ...done
151029 15:46:00 [01] Copying ./performance_schema/events_waits_history_long.frm to /var/lib/mysql/performance_schema/events_waits_history_long.frm
151029 15:46:00 [01]        ...done
151029 15:46:00 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_host_by_event_name.frm
151029 15:46:00 [01]        ...done
151029 15:46:00 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /var/lib/mysql/performance_schema/table_io_waits_summary_by_index_usage.frm
151029 15:46:00 [01]        ...done
151029 15:46:01 [01] Copying ./performance_schema/events_waits_history.frm to /var/lib/mysql/performance_schema/events_waits_history.frm
151029 15:46:01 [01]        ...done
151029 15:46:01 [01] Copying ./performance_schema/host_cache.frm to /var/lib/mysql/performance_schema/host_cache.frm
151029 15:46:01 [01]        ...done
151029 15:46:01 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_thread_by_event_name.frm
151029 15:46:01 [01]        ...done
151029 15:46:01 [01] Copying ./performance_schema/session_connect_attrs.frm to /var/lib/mysql/performance_schema/session_connect_attrs.frm
151029 15:46:01 [01]        ...done
151029 15:46:01 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /var/lib/mysql/performance_schema/objects_summary_global_by_type.frm
151029 15:46:01 [01]        ...done
151029 15:46:01 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /var/lib/mysql/performance_schema/session_account_connect_attrs.frm
151029 15:46:01 [01]        ...done
151029 15:46:01 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /var/lib/mysql/performance_schema/socket_summary_by_event_name.frm
151029 15:46:01 [01]        ...done
151029 15:46:01 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_global_by_event_name.frm
151029 15:46:01 [01]        ...done
151029 15:46:02 [01] Copying ./performance_schema/rwlock_instances.frm to /var/lib/mysql/performance_schema/rwlock_instances.frm
151029 15:46:02 [01]        ...done
151029 15:46:02 [01] Copying ./performance_schema/events_stages_current.frm to /var/lib/mysql/performance_schema/events_stages_current.frm
151029 15:46:02 [01]        ...done
151029 15:46:02 [01] Copying ./performance_schema/file_summary_by_instance.frm to /var/lib/mysql/performance_schema/file_summary_by_instance.frm
151029 15:46:02 [01]        ...done
151029 15:46:02 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_host_by_event_name.frm
151029 15:46:02 [01]        ...done
151029 15:46:02 [01] Copying ./performance_schema/performance_timers.frm to /var/lib/mysql/performance_schema/performance_timers.frm
151029 15:46:02 [01]        ...done
151029 15:46:02 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_thread_by_event_name.frm
151029 15:46:02 [01]        ...done
151029 15:46:02 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_user_by_event_name.frm
151029 15:46:02 [01]        ...done
151029 15:46:02 [01] Copying ./performance_schema/cond_instances.frm to /var/lib/mysql/performance_schema/cond_instances.frm
151029 15:46:03 [01]        ...done
151029 15:46:03 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_global_by_event_name.frm
151029 15:46:03 [01]        ...done
151029 15:46:03 [01] Copying ./performance_schema/setup_timers.frm to /var/lib/mysql/performance_schema/setup_timers.frm
151029 15:46:03 [01]        ...done
151029 15:46:03 [01] Copying ./performance_schema/hosts.frm to /var/lib/mysql/performance_schema/hosts.frm
151029 15:46:03 [01]        ...done
151029 15:46:03 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /var/lib/mysql/performance_schema/socket_summary_by_instance.frm
151029 15:46:03 [01]        ...done
151029 15:46:03 [01] Copying ./performance_schema/file_instances.frm to /var/lib/mysql/performance_schema/file_instances.frm
151029 15:46:03 [01]        ...done
151029 15:46:03 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /var/lib/mysql/performance_schema/table_lock_waits_summary_by_table.frm
151029 15:46:03 [01]        ...done
151029 15:46:03 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_user_by_event_name.frm
151029 15:46:03 [01]        ...done
151029 15:46:04 [01] Copying ./performance_schema/events_waits_current.frm to /var/lib/mysql/performance_schema/events_waits_current.frm
151029 15:46:04 [01]        ...done
151029 15:46:04 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_digest.frm
151029 15:46:04 [01]        ...done
151029 15:46:04 [01] Copying ./performance_schema/events_stages_history.frm to /var/lib/mysql/performance_schema/events_stages_history.frm
151029 15:46:04 [01]        ...done
151029 15:46:04 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /var/lib/mysql/performance_schema/file_summary_by_event_name.frm
151029 15:46:04 [01]        ...done
151029 15:46:04 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /var/lib/mysql/performance_schema/table_io_waits_summary_by_table.frm
151029 15:46:04 [01]        ...done
151029 15:46:04 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_thread_by_event_name.frm
151029 15:46:04 [01]        ...done
151029 15:46:04 [01] Copying ./performance_schema/threads.frm to /var/lib/mysql/performance_schema/threads.frm
151029 15:46:04 [01]        ...done
151029 15:46:04 [01] Copying ./performance_schema/accounts.frm to /var/lib/mysql/performance_schema/accounts.frm
151029 15:46:04 [01]        ...done
151029 15:46:05 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_global_by_event_name.frm
151029 15:46:05 [01]        ...done
151029 15:46:05 [01] Copying ./performance_schema/setup_objects.frm to /var/lib/mysql/performance_schema/setup_objects.frm
151029 15:46:05 [01]        ...done
151029 15:46:05 [01] Copying ./performance_schema/events_statements_current.frm to /var/lib/mysql/performance_schema/events_statements_current.frm
151029 15:46:05 [01]        ...done
151029 15:46:05 [01] Copying ./performance_schema/socket_instances.frm to /var/lib/mysql/performance_schema/socket_instances.frm
151029 15:46:05 [01]        ...done
151029 15:46:05 [01] Copying ./performance_schema/setup_actors.frm to /var/lib/mysql/performance_schema/setup_actors.frm
151029 15:46:05 [01]        ...done
151029 15:46:05 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_account_by_event_name.frm
151029 15:46:05 [01]        ...done
151029 15:46:05 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_host_by_event_name.frm
151029 15:46:05 [01]        ...done
151029 15:46:05 [01] Copying ./performance_schema/db.opt to /var/lib/mysql/performance_schema/db.opt
151029 15:46:05 [01]        ...done
151029 15:46:06 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_user_by_event_name.frm
151029 15:46:06 [01]        ...done
151029 15:46:06 [01] Copying ./performance_schema/events_statements_history.frm to /var/lib/mysql/performance_schema/events_statements_history.frm
151029 15:46:06 [01]        ...done
151029 15:46:06 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_account_by_event_name.frm
151029 15:46:06 [01]        ...done
151029 15:46:06 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_instance.frm
151029 15:46:06 [01]        ...done
151029 15:46:06 [01] Copying ./performance_schema/setup_consumers.frm to /var/lib/mysql/performance_schema/setup_consumers.frm
151029 15:46:06 [01]        ...done
151029 15:46:06 [01] Copying ./performance_schema/setup_instruments.frm to /var/lib/mysql/performance_schema/setup_instruments.frm
151029 15:46:06 [01]        ...done
151029 15:46:06 [01] Copying ./performance_schema/mutex_instances.frm to /var/lib/mysql/performance_schema/mutex_instances.frm
151029 15:46:06 [01]        ...done
151029 15:46:07 [01] Copying ./performance_schema/events_statements_history_long.frm to /var/lib/mysql/performance_schema/events_statements_history_long.frm
151029 15:46:07 [01]        ...done
151029 15:46:07 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_account_by_event_name.frm
151029 15:46:07 [01]        ...done
151029 15:46:07 [01] Copying ./performance_schema/events_stages_history_long.frm to /var/lib/mysql/performance_schema/events_stages_history_long.frm
151029 15:46:07 [01]        ...done
151029 15:46:07 [01] Copying ./xtrabackup_info to /var/lib/mysql/xtrabackup_info
151029 15:46:07 [01]        ...done
151029 15:46:07 completed OK!

备份数据拷贝完成，启动数据库：

更改新的数据存储目录的属性：
[root@rh64 lib]# ls -l mysql
total 120868

[html] view plain copy print ?

drwx------ 2 root root 4096 Oct 29 15:45 2015-10-29_15-34-59
drwx------ 2 root root 4096 Oct 29 15:45 2015-10-29_15-36-34
drwx------ 2 root root 4096 Oct 29 15:45 2015-10-29_15-37-38
drwx------ 2 root root 4096 Oct 29 15:45 2015-10-29_15-39-38
-rw-r----- 1 root root 12582912 Oct 29 15:45 ibdata1
-rw-r----- 1 root root 10485760 Oct 29 15:45 ibdata2
-rw-r----- 1 root root 50331648 Oct 29 15:45 ib_logfile0
-rw-r----- 1 root root 50331648 Oct 29 15:45 ib_logfile1
drwx------ 2 root root 4096 Oct 29 15:46 mysql
drwx------ 2 root root 4096 Oct 29 15:46 performance_schema
drwx------ 2 root root 4096 Oct 29 15:45 prod
drwx------ 2 root root 4096 Oct 29 15:45 test
-rw-r----- 1 root root 524 Oct 29 15:46 xtrabackup_info

drwx------ 2 root root     4096 Oct 29 15:45 2015-10-29_15-34-59
drwx------ 2 root root     4096 Oct 29 15:45 2015-10-29_15-36-34
drwx------ 2 root root     4096 Oct 29 15:45 2015-10-29_15-37-38
drwx------ 2 root root     4096 Oct 29 15:45 2015-10-29_15-39-38
-rw-r----- 1 root root 12582912 Oct 29 15:45 ibdata1
-rw-r----- 1 root root 10485760 Oct 29 15:45 ibdata2
-rw-r----- 1 root root 50331648 Oct 29 15:45 ib_logfile0
-rw-r----- 1 root root 50331648 Oct 29 15:45 ib_logfile1
drwx------ 2 root root     4096 Oct 29 15:46 mysql
drwx------ 2 root root     4096 Oct 29 15:46 performance_schema
drwx------ 2 root root     4096 Oct 29 15:45 prod
drwx------ 2 root root     4096 Oct 29 15:45 test
-rw-r----- 1 root root      524 Oct 29 15:46 xtrabackup_info

[ root@rh64 lib]# ls -ld mysql.old
drwxr-xr-x 6 mysql mysql 4096 Oct 29 15:43 mysql.old
[root@rh64 lib]# chown -R mysql:mysql mysql
[root@rh64 lib]# ls -l mysql

[html] view plain copy print ?

total 120868
drwx------ 2 mysql mysql 4096 Oct 29 15:45 2015-10-29_15-34-59
drwx------ 2 mysql mysql 4096 Oct 29 15:45 2015-10-29_15-36-34
drwx------ 2 mysql mysql 4096 Oct 29 15:45 2015-10-29_15-37-38
drwx------ 2 mysql mysql 4096 Oct 29 15:45 2015-10-29_15-39-38
-rw-r----- 1 mysql mysql 12582912 Oct 29 15:45 ibdata1
-rw-r----- 1 mysql mysql 10485760 Oct 29 15:45 ibdata2
-rw-r----- 1 mysql mysql 50331648 Oct 29 15:45 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 Oct 29 15:45 ib_logfile1
drwx------ 2 mysql mysql 4096 Oct 29 15:46 mysql
drwx------ 2 mysql mysql 4096 Oct 29 15:46 performance_schema
drwx------ 2 mysql mysql 4096 Oct 29 15:45 prod
drwx------ 2 mysql mysql 4096 Oct 29 15:45 test
-rw-r----- 1 mysql mysql 524 Oct 29 15:46 xtrabackup_info

total 120868
drwx------ 2 mysql mysql     4096 Oct 29 15:45 2015-10-29_15-34-59
drwx------ 2 mysql mysql     4096 Oct 29 15:45 2015-10-29_15-36-34
drwx------ 2 mysql mysql     4096 Oct 29 15:45 2015-10-29_15-37-38
drwx------ 2 mysql mysql     4096 Oct 29 15:45 2015-10-29_15-39-38
-rw-r----- 1 mysql mysql 12582912 Oct 29 15:45 ibdata1
-rw-r----- 1 mysql mysql 10485760 Oct 29 15:45 ibdata2
-rw-r----- 1 mysql mysql 50331648 Oct 29 15:45 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 Oct 29 15:45 ib_logfile1
drwx------ 2 mysql mysql     4096 Oct 29 15:46 mysql
drwx------ 2 mysql mysql     4096 Oct 29 15:46 performance_schema
drwx------ 2 mysql mysql     4096 Oct 29 15:45 prod
drwx------ 2 mysql mysql     4096 Oct 29 15:45 test
-rw-r----- 1 mysql mysql      524 Oct 29 15:46 xtrabackup_info

[root@rh64 lib]# service mysql start
Starting MySQL (Percona Server)..[ OK ]

连接数据库，查看数据恢复：
[root@rh64 lib]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.25-73.1 Percona Server (GPL), Release 73.1, Revision 07b797f
Copyright (c) 2009-2015 Percona LLC and/or its affiliates
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use prod
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> select count(*) from t1;
+----------+
| count(*) |
+----------+
| 118304 |
+----------+
1 row in set (0.20 sec)

----数据恢复完成！！！

http://blog.csdn.net/lqx0405/article/details/49470467

BOBO_Free

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
mysql备份之Xtrabackup

Xtrabackup是一个对InnoDB,做数据备份的工具，支持在线热备份（备份时不影响数据读写），是商业备份工具InnoDB Hotbackup的一个很好的替代品。Xtrabackup中包含两个工具： * xtrabackup - 用于热备份innodb, xtradb表的工具，不能备份其他表。 * innobackupex - 对xtrabackup封装的perl脚本，
复制链接

扫一扫

专栏目录