--准备全备文件
SHELL> innobackupex --apply-log --user=robin -password=xxx --port=3606 --socket=/tmp/mysql3606.sock \
> --defaults-file=/data/inst3606/data3606/my3606.cnf /data/bak/hotbak/2014-12-22_09-04-05
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
? ? ? ? ? ? ......非重要信息忽略,下同......
xtrabackup: Starting InnoDB instance for recovery.? --开始innodb实例恢复
? ? ? ? ? ? ...........
InnoDB: Starting crash recovery.? ? --开始crash recovery
? ? ? ? ? ? ...........
141222 09:13:59? innobackupex: Restarting xtrabackup with command: xtrabackup? --defaults-file="/data/inst3606/data3606/my3606.cnf"
--defaults-group="mysqld" --prepare --target-dir=/data/bak/hotbak/2014-12-22_09-04-05 --tmpdir=/tmp
for creating ib_logfile*? ? ? ? ? --注意这里,使用了--prepare,并且创建innodb的logfile
--查看恢复后文件的相关信息
SHELL>? ll 2014-12-22_09-04-05
total 178404
-rw-r--r-- 1 root root? ? ? 357 2014/12/22 09:04 backup-my.cnf
drwx------ 2 root root? ? 4096 2014/12/22 09:04 fullbakdb
-rw-r----- 1 root root 79691776 2014/12/22 09:14 ibdata1
-rw-r--r-- 1 root root 50331648 2014/12/22 09:14 ib_logfile0
-rw-r--r-- 1 root root 50331648 2014/12/22 09:13 ib_logfile1
drwx------ 2 root root? ? 4096 2014/12/22 09:04 mysql
drwxr-xr-x 2 root root? ? 4096 2014/12/22 09:04 performance_schema
drwx------ 2 root root? ? 4096 2014/12/22 09:04 recover
drwx------ 2 root root? ? 4096 2014/12/22 09:04 sakila
-rw-r--r-- 1 root root? ? ? 26 2014/12/22 09:04 xtrabackup_binlog_info
-rw-r--r-- 1 root root? ? ? 24 2014/12/22 09:14 xtrabackup_binlog_pos_innodb
-rw-r----- 1 root root? ? ? 93 2014/12/22 09:14 xtrabackup_checkpoints
-rw-r--r-- 1 root root? ? ? 684 2014/12/22 09:04 xtrabackup_info
-rw-r----- 1 root root? 2097152 2014/12/22 09:13 xtrabackup_logfile
--观察上面文件夹内容的变化,可以看到09:14为新增或发生变化的文件,主要是生成了系统表空间数据文件及innodb日志文件
--同时有关Innodb的检查点文件也进行了更新(注,热备只涉及到InnoDB引擎,所有与InnoDB相关的都会在apply-log时发生变化
--将原有文件夹重命名到新位置,并创建原文件夹
SHELL> mv /data/inst3606/data3606 /data/inst3606/data3606bk
SHELL> mkdir -p /data/inst3606/data3606
--将已经恢复好的数据文件复制回原始位置
SHELL> innobackupex --user=robin -password=xxx --port=3606 --defaults-file=/data/inst3606/data3606bk/my3606.cnf \
> --copy-back /data/bak/hotbak/2014-12-22_09-04-05
? ? ? ? ? ? ? ? ? ? ......非重要信息忽略,下同......
innobackupex: Starting to copy files in '/data/bak/hotbak/2014-12-22_09-04-05' --启动将备份的文件复制回原路径
innobackupex: back to original data directory '/data/inst3606/data3606'? ? ? ? --原路径位置
? ? ? ? ? ? ? ? ? ? ............复制所有的数据文件,索引文件个,格式文件等............
innobackupex: Starting to copy InnoDB system tablespace? --复制系统表空间
innobackupex: in '/data/bak/hotbak/2014-12-22_09-04-05'
innobackupex: back to original InnoDB data directory '/data/inst3606/data3606'
innobackupex: Copying '/data/bak/hotbak/2014-12-22_09-04-05/ibdata1' to '/data/inst3606/data3606/ibdata1'
innobackupex: Starting to copy InnoDB undo tablespaces? --复制undo表空间
innobackupex: in '/data/bak/hotbak/2014-12-22_09-04-05'
innobackupex: back to '/data/inst3606/data3606'
innobackupex: Starting to copy InnoDB log files? ? ? ? ? --复制redo表空间
innobackupex: in '/data/bak/hotbak/2014-12-22_09-04-05'
innobackupex: back to original InnoDB log directory '/data/inst3606/data3606'
innobackupex: Copying '/data/bak/hotbak/2014-12-22_09-04-05/ib_logfile1' to '/data/inst3606/data3606/ib_logfile1'
innobackupex: Copying '/data/bak/hotbak/2014-12-22_09-