xtrabackup 使用总结:
1、会使用默认的参数文件
2、xtrabackup --copy-back --target-dir=/mysql_back
进行restore 时,有些文件不会迁移,例如 xtrabackup_checkpoints,下面是我做了copy-back 后再做 prepare,报错了
[root@localhost mysql_data]# xtrabackup --prepare --apply-log-only --target-dir=/mysqldata/mysql_data
xtrabackup version 2.4.11 based on MySQL server 5.7.19 Linux (x86_64) (revision id: b4e0db5)
xtrabackup: cd to /mysqldata/mysql_data/
xtrabackup: Error: cannot open ./xtrabackup_checkpoints
xtrabackup: Error: failed to read metadata from './xtrabackup_checkpoints'
3、生成的备份文件属主为root ,不知道能不能改
4、备份的属主为root ,restore 之后记得修改属主
二 、下面是一次备份恢复实验:
--做全备
xtrabackup --user=root --proot --backup --target-dir=/mysql_back/
--创建huang库,建表t1,执行增量备份的时候插入记录
xtrabackup --backup --target-dir=/mysql_back/inc1 --incremental-basedir=/mysql_back/
--对全备做prepare
xtrabackup --prepare --apply-log-only --target-dir=/mysql_back/
--对增量备份做prepare
xtrabackup --prepare --apply-log-only --target-dir=/mysql_back/ --incremental-dir=/mysql_back/inc1
--停了数据量,将数据目录清空
--进行restore
xtrabackup --copy-back --target-dir=/mysql_back
--打开数据库,查看数据
mysql> use huang;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+-----------------+
| Tables_in_huang |
+-----------------+
| t1 |
+-----------------+
1 row in set (0.00 sec)
mysql> select * from t1;
+------+
| id |
+------+
| 1 |
+------+
1 row in set (0.01 sec)