XTRABACKUP增量备份与恢复

xtrabackup增量备份的原理是：

1)、首先完成一个完全备份，并记录下此时检查点LSN；

2)、然后增量备份时，比较表空间中每个页的LSN是否大于上次备份的LSN，若是则备份该页并记录当前检查点的LSN。

具体来说，首先在logfile中找到并记录最后一个checkpoint（“last checkpoint LSN”），然后开始从LSN的位置开始拷贝InnoDB的logfile到xtrabackup_logfile；然后开始拷贝全部的数据文件.ibd；在拷贝全部数据文件结束之后，才停止拷贝logfile。

所以xtrabackup_logfile文件在并发写入很大时也会变得很大，占用很多空间，需要注意。另外当我们使用--stream=tar或者远程备份--remote-host时默认使用/tmp，但最好显示用参数--tmpdir指定，以免把/tmp目录占满影响备份以及系统其它正常服务。

因为logfile里面记录全部的数据修改情况，所以即使在备份过程中数据文件被修改过了，恢复时仍然能够通过解析xtrabackup_logfile保持数据的一致。

xtrabackup的增量备份只能用于InnoDB表，不能用在MyISAM表上。采用增量备份MySQL数据库时xtrabackup会依据上次全备份或增量备份目录对InnoDB表进行增量备份，对MyISAM表会进行全表复制。

流备份（streaming）可以将备份直接保存到远程服务器上。

当执行恢复时，由于复制是不锁表的所以此时数据文件都是不一致的，xtrabackup使用之前保存的redo log对各个数据文件检查是否与事务日志的checkpoint一致，执行恢复：

1)、根据复制数据文件时以及之后已提交事务产生的事务日志进行前滚；

2)、将未提交的事务进行回滚。

这个过程就是MySQL数据库宕机之后执行的crash recovery。

增量备份

在InnoDB中，每个page中都记录LSN信息，每当相关数据发生改变，page的LSN就会自动增加，xtrabackup的增量备份就是依据这一原理进行的。xtrabackup将上次备份（完全备份集或者也是一个增量备份集）以来LSN改变的page进行备份。

所以，要做增量备份第一次就要做一个完全备份（就是将MySQL实例或者说要备份的数据库表做一个完全复制，同时记录LSN），之后可以基于此进行增量备份以及恢复。

增量备份优点：

1)、数据库太大没有足够的空间全量备份，增量备份能有效节省空间，并且效率高；

2)、支持热备份，备份过程不锁表（针对InnoDB而言），不阻塞数据库的读写；

3)、每日备份只产生少量数据，也可采用远程备份，节省本地空间；

4)、备份恢复基于文件操作，降低直接对数据库操作风险；

5)、备份效率更高，恢复效率更高。

恢复与还原

backup的恢复过程中包括恢复和还原两个部分。

我们前面已经说了xtrabackup只备份InnoDB表的ibd文件，而innobackupex可以备份包括InnoDB表在内的其他存储引擎的表的所有数据文件。由于不同引擎表备份时的不同，也会让恢复过程看起来不一样。

先来看看完全备份集的恢复。

在InnoDB表的备份或者更直接的说ibd数据文件复制的过程中，数据库处于不一致的状态，所以要将xtraback_logfile中尚未提交的事务进行回滚，以及将已经提交的事务进行前滚，使各个数据文件处于一个一致性状态，这个过程叫做“准备(prepare)”。

如果你是在一个从库上执行的备份，那说明你没有东西需要回滚，只是简单的apply redo log就可以了。另外在prepare过程中可以使用参数--use-memory增大使用系统内存量从而提高恢复速度。

之后，我们就可以根据backup-my.cnf中的配置把数据文件复制回对应的目录了，当然你也可以自己复制回去，但innobackupex都会帮我们完成。在这里，对于InnoDB表来说是完成“后准备”动作，我们称之为“恢复(recovery)”，而对于MyISAM表来说由于备份时是采用锁表方式复制的，所以此时只是简单的复制回来，不需要apply log，这个我们称之为“还原(restore)”。

注：本文档里之所以使用恢复和还原，也是和其他数据库比如Oracle看起来一样。

对于增量备份的恢复过程，与完全备份集的恢复类似，只是有少许不同：

1)、恢复过程需要使用完全备份集和各个增量备份集，各个备份集的恢复与前面说的一样（前滚和回滚），之后各个增量备份集的redo log都会应用到完全备份集中；

2)、对于完全备机集之后产生的新表，要有特殊处理方式，以便恢复后不丢表；

3)、要以完全备份集为基础，然后按顺序应用各个增量备份集。

[root@dba ~]#  innobackupex --user=root --password=123456 --defaults-file=/etc/my.cnf  /data/backup/hotbackup/base --no-timestamp

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013.  All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

150730 15:12:27  innobackupex: Executing a version check against the server...
150730 15:12:27  innobackupex: Connecting to MySQL server with DSN

'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'root'  (using password: YES).
150730 15:12:27  innobackupex: Connected to MySQL server
150730 15:12:27  innobackupex: Done.
150730 15:12:27  innobackupex: Connecting to MySQL server with DSN

'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'root'  (using password: YES).
150730 15:12:27  innobackupex: Connected to MySQL server
150730 15:12:27  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!".

innobackupex:  Using server version 5.6.23

innobackupex: Created backup directory /data/backup/hotbackup/base

150730 15:12:27  innobackupex: Starting ibbackup with command: xtrabackup  --defaults-file="/etc/my.cnf"  --defaults-group="mysqld" --backup

--suspend-at-end --target-dir=/data/backup/hotbackup/base --innodb_log_file_size="50331648" --innodb_data_file_path="ibdata1:12M:autoextend"

--tmpdir=/tmp --extra-lsndir='/tmp'
innobackupex: Waiting for ibbackup (pid=3991) to suspend
innobackupex: Suspend file '/data/backup/hotbackup/base/xtrabackup_suspended_2'

xtrabackup version 2.2.11 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )
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:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 50331648
>> log scanned up to (1656218)
xtrabackup: Generating a list of tablespaces
[01] Copying ./ibdata1 to /data/backup/hotbackup/base/ibdata1
[01]        ...done
[01] Copying ./test/test.ibd to /data/backup/hotbackup/base/test/test.ibd
[01]        ...done
[01] Copying ./mysql/slave_relay_log_info.ibd to /data/backup/hotbackup/base/mysql/slave_relay_log_info.ibd
[01]        ...done
[01] Copying ./mysql/innodb_table_stats.ibd to /data/backup/hotbackup/base/mysql/innodb_table_stats.ibd
[01]        ...done
[01] Copying ./mysql/innodb_index_stats.ibd to /data/backup/hotbackup/base/mysql/innodb_index_stats.ibd
[01]        ...done
[01] Copying ./mysql/slave_master_info.ibd to /data/backup/hotbackup/base/mysql/slave_master_info.ibd
[01]        ...done
>> log scanned up to (1656218)
[01] Copying ./mysql/slave_worker_info.ibd to /data/backup/hotbackup/base/mysql/slave_worker_info.ibd
[01]        ...done
xtrabackup: Creating suspend file '/data/backup/hotbackup/base/xtrabackup_suspended_2' with pid '3991'

150730 15:12:29  innobackupex: Continuing after ibbackup has suspended
150730 15:12:29  innobackupex: Executing FLUSH TABLES...
150730 15:12:29  innobackupex: Executing FLUSH TABLES WITH READ LOCK...
150730 15:12:29  innobackupex: All tables locked and flushed to disk

150730 15:12:29  innobackupex: Starting to backup non-InnoDB tables and files
innobackupex: in subdirectories of '/var/lib/mysql/'
innobackupex: Backing up files '/var/lib/mysql//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (53

files)
>> log scanned up to (1656218)
innobackupex: Backing up file '/var/lib/mysql//test/test.frm'
innobackupex: Backing up files '/var/lib/mysql//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (74 files)
150730 15:12:29  innobackupex: Finished backing up non-InnoDB tables and files

