centos7.6安装xtrabackup 备份 mysql5.7

#安装
yum -y install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
percona-release enable-only tools release
yum list | grep percona
yum repolist all | grep percona
yum -y install percona-xtrabackup-24
rpm -ql percona-xtrabackup-24

 

#全量备份
innobackupex --defaults-file=/etc/my.cnf --user=root --password=abc123 /mysql_backup/backup

 

#全量还原
systemctl stop mysqld
rm -rf /var/lib/mysql #删除mysql数据文件夹
innobackupex --defaults-file=/etc/my.cnf --copy-back /mysql_backup/backup/2022-03-03_10-34-08
chown -R mysql:mysql /var/lib/mysql
chmod 755 /var/lib/mysql #数据文件夹需要755权限
systemctl start mysqld