使用xtrabackup备份文件快速异机恢复

环境:
OS:Centos 7
mysql:5.7.29
xtrabckup:2.4.7

####################
1.停掉原有的mysql
[root@host134 mysql57]#/data/middle/mysql57/bin/mysqladmin -h localhost -uroot -P13306 -pmysql shutdown

 

2.备份原来的数据目录
[root@host134 mysql57]# cd /data/middle/mysql57
[root@host134 mysql57]# mv data bakdata
[root@host134 mysql57]# mkdir data
[root@host134 mysql57]# chown -R mysql:mysql ./data

 

2.直接解压到数据目录
这一步的目的是不要执行innobackupex --copy-back --rsync
[root@host134 tmp]#tar -zxvf xtrabackup_0810.tar.gz -C /data/middle/mysql57/data

 

若是tar文件的话，先解压后进入到解压目录，把该目录下的所有文件mv到数据目录

[root@host135 tmp]# tar -xvf 2023-08-21_14-58-31.tar
[root@host135 tmp]# cd 2023-08-21_14-58-31
[root@host135 2023-08-21_14-58-31]# mv * /data/middle/mysql57/data/

 

3.恢复
#/opt/xtrabackup-2.4.7/bin/innobackupex --defaults-file=/data/middle/mysql57/conf/my.cnf --user=root --apply-log /data/middle/mysql57/data

 

4.修改权限
[root@host134 mysql57]# cd /data/middle/
[root@host134 mysql57]# chown -R mysql:mysql ./mysql57

 

5.启动
/data/middle/mysql57/bin/mysqld_safe --defaults-file=/data/middle/mysql57/conf/my.cnf --user=mysql &

6.登录
/data/middle/mysql57/bin/mysql -h localhost -uroot -P13306 -pyeemiao3040

说明:
如源库安装了审计插件的,建议在恢复的机器上也安装审计插件,否则启动的时候会报如下错误(不过数据库是就可以启动的):

2023-08-10T07:50:30.126560Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230810 15:50:30
2023-08-10T07:50:30.129231Z 0 [ERROR] Can't open shared library '/data/middle/mysql57/lib/plugin/server_audit.so' (errno: 2 /data/middle/mysql57/lib/plugin/server_audit.so: cannot open shared object file: No such file or directory)
2023-08-10T07:50:30.129268Z 0 [Warning] Couldn't load plugin named 'server_audit' with soname 'server_audit.so'.