150730 15:12:29  innobackupex: Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
150730 15:12:29  innobackupex: Waiting for log copying to finish

xtrabackup: The latest check point (for incremental): '1656218'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (1656218)

xtrabackup: Creating suspend file '/data/backup/hotbackup/base/xtrabackup_log_copied' with pid '3991'
xtrabackup: Transaction log of lsn (1656218) to (1656218) was copied.
150730 15:12:30  innobackupex: All tables unlocked

innobackupex: Backup created in directory '/data/backup/hotbackup/base'
150730 15:12:30  innobackupex: Connection to database server closed
150730 15:12:30  innobackupex: completed OK!

mysql> insert into test (name) values ('test13');
Query OK, 1 row affected (0.01 sec)

mysql> insert into test (name) values ('test14');
Query OK, 1 row affected (0.08 sec)

[root@dba ~]# innobackupex --user=root --password=123456 --defaults-file=/etc/my.cnf --incremental /data/backup/hotbackup/incremental_one --

incremental-basedir=/data/backup/hotbackup/base --no-timestamp --parallel=2

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013.  All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

150730 15:16:25  innobackupex: Executing a version check against the server...
150730 15:16:25  innobackupex: Connecting to MySQL server with DSN

'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'root'  (using password: YES).
150730 15:16:25  innobackupex: Connected to MySQL server
150730 15:16:25  innobackupex: Done.
150730 15:16:25  innobackupex: Connecting to MySQL server with DSN

'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'root'  (using password: YES).
150730 15:16:25  innobackupex: Connected to MySQL server
150730 15:16:25  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!".

innobackupex:  Using server version 5.6.23

innobackupex: Created backup directory /data/backup/hotbackup/incremental_one

150730 15:16:25  innobackupex: Starting ibbackup with command: xtrabackup  --defaults-file="/etc/my.cnf"  --defaults-group="mysqld" --backup

--suspend-at-end --target-dir=/data/backup/hotbackup/incremental_one --innodb_log_file_size="50331648" --

innodb_data_file_path="ibdata1:12M:autoextend" --tmpdir=/tmp --extra-lsndir='/tmp' --incremental-basedir='/data/backup/hotbackup/base' --

parallel=2
innobackupex: Waiting for ibbackup (pid=4156) to suspend
innobackupex: Suspend file '/data/backup/hotbackup/incremental_one/xtrabackup_suspended_2'

xtrabackup version 2.2.11 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )
incremental backup from 1656218 is enabled.
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:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 50331648
>> log scanned up to (1656420)
xtrabackup: Generating a list of tablespaces
xtrabackup: using the full scan for incremental backup
xtrabackup: Starting 2 threads for parallel data files transfer
[02] Copying ./ibdata1 to /data/backup/hotbackup/incremental_one/ibdata1.delta
[01] Copying ./test/test.ibd to /data/backup/hotbackup/incremental_one/test/test.ibd.delta
[01]        ...done
[02]        ...done
[01] Copying ./mysql/slave_relay_log_info.ibd to /data/backup/hotbackup/incremental_one/mysql/slave_relay_log_info.ibd.delta
[01]        ...done
[02] Copying ./mysql/innodb_table_stats.ibd to /data/backup/hotbackup/incremental_one/mysql/innodb_table_stats.ibd.delta
[02]        ...done
[01] Copying ./mysql/innodb_index_stats.ibd to /data/backup/hotbackup/incremental_one/mysql/innodb_index_stats.ibd.delta
[01]        ...done
[02] Copying ./mysql/slave_master_info.ibd to /data/backup/hotbackup/incremental_one/mysql/slave_master_info.ibd.delta
[02]        ...done
[01] Copying ./mysql/slave_worker_info.ibd to /data/backup/hotbackup/incremental_one/mysql/slave_worker_info.ibd.delta
[01]        ...done
>> log scanned up to (1656420)
xtrabackup: Creating suspend file '/data/backup/hotbackup/incremental_one/xtrabackup_suspended_2' with pid '4156'

150730 15:16:27  innobackupex: Continuing after ibbackup has suspended
150730 15:16:27  innobackupex: Executing FLUSH TABLES...
150730 15:16:27  innobackupex: Executing FLUSH TABLES WITH READ LOCK...
150730 15:16:27  innobackupex: All tables locked and flushed to disk

150730 15:16:27  innobackupex: Starting to backup non-InnoDB tables and files
innobackupex: in subdirectories of '/var/lib/mysql/'
innobackupex: Backing up files '/var/lib/mysql//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (53

files)
>> log scanned up to (1656420)
innobackupex: Backing up file '/var/lib/mysql//test/test.frm'
innobackupex: Backing up files '/var/lib/mysql//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (74 files)
150730 15:16:27  innobackupex: Finished backing up non-InnoDB tables and files

150730 15:16:27  innobackupex: Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
150730 15:16:27  innobackupex: Waiting for log copying to finish

xtrabackup: The latest check point (for incremental): '1656420'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (1656420)

xtrabackup: Creating suspend file '/data/backup/hotbackup/incremental_one/xtrabackup_log_copied' with pid '4156'
xtrabackup: Transaction log of lsn (1656420) to (1656420) was copied.
150730 15:16:28  innobackupex: All tables unlocked

innobackupex: Backup created in directory '/data/backup/hotbackup/incremental_one'
150730 15:16:28  innobackupex: Connection to database server closed
150730 15:16:28  innobackupex: completed OK!

mysql> insert into test (name) values ('test15');
Query OK, 1 row affected (0.01 sec)

mysql> insert into test (name) values ('test16');
Query OK, 1 row affected (0.00 sec)

[root@dba ~]# innobackupex --user=root --password=123456 --defaults-file=/etc/my.cnf --incremental /data/backup/hotbackup/incremental_two --

incremental-basedir=/data/backup/hotbackup/incremental_one --no-timestamp --parallel=2

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013.  All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

150730 15:17:50  innobackupex: Executing a version check against the server...
150730 15:17:50  innobackupex: Connecting to MySQL server with DSN

'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'root'  (using password: YES).
150730 15:17:50  innobackupex: Connected to MySQL server
150730 15:17:50  innobackupex: Done.
150730 15:17:50  innobackupex: Connecting to MySQL server with DSN

'dbi:mysql:;mysql_read_default_file=/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'root'  (using password: YES).
150730 15:17:50  innobackupex: Connected to MySQL server
150730 15:17:50  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!".

innobackupex:  Using server version 5.6.23

innobackupex: Created backup directory /data/backup/hotbackup/incremental_two

150730 15:17:50  innobackupex: Starting ibbackup with command: xtrabackup  --defaults-file="/etc/my.cnf"  --defaults-group="mysqld" --backup

--suspend-at-end --target-dir=/data/backup/hotbackup/incremental_two --innodb_log_file_size="50331648" --

innodb_data_file_path="ibdata1:12M:autoextend" --tmpdir=/tmp --extra-lsndir='/tmp' --incremental-

basedir='/data/backup/hotbackup/incremental_one' --parallel=2
innobackupex: Waiting for ibbackup (pid=4304) to suspend
innobackupex: Suspend file '/data/backup/hotbackup/incremental_two/xtrabackup_suspended_2'

