xtrabackup备份还原mysql

程序源~

已于 2025-08-04 14:20:34 修改

阅读量135

点赞数 2

CC 4.0 BY-SA版权

文章标签： mysql linux 数据库

于 2025-05-12 15:57:41 首次发布

本文链接：https://blog.csdn.net/y1035793317/article/details/147898512

安装 xtrabackup

二进制 部署
wget -c https://downloads.percona.com/downloads/Percona-XtraBackup-2.4/Percona-XtraBackup-2.4.28/binary/tarball/percona-xtrabackup-2.4.28-Linux-x86_64.glibc2.17.tar.gz
tar -xf percona-xtrabackup-2.4.28-Linux-x86_64.glibc2.17.tar.gz -C /usr/local/
#加入$PATH   /etc/profile
echo "export PATH=\$PATH:/usr/local/percona-xtrabackup-2.4.28-Linux-x86_64.glibc2.17/bin" >>/etc/profile
source /etc/profile

备份

xtrabackup --backup --target-dir=/data/xbackup/  --user=root  --password=123456

还原

systemctl stop mysqld

 rm -rf /usr/local/mysql/data/*

xtrabackup --prepare --target-dir=/data/backups/

xtrabackup --copy-back --target-dir=/data/backups/


chown -R mysql. /usr/local/mysql/data

systemctl start mysql