xtrabackup8.0本地备份和恢复(xbstream+gzip)

环境:

OS:Kylin v11

mysql:8.0.41

xtrabackup:8.0.35-34

 

1.备份
/opt/xtrabackup-8.0.35-34/bin/xtrabackup --defaults-file=/home/middle/mysql8/conf/my.cnf --user=root --password=mysql -P13306 --socket=/tmp/mysql.sock --no-version-check --compress-threads=4 --backup --stream=xbstream --parallel=4 | gzip > /opt/xtrabackup_file/mybak20250910.xb.gz

 

2.停掉数据库
systemctl stop mysql
或是
/home/middle/mysql8/bin/mysqladmin -h localhost -uroot -P13306 -pmysql shutdown

 

3.备份原来的数据目录
[root@localhost mysql8]#cd /home/middle/mysql8
[root@localhost mysql8]# mv data bak_data

 

4.创建空的数据目录
[root@localhost mysql8]# cd /home/middle/mysql8
[root@localhost mysql8]# mkdir data

 

5.恢复
直接解压到数据目录
分步解压
[root@localhost xtrabackup_file]# gzip -d mybak20250910.xb.gz
/opt/xtrabackup-8.0.35-34/bin/xbstream --parallel=4 -x -v -C /home/middle/mysql8/data</opt/xtrabackup_file/mybak20250910.xb.gz

一步解压
[root@localhost xtrabackup_file]# cd /opt/xtrabackup_file
[root@localhost xtrabackup_file]#gzip -d -c mybak20250910.xb.gz|/opt/xtrabackup-8.0.35-34/bin/xbstream --parallel=4 -x -v -C /home/middle/mysql8/data

直接恢复
/opt/xtrabackup-8.0.35-34/bin/xtrabackup --defaults-file=/home/middle/mysql8/conf/my.cnf --user=root --prepare --target-dir=/home/middle/mysql8/data

 

这里--prepare类似2.4版本的innobackupex --apply-log

 

修改权限
[root@localhost middle]# cd /home/middle/
[root@localhost middle]# chown -R mysql:mysql ./mysql8/

启动
systemctl start mysql
或是
/home/middle/mysql8/bin/mysqld_safe --defaults-file=/home/middle/mysql8/conf/my.cnf --user=mysql &

登录查看
/home/middle/mysql8/bin/mysql -h localhost -uroot -P13306 -pmysql