)
环境:
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
修改权限
[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