mysql Percona-XtraBackup

下载（示例：centos7下2.4.4版本，用https://www.percona.com/downloads/XtraBackup/LATEST/选择适合版本） wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.4/ binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.4-1.el7.x86_64.rpm   安装 yum localinstall percona-xtrabackup-24-2.4.4-1.el7.x86_64.rpm   卸载 yum remove percona-xtrabackup   备份 innobackupex --defaults-file=/etc/my.cnf --user=root --password=‘p4ssword‘ --stream=tar --databases="database_name" /opt/backup/ | gzip > /opt/backup/`date +%Y%m%d`.tar.gz   还原，还原前需要先停掉mysql服务 innobackupex --copy-back /path/to/BACKUP-DIR