[01]? ? ? ...done
[01] Copying ./user_db/UC_USER.ibd to/data/backups/mysql/incre_20150321/user_db/UC_USER.ibd.delta
[01]? ? ? ...done
[01] Copying ./user_db/t.ibd to/data/backups/mysql/incre_20150321/user_db/t.ibd.delta
[01]? ? ? ...done
>> log scanned up to (423931610)
xtrabackup: The latest check point (forincremental): '423931610'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (423931610)
?
xtrabackup: Transaction log of lsn(423931610) to (423931610) was copied.
?
?
4，xtrabackup进行增量恢复
4.1为了验证比对，先删除两个增量备份前表里面的数据
?
mysql> delete from t4;
Query OK, 2 rows affected (0.05 sec)
?
mysql> delete from t_incre_2;
Query OK, 2 rows affected (0.04 sec)
?
mysql> select * from t4;
Empty set (0.00 sec)
?
mysql> select * from t_incre_2;
Empty set (0.00 sec)
?
mysql>
?
?
?
4.2开始全备份恢复PREPARE THE BASE BACKUP
备份命令如下：
xtrabackup --defaults-file=/etc/my.cnf--prepare --user=backup --password="123456"? --apply-log-only--target-dir=/data/backups/mysql/full_incre_20150319 2>/tmp/full_restore.log
?
备份信息记录如下：
?
[root@data01 mysql]# xtrabackup--defaults-file=/etc/my.cnf --prepare --user=backup--password="123456" --apply-log-only --target-dir=/data/backups/mysql/full_incre_20150319
xtrabackup version 2.2.9 based on MySQLserver 5.6.22 Linux (x86_64) (revision id: )
xtrabackup: cd to/data/backups/mysql/full_incre_20150319
xtrabackup: This target seems to be alreadyprepared.
xtrabackup: notice: xtrabackup_logfile wasalready used to '--prepare'.
xtrabackup: using the following InnoDBconfiguration for recovery:
xtrabackup:? innodb_data_home_dir = ./
xtrabackup:? innodb_data_file_path =IBdata1:128M;IBdata2:128M:autoextend
xtrabackup:? innodb_log_group_home_dir = ./
xtrabackup:? innodb_log_files_in_group = 3
xtrabackup:? innodb_log_file_size = 67108864
xtrabackup: using the following InnoDBconfiguration for recovery:
xtrabackup:? innodb_data_home_dir = ./
xtrabackup:? innodb_data_file_path =IBdata1:128M;IBdata2:128M:autoextend
xtrabackup:? innodb_log_group_home_dir = ./
xtrabackup:? innodb_log_files_in_group = 3
xtrabackup:? innodb_log_file_size = 67108864
xtrabackup: Starting InnoDB instance forrecovery.
xtrabackup: Using 104857600 bytes forbuffer pool (set by --use-memory parameter)
InnoDB: Using atomics to ref count bufferpool pages
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomicbuiltins
InnoDB: Memory barrier is not used
InnoDB: Compressed tables use zlib 1.2.3
InnoDB: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size =100.0M
InnoDB: Completed initialization of bufferpool
InnoDB: Setting log file ./ib_logfile101size to 64 MB
InnoDB: Setting log file ./ib_logfile1 sizeto 64 MB
InnoDB: Setting log file ./ib_logfile2 sizeto 64 MB
InnoDB: Renaming log file ./ib_logfile101to ./ib_logfile0
InnoDB: New log files created,LSN=423920168
InnoDB: Highest supported file format isBarracuda.
?
[notice (again)]
? Ifyou use binary log and don't use any hack of group commit,
? thebinary log position seems to be:
InnoDB: Last MySQL binlog file position 0915, file name mysql-bin.000053
?
xtrabackup: starting shutdown withinnodb_fast_shutdown = 1
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequencenumber 423920652
[root@data01 mysql]#
?
?
4.3 恢复到第一次增量的时刻
恢复命令：
xtrabackup --defaults-file=/etc/my.cnf--prepare --user