xtrabackup version 2.2.11 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )
incremental backup from 1656420 is enabled.
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:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 50331648
>> log scanned up to (1656606)
xtrabackup: Generating a list of tablespaces
xtrabackup: using the full scan for incremental backup
xtrabackup: Starting 2 threads for parallel data files transfer
[02] Copying ./ibdata1 to /data/backup/hotbackup/incremental_two/ibdata1.delta
[01] Copying ./test/test.ibd to /data/backup/hotbackup/incremental_two/test/test.ibd.delta
[01]        ...done
[02]        ...done
[01] Copying ./mysql/slave_relay_log_info.ibd to /data/backup/hotbackup/incremental_two/mysql/slave_relay_log_info.ibd.delta
[01]        ...done
[02] Copying ./mysql/innodb_table_stats.ibd to /data/backup/hotbackup/incremental_two/mysql/innodb_table_stats.ibd.delta
[02]        ...done
[01] Copying ./mysql/innodb_index_stats.ibd to /data/backup/hotbackup/incremental_two/mysql/innodb_index_stats.ibd.delta
[01]        ...done
[02] Copying ./mysql/slave_master_info.ibd to /data/backup/hotbackup/incremental_two/mysql/slave_master_info.ibd.delta
[02]        ...done
[01] Copying ./mysql/slave_worker_info.ibd to /data/backup/hotbackup/incremental_two/mysql/slave_worker_info.ibd.delta
[01]        ...done
>> log scanned up to (1656606)
xtrabackup: Creating suspend file '/data/backup/hotbackup/incremental_two/xtrabackup_suspended_2' with pid '4304'

150730 15:17:52  innobackupex: Continuing after ibbackup has suspended
150730 15:17:52  innobackupex: Executing FLUSH TABLES...
150730 15:17:52  innobackupex: Executing FLUSH TABLES WITH READ LOCK...
150730 15:17:52  innobackupex: All tables locked and flushed to disk

150730 15:17:52  innobackupex: Starting to backup non-InnoDB tables and files
innobackupex: in subdirectories of '/var/lib/mysql/'
innobackupex: Backing up files '/var/lib/mysql//performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (53

files)
>> log scanned up to (1656606)
innobackupex: Backing up file '/var/lib/mysql//test/test.frm'
innobackupex: Backing up files '/var/lib/mysql//mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (74 files)
150730 15:17:53  innobackupex: Finished backing up non-InnoDB tables and files

150730 15:17:53  innobackupex: Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
150730 15:17:53  innobackupex: Waiting for log copying to finish

xtrabackup: The latest check point (for incremental): '1656606'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (1656606)

xtrabackup: Creating suspend file '/data/backup/hotbackup/incremental_two/xtrabackup_log_copied' with pid '4304'
xtrabackup: Transaction log of lsn (1656606) to (1656606) was copied.
150730 15:17:54  innobackupex: All tables unlocked

innobackupex: Backup created in directory '/data/backup/hotbackup/incremental_two'
150730 15:17:54  innobackupex: Connection to database server closed
150730 15:17:54  innobackupex: completed OK!

xtrabackup  --defaults-file="/etc/my.cnf"  --defaults-group="mysqld"  --target-dir=/data/backup/hotbackup/base --apply-log --redo-only --

use-memory=1G

[root@dba ~]# innobackupex  --defaults-file="/etc/my.cnf" --apply-log --redo-only --use-memory=1G /data/backup/hotbackup/base

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013.  All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

150730 15:24:37  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!".

150730 15:24:37  innobackupex: Starting ibbackup with command: xtrabackup  --defaults-file="/data/backup/hotbackup/base/backup-my.cnf"  --

defaults-group="mysqld" --prepare --target-dir=/data/backup/hotbackup/base --apply-log-only --use-memory=1G

xtrabackup version 2.2.11 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )
xtrabackup: cd to /data/backup/hotbackup/base
xtrabackup: This target seems to be not prepared yet.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(1656218)
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:12M: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: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: Not 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 1656208 and 1656208 in ibdata files do not match the log sequence number 1656218 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...

[notice (again)]
  If you use binary log and don't use any hack of group commit,
  the binary log position seems to be:

xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 1656218
150730 15:24:38  innobackupex: completed OK!

[root@dba hotbackup]# du -sh ./*
17M ./base
2.0M ./incremental_one
2.0M ./incremental_two

[root@dba ~]# innobackupex  --apply-log --redo-only --use-memory=1G /data/backup/hotbackup/base  --incremental-

dir=/data/backup/hotbackup/incremental_one

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013.  All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

150730 15:37:28  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!".

150730 15:37:28  innobackupex: Starting ibbackup with command: xtrabackup  --defaults-file="/data/backup/hotbackup/base/backup-my.cnf"  --

defaults-group="mysqld" --prepare --target-dir=/data/backup/hotbackup/base --apply-log-only --use-memory=1G --incremental-

dir=/data/backup/hotbackup/incremental_one

xtrabackup version 2.2.11 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )
incremental backup from 1656218 is enabled.
xtrabackup: cd to /data/backup/hotbackup/base
xtrabackup: This target seems to be already prepared with --apply-log-only.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(1656420)
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup:   innodb_log_group_home_dir = /data/backup/hotbackup/incremental_one
xtrabackup:   innodb_log_files_in_group = 1
xtrabackup:   innodb_log_file_size = 2097152
xtrabackup: Generating a list of tablespaces
xtrabackup: page size for /data/backup/hotbackup/incremental_one/ibdata1.delta is 16384 bytes
Applying /data/backup/hotbackup/incremental_one/ibdata1.delta to ./ibdata1...
xtrabackup: page size for /data/backup/hotbackup/incremental_one/test/test.ibd.delta is 16384 bytes
Applying /data/backup/hotbackup/incremental_one/test/test.ibd.delta to ./test/test.ibd...
xtrabackup: page size for /data/backup/hotbackup/incremental_one/mysql/slave_master_info.ibd.delta is 16384 bytes
Applying /data/backup/hotbackup/incremental_one/mysql/slave_master_info.ibd.delta to ./mysql/slave_master_info.ibd...
xtrabackup: page size for /data/backup/hotbackup/incremental_one/mysql/slave_relay_log_info.ibd.delta is 16384 bytes
Applying /data/backup/hotbackup/incremental_one/mysql/slave_relay_log_info.ibd.delta to ./mysql/slave_relay_log_info.ibd...
xtrabackup: page size for /data/backup/hotbackup/incremental_one/mysql/innodb_table_stats.ibd.delta is 16384 bytes
Applying /data/backup/hotbackup/incremental_one/mysql/innodb_table_stats.ibd.delta to ./mysql/innodb_table_stats.ibd...
xtrabackup: page size for /data/backup/hotbackup/incremental_one/mysql/slave_worker_info.ibd.delta is 16384 bytes
Applying /data/backup/hotbackup/incremental_one/mysql/slave_worker_info.ibd.delta to ./mysql/slave_worker_info.ibd...
xtrabackup: page size for /data/backup/hotbackup/incremental_one/mysql/innodb_index_stats.ibd.delta is 16384 bytes
Applying /data/backup/hotbackup/incremental_one/mysql/innodb_index_stats.ibd.delta to ./mysql/innodb_index_stats.ibd...
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup:   innodb_log_group_home_dir = /data/backup/hotbackup/incremental_one
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: Not 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 1656332 and 1656332 in ibdata files do not match the log sequence number 1656420 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...

[notice (again)]
  If you use binary log and don't use any hack of group commit,
  the binary log position seems to be:

xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 1656420
innobackupex: Starting to copy non-InnoDB files in '/data/backup/hotbackup/incremental_one'
innobackupex: to the full backup directory '/data/backup/hotbackup/base'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/xtrabackup_info' to '/data/backup/hotbackup/base/xtrabackup_info'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/socket_summary_by_instance.frm' to

'/data/backup/hotbackup/base/performance_schema/socket_summary_by_instance.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_statements_summary_by_account_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_summary_by_account_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/rwlock_instances.frm' to

'/data/backup/hotbackup/base/performance_schema/rwlock_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_waits_current.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_current.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_waits_summary_by_instance.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_summary_by_instance.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_waits_history.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_history.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/table_lock_waits_summary_by_table.frm' to

'/data/backup/hotbackup/base/performance_schema/table_lock_waits_summary_by_table.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_waits_history_long.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_history_long.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/session_account_connect_attrs.frm' to

