xtrabackup全备方案，备份恢复全过程记录(二)
.ibd
[01] ...done
[01] Copying ./inno/t.ibd
to /data/back_up//inno/t.ibd
[01] ...done
xtrabackup: The latest check point (for incremental): '893330211'
>> log scanned up to (893330211)
xtrabackup: Stopping log copying thread.
xtrabackup: Transaction log of lsn (893330211) to (893330211) was copied.
[root@Slave02 back_up]#
[root@Slave02 back_up]# ls
ibdata1 inno xtrabackup_checkpoints xtrabackup_logfile
[root@Slave02 back_up]# cd inno/
[root@Slave02 inno]# ls
mm.ibd t.ibd
[root@Slave02 inno]# ll
total 208
-rw-r--r-- 1 root root 98304 Mar 27 14:11 mm.ibd
-rw-r--r-- 1 root root 98304 Mar 27 14:11 t.ibd
[root@Slave02 inno]#
[root@Slave02 inno]# cp /usr/local/mysql/data/inno/*.frm /data/back_up/inno/ --复制表结构文件进行到备份目录内；
[root@Slave02 inno]# cd /data/back_up/inno/
[root@Slave02 inno]# ls
mm.frm mm.ibd t.frm t.ibd ----此目录内有完整的IBD数据文件和frm表结构文件；
[root@Slave02 inno]#
[root@Slave02 inno]# cd ..
[root@Slave02 data]# ls
book log.1 mysql-bin.000004 prod
ibdata1 mysql mysql-bin.index Slave02.err
ib_logfile0 mysql-bin.000001 mysqld_multi.log Slave02.pid
ib_logfile1 mysql-bin.000002 mysql.pid slow.log
inno mysql-bin.000003 performance_schema test
---以下开始测试全库innodb的恢复过程
[root@Slave02 data]# rm -rf inno/ ----删除inno里的所有文件（ibd,from等）
[root@Slave02 data]# ls
book mysql mysql-bin.index Slave02.err
ibdata1 mysql-bin.000001 mysqld_multi.log Slave02.pid
ib_logfile0 mysql-bin.000002 mysql.pid slow.log
ib_logfile1 mysql-bin.000003 performance_schema test
log.1 mysql-bin.000004 prod
[root@Slave02 data]# cp -r /data/back_up/inno/ /usr/local/mysql/data/ --使用备份的数据进行还原到相关目录
[root@Slave02 data]# ls
book log.1 mysql-bin.000004 prod
ibdata1 mysql mysql-bin.index Slave02.err
ib_logfile0 mysql-bin.000001 mysqld_multi.log Slave02.pid
ib_logfile1 mysql-bin.000002 mysql.pid slow.log
inno mysql-bin.000003 performance_schema test
[root@Slave02 data]# cd inno/
[root@Slave02 inno]# ll ---查看到相关的目前权限不对，进行修改
total 240
-rw-r----- 1 root root 8554 Mar 27 14:20 mm.frm
-rw-r--r-- 1 root root 98304 Mar 27 14:20 mm.ibd
-rw-r----- 1 root root 8554 Mar 27 14:20 t.frm
-rw-r--r-- 1 root root 98304 Mar 27 14:20 t.ibd
[root@Slave02 inno]#
[root@Slave02 inno]# ll
total 240
-rw-r----- 1 root root 8554 Mar 27 14:20 mm.frm
-rw-r--r-- 1 root root 98304 Mar 27 14:20 mm.ibd
-rw-r----- 1 root root 8554 Mar 27 14:20 t.frm
-rw-r--r-- 1 root root 98304 Mar 27 14:20 t.ibd
[root@Slave02 inno]# chown -R mysql:mysql /usr/local/mysql/data/inno/
[root@Slave02 inno]# ll -la
total 256
drwx------ 2 mysql mysql 4096 Mar 27 14:20 .
drwxr-xr-x 8 mysql mysql 4096 Mar 27 14:20 ..
-rw-r----- 1 mysql mysql 8554 Mar 27 14:20 mm.frm
-rw-r--r-- 1 mysql mysql 98304 Mar 27 14:20 mm.ibd
-rw-r----- 1 mysql mysql 8554 Mar 27 14:20 t.frm
-rw-r--r-- 1 mysql mysql 98304 Mar 27 14:20 t.ibd
[root@Slave02 inno]#
[root@Slave02 inno]# service mysqld restart -----重启msyql，进行校验下数据；
Shutting down MySQL. [ OK ]
Starting My