赞
踩
# cat /etc/issue
Ubuntu 18.04.5 LTS \n \l
mkdir data/
xbstream -x -p 4 < ./全备文件.qp -C ./data/
innobackupex --parallel 4 --decompress ./data/
find ./data/ -name "*.qp" | xargs rm
innobackupex --apply-log ./data/
systemctl stop mysql.service
mv /var/lib/mysql /var/lib/mysql_bak
mkdir /var/lib/mysql
chown mysql:mysql /var/lib/mysql
innobackupex --defaults-file=/etc/my.cnf --copy-back /data
chown -R mysql:mysql /var/lib/mysql
systemctl restart mysql.service
journalctl -fu mysql
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。