'/data/backup/hotbackup/base/performance_schema/session_account_connect_attrs.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_statements_summary_by_user_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_summary_by_user_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/host_cache.frm' to

'/data/backup/hotbackup/base/performance_schema/host_cache.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/session_connect_attrs.frm' to

'/data/backup/hotbackup/base/performance_schema/session_connect_attrs.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_waits_summary_by_thread_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_summary_by_thread_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/performance_timers.frm' to

'/data/backup/hotbackup/base/performance_schema/performance_timers.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/setup_actors.frm' to

'/data/backup/hotbackup/base/performance_schema/setup_actors.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/hosts.frm' to

'/data/backup/hotbackup/base/performance_schema/hosts.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/socket_instances.frm' to

'/data/backup/hotbackup/base/performance_schema/socket_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_statements_history.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_history.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/table_io_waits_summary_by_index_usage.frm' to

'/data/backup/hotbackup/base/performance_schema/table_io_waits_summary_by_index_usage.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/setup_instruments.frm' to

'/data/backup/hotbackup/base/performance_schema/setup_instruments.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_statements_current.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_current.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/setup_objects.frm' to

'/data/backup/hotbackup/base/performance_schema/setup_objects.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_waits_summary_global_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_summary_global_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/users.frm' to

'/data/backup/hotbackup/base/performance_schema/users.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/objects_summary_global_by_type.frm' to

'/data/backup/hotbackup/base/performance_schema/objects_summary_global_by_type.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/file_summary_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/file_summary_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/cond_instances.frm' to

'/data/backup/hotbackup/base/performance_schema/cond_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_stages_summary_by_thread_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_summary_by_thread_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_stages_current.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_current.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_statements_summary_by_digest.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_summary_by_digest.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_stages_summary_global_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_summary_global_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_statements_summary_global_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_summary_global_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_waits_summary_by_account_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_summary_by_account_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_stages_history.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_history.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/file_instances.frm' to

'/data/backup/hotbackup/base/performance_schema/file_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_stages_summary_by_host_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_summary_by_host_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_stages_summary_by_user_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_summary_by_user_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_stages_history_long.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_history_long.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_statements_history_long.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_history_long.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/table_io_waits_summary_by_table.frm' to

'/data/backup/hotbackup/base/performance_schema/table_io_waits_summary_by_table.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/setup_consumers.frm' to

'/data/backup/hotbackup/base/performance_schema/setup_consumers.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/accounts.frm' to

'/data/backup/hotbackup/base/performance_schema/accounts.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_waits_summary_by_host_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_summary_by_host_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/threads.frm' to

'/data/backup/hotbackup/base/performance_schema/threads.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_stages_summary_by_account_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_summary_by_account_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/file_summary_by_instance.frm' to

'/data/backup/hotbackup/base/performance_schema/file_summary_by_instance.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/socket_summary_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/socket_summary_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/setup_timers.frm' to

'/data/backup/hotbackup/base/performance_schema/setup_timers.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_statements_summary_by_host_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_summary_by_host_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/db.opt' to

'/data/backup/hotbackup/base/performance_schema/db.opt'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_waits_summary_by_user_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_summary_by_user_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/mutex_instances.frm' to

'/data/backup/hotbackup/base/performance_schema/mutex_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/performance_schema/events_statements_summary_by_thread_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_summary_by_thread_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/test/test.frm' to '/data/backup/hotbackup/base/test/test.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/func.frm' to '/data/backup/hotbackup/base/mysql/func.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/db.MYD' to '/data/backup/hotbackup/base/mysql/db.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/help_category.MYI' to

'/data/backup/hotbackup/base/mysql/help_category.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/help_relation.frm' to

'/data/backup/hotbackup/base/mysql/help_relation.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone_transition.MYI' to

'/data/backup/hotbackup/base/mysql/time_zone_transition.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone_leap_second.MYD' to

'/data/backup/hotbackup/base/mysql/time_zone_leap_second.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/servers.MYD' to '/data/backup/hotbackup/base/mysql/servers.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/ndb_binlog_index.MYI' to

'/data/backup/hotbackup/base/mysql/ndb_binlog_index.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/servers.frm' to '/data/backup/hotbackup/base/mysql/servers.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone_transition.frm' to

'/data/backup/hotbackup/base/mysql/time_zone_transition.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/db.frm' to '/data/backup/hotbackup/base/mysql/db.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/event.MYD' to '/data/backup/hotbackup/base/mysql/event.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/db.MYI' to '/data/backup/hotbackup/base/mysql/db.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/proxies_priv.frm' to '/data/backup/hotbackup/base/mysql/proxies_priv.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone_transition_type.MYD' to

'/data/backup/hotbackup/base/mysql/time_zone_transition_type.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/help_topic.MYD' to '/data/backup/hotbackup/base/mysql/help_topic.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/servers.MYI' to '/data/backup/hotbackup/base/mysql/servers.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/help_keyword.MYD' to '/data/backup/hotbackup/base/mysql/help_keyword.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/ndb_binlog_index.MYD' to

'/data/backup/hotbackup/base/mysql/ndb_binlog_index.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/user.MYI' to '/data/backup/hotbackup/base/mysql/user.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/innodb_index_stats.frm' to

'/data/backup/hotbackup/base/mysql/innodb_index_stats.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/general_log.CSM' to '/data/backup/hotbackup/base/mysql/general_log.CSM'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/columns_priv.MYD' to '/data/backup/hotbackup/base/mysql/columns_priv.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/help_topic.MYI' to '/data/backup/hotbackup/base/mysql/help_topic.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/func.MYD' to '/data/backup/hotbackup/base/mysql/func.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/tables_priv.frm' to '/data/backup/hotbackup/base/mysql/tables_priv.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/innodb_table_stats.frm' to

'/data/backup/hotbackup/base/mysql/innodb_table_stats.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/tables_priv.MYD' to '/data/backup/hotbackup/base/mysql/tables_priv.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/help_topic.frm' to '/data/backup/hotbackup/base/mysql/help_topic.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/general_log.frm' to '/data/backup/hotbackup/base/mysql/general_log.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/slave_relay_log_info.frm' to

'/data/backup/hotbackup/base/mysql/slave_relay_log_info.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone_leap_second.frm' to

'/data/backup/hotbackup/base/mysql/time_zone_leap_second.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone_transition_type.MYI' to

'/data/backup/hotbackup/base/mysql/time_zone_transition_type.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/help_keyword.MYI' to '/data/backup/hotbackup/base/mysql/help_keyword.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/help_relation.MYD' to

'/data/backup/hotbackup/base/mysql/help_relation.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/event.frm' to '/data/backup/hotbackup/base/mysql/event.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/plugin.frm' to '/data/backup/hotbackup/base/mysql/plugin.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone_leap_second.MYI' to

'/data/backup/hotbackup/base/mysql/time_zone_leap_second.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/plugin.MYD' to '/data/backup/hotbackup/base/mysql/plugin.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/slow_log.CSV' to '/data/backup/hotbackup/base/mysql/slow_log.CSV'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/ndb_binlog_index.frm' to

'/data/backup/hotbackup/base/mysql/ndb_binlog_index.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone_transition.MYD' to

'/data/backup/hotbackup/base/mysql/time_zone_transition.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone_name.MYD' to

'/data/backup/hotbackup/base/mysql/time_zone_name.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone.frm' to '/data/backup/hotbackup/base/mysql/time_zone.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/func.MYI' to '/data/backup/hotbackup/base/mysql/func.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/tables_priv.MYI' to '/data/backup/hotbackup/base/mysql/tables_priv.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/procs_priv.MYI' to '/data/backup/hotbackup/base/mysql/procs_priv.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/columns_priv.frm' to '/data/backup/hotbackup/base/mysql/columns_priv.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/help_keyword.frm' to '/data/backup/hotbackup/base/mysql/help_keyword.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/procs_priv.MYD' to '/data/backup/hotbackup/base/mysql/procs_priv.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/procs_priv.frm' to '/data/backup/hotbackup/base/mysql/procs_priv.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone_transition_type.frm' to

