通过xtrabackup进行恢复的时候报错
/opt/percona-xtrabackup-2.4.4-Linux-x86_64/bin/innobackupex –defaults-file=/data/opt/mysql02/db_bak/bak/2018-01-03_03-00-05/my.conf /data/opt/mysql02/db_bak/bak/2018-01-03_03-00-05/ –copy-back
xtrabackup Error: datadir must be specified
报错原因:
指定的参数文件和备份文件在相同的目录下面
解决方法:
将参数文件存放在备份文件之外的目录下面
/opt/percona-xtrabackup-2.4.4-Linux-x86_64/bin/innobackupex –defaults-file=/etc/my_01.cnf –apply-log /data/opt/mysql02/db_bak/bak/2018-01-03_03-00-05/