环境:
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
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'.