'/data/backup/hotbackup/base/mysql/time_zone_transition_type.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/help_category.frm' to

'/data/backup/hotbackup/base/mysql/help_category.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/proc.MYI' to '/data/backup/hotbackup/base/mysql/proc.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/proc.MYD' to '/data/backup/hotbackup/base/mysql/proc.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/general_log.CSV' to '/data/backup/hotbackup/base/mysql/general_log.CSV'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/plugin.MYI' to '/data/backup/hotbackup/base/mysql/plugin.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/proc.frm' to '/data/backup/hotbackup/base/mysql/proc.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/slave_master_info.frm' to

'/data/backup/hotbackup/base/mysql/slave_master_info.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/help_category.MYD' to

'/data/backup/hotbackup/base/mysql/help_category.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/proxies_priv.MYD' to '/data/backup/hotbackup/base/mysql/proxies_priv.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/slow_log.CSM' to '/data/backup/hotbackup/base/mysql/slow_log.CSM'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/event.MYI' to '/data/backup/hotbackup/base/mysql/event.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/slave_worker_info.frm' to

'/data/backup/hotbackup/base/mysql/slave_worker_info.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/slow_log.frm' to '/data/backup/hotbackup/base/mysql/slow_log.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/user.frm' to '/data/backup/hotbackup/base/mysql/user.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone.MYD' to '/data/backup/hotbackup/base/mysql/time_zone.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/user.MYD' to '/data/backup/hotbackup/base/mysql/user.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone_name.MYI' to

'/data/backup/hotbackup/base/mysql/time_zone_name.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone_name.frm' to

'/data/backup/hotbackup/base/mysql/time_zone_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/proxies_priv.MYI' to '/data/backup/hotbackup/base/mysql/proxies_priv.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/help_relation.MYI' to

'/data/backup/hotbackup/base/mysql/help_relation.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/columns_priv.MYI' to '/data/backup/hotbackup/base/mysql/columns_priv.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_one/mysql/time_zone.MYI' to '/data/backup/hotbackup/base/mysql/time_zone.MYI'
150730 15:37:29  innobackupex: completed OK!

[root@dba ~]# innobackupex  --apply-log --use-memory=1G /data/backup/hotbackup/base  --incremental-dir=/data/backup/hotbackup/incremental_two

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013.  All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

150730 15:39:46  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!".

150730 15:39:46  innobackupex: Starting ibbackup with command: xtrabackup  --defaults-file="/data/backup/hotbackup/base/backup-my.cnf"  --

defaults-group="mysqld" --prepare --target-dir=/data/backup/hotbackup/base --use-memory=1G --incremental-

dir=/data/backup/hotbackup/incremental_two

xtrabackup version 2.2.11 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )
incremental backup from 1656420 is enabled.
xtrabackup: cd to /data/backup/hotbackup/base
xtrabackup: This target seems to be already prepared with --apply-log-only.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(1656606)
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup:   innodb_log_group_home_dir = /data/backup/hotbackup/incremental_two
xtrabackup:   innodb_log_files_in_group = 1
xtrabackup:   innodb_log_file_size = 2097152
xtrabackup: Generating a list of tablespaces
xtrabackup: page size for /data/backup/hotbackup/incremental_two/ibdata1.delta is 16384 bytes
Applying /data/backup/hotbackup/incremental_two/ibdata1.delta to ./ibdata1...
xtrabackup: page size for /data/backup/hotbackup/incremental_two/test/test.ibd.delta is 16384 bytes
Applying /data/backup/hotbackup/incremental_two/test/test.ibd.delta to ./test/test.ibd...
xtrabackup: page size for /data/backup/hotbackup/incremental_two/mysql/slave_master_info.ibd.delta is 16384 bytes
Applying /data/backup/hotbackup/incremental_two/mysql/slave_master_info.ibd.delta to ./mysql/slave_master_info.ibd...
xtrabackup: page size for /data/backup/hotbackup/incremental_two/mysql/slave_relay_log_info.ibd.delta is 16384 bytes
Applying /data/backup/hotbackup/incremental_two/mysql/slave_relay_log_info.ibd.delta to ./mysql/slave_relay_log_info.ibd...
xtrabackup: page size for /data/backup/hotbackup/incremental_two/mysql/innodb_table_stats.ibd.delta is 16384 bytes
Applying /data/backup/hotbackup/incremental_two/mysql/innodb_table_stats.ibd.delta to ./mysql/innodb_table_stats.ibd...
xtrabackup: page size for /data/backup/hotbackup/incremental_two/mysql/slave_worker_info.ibd.delta is 16384 bytes
Applying /data/backup/hotbackup/incremental_two/mysql/slave_worker_info.ibd.delta to ./mysql/slave_worker_info.ibd...
xtrabackup: page size for /data/backup/hotbackup/incremental_two/mysql/innodb_index_stats.ibd.delta is 16384 bytes
Applying /data/backup/hotbackup/incremental_two/mysql/innodb_index_stats.ibd.delta to ./mysql/innodb_index_stats.ibd...
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup:   innodb_log_group_home_dir = /data/backup/hotbackup/incremental_two
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: Not 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 1656420 and 1656420 in ibdata files do not match the log sequence number 1656606 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 1656606

[notice (again)]
  If you use binary log and don't use any hack of group commit,
  the binary log position seems to be:

xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 1656616
innobackupex: Starting to copy non-InnoDB files in '/data/backup/hotbackup/incremental_two'
innobackupex: to the full backup directory '/data/backup/hotbackup/base'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/xtrabackup_info' to '/data/backup/hotbackup/base/xtrabackup_info'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/socket_summary_by_instance.frm' to

'/data/backup/hotbackup/base/performance_schema/socket_summary_by_instance.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_statements_summary_by_account_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_summary_by_account_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/rwlock_instances.frm' to

'/data/backup/hotbackup/base/performance_schema/rwlock_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_waits_current.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_current.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_waits_summary_by_instance.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_summary_by_instance.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_waits_history.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_history.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/table_lock_waits_summary_by_table.frm' to

'/data/backup/hotbackup/base/performance_schema/table_lock_waits_summary_by_table.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_waits_history_long.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_history_long.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/session_account_connect_attrs.frm' to

'/data/backup/hotbackup/base/performance_schema/session_account_connect_attrs.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_statements_summary_by_user_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_summary_by_user_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/host_cache.frm' to

'/data/backup/hotbackup/base/performance_schema/host_cache.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/session_connect_attrs.frm' to

'/data/backup/hotbackup/base/performance_schema/session_connect_attrs.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_waits_summary_by_thread_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_summary_by_thread_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/performance_timers.frm' to

'/data/backup/hotbackup/base/performance_schema/performance_timers.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/setup_actors.frm' to

'/data/backup/hotbackup/base/performance_schema/setup_actors.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/hosts.frm' to

'/data/backup/hotbackup/base/performance_schema/hosts.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/socket_instances.frm' to

'/data/backup/hotbackup/base/performance_schema/socket_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_statements_history.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_history.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/table_io_waits_summary_by_index_usage.frm' to

'/data/backup/hotbackup/base/performance_schema/table_io_waits_summary_by_index_usage.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/setup_instruments.frm' to

'/data/backup/hotbackup/base/performance_schema/setup_instruments.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_statements_current.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_current.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/setup_objects.frm' to

'/data/backup/hotbackup/base/performance_schema/setup_objects.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_waits_summary_global_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_summary_global_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/users.frm' to

'/data/backup/hotbackup/base/performance_schema/users.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/objects_summary_global_by_type.frm' to

'/data/backup/hotbackup/base/performance_schema/objects_summary_global_by_type.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/file_summary_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/file_summary_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/cond_instances.frm' to

'/data/backup/hotbackup/base/performance_schema/cond_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_stages_summary_by_thread_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_summary_by_thread_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_stages_current.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_current.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_statements_summary_by_digest.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_summary_by_digest.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_stages_summary_global_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_summary_global_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_statements_summary_global_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_summary_global_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_waits_summary_by_account_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_summary_by_account_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_stages_history.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_history.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/file_instances.frm' to

'/data/backup/hotbackup/base/performance_schema/file_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_stages_summary_by_host_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_summary_by_host_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_stages_summary_by_user_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_summary_by_user_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_stages_history_long.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_history_long.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_statements_history_long.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_history_long.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/table_io_waits_summary_by_table.frm' to

'/data/backup/hotbackup/base/performance_schema/table_io_waits_summary_by_table.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/setup_consumers.frm' to

'/data/backup/hotbackup/base/performance_schema/setup_consumers.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/accounts.frm' to

'/data/backup/hotbackup/base/performance_schema/accounts.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_waits_summary_by_host_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_summary_by_host_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/threads.frm' to

'/data/backup/hotbackup/base/performance_schema/threads.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_stages_summary_by_account_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_stages_summary_by_account_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/file_summary_by_instance.frm' to

'/data/backup/hotbackup/base/performance_schema/file_summary_by_instance.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/socket_summary_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/socket_summary_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/setup_timers.frm' to

'/data/backup/hotbackup/base/performance_schema/setup_timers.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_statements_summary_by_host_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_summary_by_host_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/db.opt' to

'/data/backup/hotbackup/base/performance_schema/db.opt'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_waits_summary_by_user_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_waits_summary_by_user_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/mutex_instances.frm' to

'/data/backup/hotbackup/base/performance_schema/mutex_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/performance_schema/events_statements_summary_by_thread_by_event_name.frm' to

'/data/backup/hotbackup/base/performance_schema/events_statements_summary_by_thread_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/test/test.frm' to '/data/backup/hotbackup/base/test/test.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/func.frm' to '/data/backup/hotbackup/base/mysql/func.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/db.MYD' to '/data/backup/hotbackup/base/mysql/db.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/help_category.MYI' to

'/data/backup/hotbackup/base/mysql/help_category.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/help_relation.frm' to

'/data/backup/hotbackup/base/mysql/help_relation.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone_transition.MYI' to

'/data/backup/hotbackup/base/mysql/time_zone_transition.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone_leap_second.MYD' to

'/data/backup/hotbackup/base/mysql/time_zone_leap_second.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/servers.MYD' to '/data/backup/hotbackup/base/mysql/servers.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/ndb_binlog_index.MYI' to

'/data/backup/hotbackup/base/mysql/ndb_binlog_index.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/servers.frm' to '/data/backup/hotbackup/base/mysql/servers.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone_transition.frm' to

'/data/backup/hotbackup/base/mysql/time_zone_transition.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/db.frm' to '/data/backup/hotbackup/base/mysql/db.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/event.MYD' to '/data/backup/hotbackup/base/mysql/event.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/db.MYI' to '/data/backup/hotbackup/base/mysql/db.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/proxies_priv.frm' to '/data/backup/hotbackup/base/mysql/proxies_priv.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone_transition_type.MYD' to

'/data/backup/hotbackup/base/mysql/time_zone_transition_type.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/help_topic.MYD' to '/data/backup/hotbackup/base/mysql/help_topic.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/servers.MYI' to '/data/backup/hotbackup/base/mysql/servers.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/help_keyword.MYD' to '/data/backup/hotbackup/base/mysql/help_keyword.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/ndb_binlog_index.MYD' to

'/data/backup/hotbackup/base/mysql/ndb_binlog_index.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/user.MYI' to '/data/backup/hotbackup/base/mysql/user.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/innodb_index_stats.frm' to

'/data/backup/hotbackup/base/mysql/innodb_index_stats.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/general_log.CSM' to '/data/backup/hotbackup/base/mysql/general_log.CSM'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/columns_priv.MYD' to '/data/backup/hotbackup/base/mysql/columns_priv.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/help_topic.MYI' to '/data/backup/hotbackup/base/mysql/help_topic.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/func.MYD' to '/data/backup/hotbackup/base/mysql/func.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/tables_priv.frm' to '/data/backup/hotbackup/base/mysql/tables_priv.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/innodb_table_stats.frm' to

'/data/backup/hotbackup/base/mysql/innodb_table_stats.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/tables_priv.MYD' to '/data/backup/hotbackup/base/mysql/tables_priv.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/help_topic.frm' to '/data/backup/hotbackup/base/mysql/help_topic.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/general_log.frm' to '/data/backup/hotbackup/base/mysql/general_log.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/slave_relay_log_info.frm' to

'/data/backup/hotbackup/base/mysql/slave_relay_log_info.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone_leap_second.frm' to

'/data/backup/hotbackup/base/mysql/time_zone_leap_second.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone_transition_type.MYI' to

'/data/backup/hotbackup/base/mysql/time_zone_transition_type.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/help_keyword.MYI' to '/data/backup/hotbackup/base/mysql/help_keyword.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/help_relation.MYD' to

'/data/backup/hotbackup/base/mysql/help_relation.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/event.frm' to '/data/backup/hotbackup/base/mysql/event.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/plugin.frm' to '/data/backup/hotbackup/base/mysql/plugin.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone_leap_second.MYI' to

'/data/backup/hotbackup/base/mysql/time_zone_leap_second.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/plugin.MYD' to '/data/backup/hotbackup/base/mysql/plugin.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/slow_log.CSV' to '/data/backup/hotbackup/base/mysql/slow_log.CSV'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/ndb_binlog_index.frm' to

'/data/backup/hotbackup/base/mysql/ndb_binlog_index.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone_transition.MYD' to

'/data/backup/hotbackup/base/mysql/time_zone_transition.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone_name.MYD' to

'/data/backup/hotbackup/base/mysql/time_zone_name.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone.frm' to '/data/backup/hotbackup/base/mysql/time_zone.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/func.MYI' to '/data/backup/hotbackup/base/mysql/func.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/tables_priv.MYI' to '/data/backup/hotbackup/base/mysql/tables_priv.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/procs_priv.MYI' to '/data/backup/hotbackup/base/mysql/procs_priv.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/columns_priv.frm' to '/data/backup/hotbackup/base/mysql/columns_priv.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/help_keyword.frm' to '/data/backup/hotbackup/base/mysql/help_keyword.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/procs_priv.MYD' to '/data/backup/hotbackup/base/mysql/procs_priv.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/procs_priv.frm' to '/data/backup/hotbackup/base/mysql/procs_priv.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone_transition_type.frm' to

'/data/backup/hotbackup/base/mysql/time_zone_transition_type.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/help_category.frm' to

'/data/backup/hotbackup/base/mysql/help_category.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/proc.MYI' to '/data/backup/hotbackup/base/mysql/proc.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/proc.MYD' to '/data/backup/hotbackup/base/mysql/proc.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/general_log.CSV' to '/data/backup/hotbackup/base/mysql/general_log.CSV'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/plugin.MYI' to '/data/backup/hotbackup/base/mysql/plugin.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/proc.frm' to '/data/backup/hotbackup/base/mysql/proc.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/slave_master_info.frm' to

'/data/backup/hotbackup/base/mysql/slave_master_info.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/help_category.MYD' to

'/data/backup/hotbackup/base/mysql/help_category.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/proxies_priv.MYD' to '/data/backup/hotbackup/base/mysql/proxies_priv.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/slow_log.CSM' to '/data/backup/hotbackup/base/mysql/slow_log.CSM'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/event.MYI' to '/data/backup/hotbackup/base/mysql/event.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/slave_worker_info.frm' to

'/data/backup/hotbackup/base/mysql/slave_worker_info.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/slow_log.frm' to '/data/backup/hotbackup/base/mysql/slow_log.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/user.frm' to '/data/backup/hotbackup/base/mysql/user.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone.MYD' to '/data/backup/hotbackup/base/mysql/time_zone.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/user.MYD' to '/data/backup/hotbackup/base/mysql/user.MYD'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone_name.MYI' to

'/data/backup/hotbackup/base/mysql/time_zone_name.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone_name.frm' to

'/data/backup/hotbackup/base/mysql/time_zone_name.frm'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/proxies_priv.MYI' to '/data/backup/hotbackup/base/mysql/proxies_priv.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/help_relation.MYI' to

'/data/backup/hotbackup/base/mysql/help_relation.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/columns_priv.MYI' to '/data/backup/hotbackup/base/mysql/columns_priv.MYI'
innobackupex: Copying '/data/backup/hotbackup/incremental_two/mysql/time_zone.MYI' to '/data/backup/hotbackup/base/mysql/time_zone.MYI'
150730 15:39:49  innobackupex: completed OK!

[root@dba ~]# innobackupex --defaults-file=/etc/my.cnf --copy-back -rsync /data/backup/hotbackup/base/

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013.  All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

150730 15:42:00  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: Starting to copy files in '/data/backup/hotbackup/base'
innobackupex: back to original data directory '/var/lib/mysql'
innobackupex: Copying '/data/backup/hotbackup/base/xtrabackup_info' to '/var/lib/mysql/xtrabackup_info'
innobackupex: Creating directory '/var/lib/mysql/performance_schema'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/socket_summary_by_instance.frm' to

'/var/lib/mysql/performance_schema/socket_summary_by_instance.frm'
innobackupex: Copying '/data/backup/hotbackup/base/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'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/rwlock_instances.frm' to

'/var/lib/mysql/performance_schema/rwlock_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/events_waits_current.frm' to

'/var/lib/mysql/performance_schema/events_waits_current.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/events_waits_summary_by_instance.frm' to

'/var/lib/mysql/performance_schema/events_waits_summary_by_instance.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/events_waits_history.frm' to

'/var/lib/mysql/performance_schema/events_waits_history.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/table_lock_waits_summary_by_table.frm' to

'/var/lib/mysql/performance_schema/table_lock_waits_summary_by_table.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/events_waits_history_long.frm' to

'/var/lib/mysql/performance_schema/events_waits_history_long.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/session_account_connect_attrs.frm' to

'/var/lib/mysql/performance_schema/session_account_connect_attrs.frm'
innobackupex: Copying '/data/backup/hotbackup/base/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'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/host_cache.frm' to '/var/lib/mysql/performance_schema/host_cache.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/session_connect_attrs.frm' to

'/var/lib/mysql/performance_schema/session_connect_attrs.frm'
innobackupex: Copying '/data/backup/hotbackup/base/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'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/performance_timers.frm' to

'/var/lib/mysql/performance_schema/performance_timers.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/setup_actors.frm' to

'/var/lib/mysql/performance_schema/setup_actors.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/hosts.frm' to '/var/lib/mysql/performance_schema/hosts.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/socket_instances.frm' to

'/var/lib/mysql/performance_schema/socket_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/events_statements_history.frm' to

'/var/lib/mysql/performance_schema/events_statements_history.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/table_io_waits_summary_by_index_usage.frm' to

'/var/lib/mysql/performance_schema/table_io_waits_summary_by_index_usage.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/setup_instruments.frm' to

'/var/lib/mysql/performance_schema/setup_instruments.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/events_statements_current.frm' to

'/var/lib/mysql/performance_schema/events_statements_current.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/setup_objects.frm' to

'/var/lib/mysql/performance_schema/setup_objects.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/events_waits_summary_global_by_event_name.frm' to

'/var/lib/mysql/performance_schema/events_waits_summary_global_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/users.frm' to '/var/lib/mysql/performance_schema/users.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/objects_summary_global_by_type.frm' to

'/var/lib/mysql/performance_schema/objects_summary_global_by_type.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/file_summary_by_event_name.frm' to

'/var/lib/mysql/performance_schema/file_summary_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/cond_instances.frm' to

'/var/lib/mysql/performance_schema/cond_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/base/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'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/events_stages_current.frm' to

'/var/lib/mysql/performance_schema/events_stages_current.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/events_statements_summary_by_digest.frm' to

'/var/lib/mysql/performance_schema/events_statements_summary_by_digest.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/events_stages_summary_global_by_event_name.frm' to

'/var/lib/mysql/performance_schema/events_stages_summary_global_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/events_statements_summary_global_by_event_name.frm' to

'/var/lib/mysql/performance_schema/events_statements_summary_global_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/base/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'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/events_stages_history.frm' to

'/var/lib/mysql/performance_schema/events_stages_history.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/file_instances.frm' to

'/var/lib/mysql/performance_schema/file_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/base/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'
innobackupex: Copying '/data/backup/hotbackup/base/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'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/events_stages_history_long.frm' to

'/var/lib/mysql/performance_schema/events_stages_history_long.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/events_statements_history_long.frm' to

'/var/lib/mysql/performance_schema/events_statements_history_long.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/table_io_waits_summary_by_table.frm' to

'/var/lib/mysql/performance_schema/table_io_waits_summary_by_table.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/setup_consumers.frm' to

'/var/lib/mysql/performance_schema/setup_consumers.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/accounts.frm' to '/var/lib/mysql/performance_schema/accounts.frm'
innobackupex: Copying '/data/backup/hotbackup/base/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'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/threads.frm' to '/var/lib/mysql/performance_schema/threads.frm'
innobackupex: Copying '/data/backup/hotbackup/base/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'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/file_summary_by_instance.frm' to

'/var/lib/mysql/performance_schema/file_summary_by_instance.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/socket_summary_by_event_name.frm' to

'/var/lib/mysql/performance_schema/socket_summary_by_event_name.frm'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/setup_timers.frm' to

'/var/lib/mysql/performance_schema/setup_timers.frm'
innobackupex: Copying '/data/backup/hotbackup/base/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'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/db.opt' to '/var/lib/mysql/performance_schema/db.opt'
innobackupex: Copying '/data/backup/hotbackup/base/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'
innobackupex: Copying '/data/backup/hotbackup/base/performance_schema/mutex_instances.frm' to

'/var/lib/mysql/performance_schema/mutex_instances.frm'
innobackupex: Copying '/data/backup/hotbackup/base/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'
innobackupex: Creating directory '/var/lib/mysql/test'
innobackupex: Copying '/data/backup/hotbackup/base/test/test.ibd' to '/var/lib/mysql/test/test.ibd'
innobackupex: Copying '/data/backup/hotbackup/base/test/test.frm' to '/var/lib/mysql/test/test.frm'
innobackupex: Creating directory '/var/lib/mysql/mysql'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/func.frm' to '/var/lib/mysql/mysql/func.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/db.MYD' to '/var/lib/mysql/mysql/db.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/help_category.MYI' to '/var/lib/mysql/mysql/help_category.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/help_relation.frm' to '/var/lib/mysql/mysql/help_relation.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone_transition.MYI' to '/var/lib/mysql/mysql/time_zone_transition.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone_leap_second.MYD' to '/var/lib/mysql/mysql/time_zone_leap_second.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/servers.MYD' to '/var/lib/mysql/mysql/servers.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/ndb_binlog_index.MYI' to '/var/lib/mysql/mysql/ndb_binlog_index.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/servers.frm' to '/var/lib/mysql/mysql/servers.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone_transition.frm' to '/var/lib/mysql/mysql/time_zone_transition.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/db.frm' to '/var/lib/mysql/mysql/db.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/event.MYD' to '/var/lib/mysql/mysql/event.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/db.MYI' to '/var/lib/mysql/mysql/db.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/proxies_priv.frm' to '/var/lib/mysql/mysql/proxies_priv.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone_transition_type.MYD' to

'/var/lib/mysql/mysql/time_zone_transition_type.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/help_topic.MYD' to '/var/lib/mysql/mysql/help_topic.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/servers.MYI' to '/var/lib/mysql/mysql/servers.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/help_keyword.MYD' to '/var/lib/mysql/mysql/help_keyword.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/ndb_binlog_index.MYD' to '/var/lib/mysql/mysql/ndb_binlog_index.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/user.MYI' to '/var/lib/mysql/mysql/user.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/slave_relay_log_info.ibd' to '/var/lib/mysql/mysql/slave_relay_log_info.ibd'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/innodb_index_stats.frm' to '/var/lib/mysql/mysql/innodb_index_stats.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/general_log.CSM' to '/var/lib/mysql/mysql/general_log.CSM'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/columns_priv.MYD' to '/var/lib/mysql/mysql/columns_priv.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/help_topic.MYI' to '/var/lib/mysql/mysql/help_topic.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/func.MYD' to '/var/lib/mysql/mysql/func.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/tables_priv.frm' to '/var/lib/mysql/mysql/tables_priv.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/innodb_table_stats.frm' to '/var/lib/mysql/mysql/innodb_table_stats.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/tables_priv.MYD' to '/var/lib/mysql/mysql/tables_priv.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/help_topic.frm' to '/var/lib/mysql/mysql/help_topic.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/general_log.frm' to '/var/lib/mysql/mysql/general_log.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/slave_relay_log_info.frm' to '/var/lib/mysql/mysql/slave_relay_log_info.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone_leap_second.frm' to '/var/lib/mysql/mysql/time_zone_leap_second.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone_transition_type.MYI' to

'/var/lib/mysql/mysql/time_zone_transition_type.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/help_keyword.MYI' to '/var/lib/mysql/mysql/help_keyword.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/help_relation.MYD' to '/var/lib/mysql/mysql/help_relation.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/event.frm' to '/var/lib/mysql/mysql/event.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/innodb_table_stats.ibd' to '/var/lib/mysql/mysql/innodb_table_stats.ibd'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/plugin.frm' to '/var/lib/mysql/mysql/plugin.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone_leap_second.MYI' to '/var/lib/mysql/mysql/time_zone_leap_second.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/plugin.MYD' to '/var/lib/mysql/mysql/plugin.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/slow_log.CSV' to '/var/lib/mysql/mysql/slow_log.CSV'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/ndb_binlog_index.frm' to '/var/lib/mysql/mysql/ndb_binlog_index.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone_transition.MYD' to '/var/lib/mysql/mysql/time_zone_transition.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone_name.MYD' to '/var/lib/mysql/mysql/time_zone_name.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone.frm' to '/var/lib/mysql/mysql/time_zone.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/func.MYI' to '/var/lib/mysql/mysql/func.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/tables_priv.MYI' to '/var/lib/mysql/mysql/tables_priv.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/procs_priv.MYI' to '/var/lib/mysql/mysql/procs_priv.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/columns_priv.frm' to '/var/lib/mysql/mysql/columns_priv.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/help_keyword.frm' to '/var/lib/mysql/mysql/help_keyword.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/procs_priv.MYD' to '/var/lib/mysql/mysql/procs_priv.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/procs_priv.frm' to '/var/lib/mysql/mysql/procs_priv.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/innodb_index_stats.ibd' to '/var/lib/mysql/mysql/innodb_index_stats.ibd'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone_transition_type.frm' to

'/var/lib/mysql/mysql/time_zone_transition_type.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/help_category.frm' to '/var/lib/mysql/mysql/help_category.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/proc.MYI' to '/var/lib/mysql/mysql/proc.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/proc.MYD' to '/var/lib/mysql/mysql/proc.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/general_log.CSV' to '/var/lib/mysql/mysql/general_log.CSV'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/plugin.MYI' to '/var/lib/mysql/mysql/plugin.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/proc.frm' to '/var/lib/mysql/mysql/proc.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/slave_master_info.frm' to '/var/lib/mysql/mysql/slave_master_info.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/help_category.MYD' to '/var/lib/mysql/mysql/help_category.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/slave_master_info.ibd' to '/var/lib/mysql/mysql/slave_master_info.ibd'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/proxies_priv.MYD' to '/var/lib/mysql/mysql/proxies_priv.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/slow_log.CSM' to '/var/lib/mysql/mysql/slow_log.CSM'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/event.MYI' to '/var/lib/mysql/mysql/event.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/slave_worker_info.frm' to '/var/lib/mysql/mysql/slave_worker_info.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/slave_worker_info.ibd' to '/var/lib/mysql/mysql/slave_worker_info.ibd'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/slow_log.frm' to '/var/lib/mysql/mysql/slow_log.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/user.frm' to '/var/lib/mysql/mysql/user.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone.MYD' to '/var/lib/mysql/mysql/time_zone.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/user.MYD' to '/var/lib/mysql/mysql/user.MYD'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone_name.MYI' to '/var/lib/mysql/mysql/time_zone_name.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone_name.frm' to '/var/lib/mysql/mysql/time_zone_name.frm'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/proxies_priv.MYI' to '/var/lib/mysql/mysql/proxies_priv.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/help_relation.MYI' to '/var/lib/mysql/mysql/help_relation.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/columns_priv.MYI' to '/var/lib/mysql/mysql/columns_priv.MYI'
innobackupex: Copying '/data/backup/hotbackup/base/mysql/time_zone.MYI' to '/var/lib/mysql/mysql/time_zone.MYI'

innobackupex: Starting to copy InnoDB system tablespace
innobackupex: in '/data/backup/hotbackup/base'
innobackupex: back to original InnoDB data directory '/var/lib/mysql'
innobackupex: Copying '/data/backup/hotbackup/base/ibdata1' to '/var/lib/mysql/ibdata1'

innobackupex: Starting to copy InnoDB undo tablespaces
innobackupex: in '/data/backup/hotbackup/base'
innobackupex: back to '/var/lib/mysql'

innobackupex: Starting to copy InnoDB log files
innobackupex: in '/data/backup/hotbackup/base'
innobackupex: back to original InnoDB log directory '/var/lib/mysql'
innobackupex: Copying '/data/backup/hotbackup/base/ib_logfile0' to '/var/lib/mysql/ib_logfile0'
innobackupex: Copying '/data/backup/hotbackup/base/ib_logfile1' to '/var/lib/mysql/ib_logfile1'
innobackupex: Finished copying back files.

150730 15:42:00  innobackupex: completed OK!

[root@dba lib]# ls -l mysql
总用量 110608
-rw-r--r-- 1 root root 12582912 7月  30 15:42 ibdata1
-rw-r--r-- 1 root root 50331648 7月  30 15:42 ib_logfile0
-rw-r--r-- 1 root root 50331648 7月  30 15:42 ib_logfile1
drwxr-xr-x 2 root root     4096 7月  30 15:42 mysql
drwxr-xr-x 2 root root     4096 7月  30 15:42 performance_schema
drwxr-xr-x 2 root root     4096 7月  30 15:42 test
-rw-r--r-- 1 root root      674 7月  30 15:42 xtrabackup_info
[root@dba lib]# chown -R mysql:mysql mysql
[root@dba lib]# service mysql start
Starting MySQL... SUCCESS!

mysql> select * from test;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    2
Current database: test

+----+--------+
| id | name   |
+----+--------+
|  1 | test1  |
|  2 | test2  |
|  3 | test3  |
|  4 | test4  |
|  5 | test5  |
|  6 | test6  |
|  7 | test7  |
|  8 | test8  |
|  9 | test9  |
| 10 | test10 |
| 11 | test11 |
| 12 | test12 |
| 13 | test13 |
| 14 | test14 |
| 15 | test15 |
| 16 | test16 |
+----+--------+
16 rows in set (0.00 sec)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29313086/viewspace-1756787/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29313086/viewspace-1756787/