MySQL备份工具percona-xtrabackup装配
MySQL备份工具percona-xtrabackup安装
1.安装xtrabackup的yum源
rpm -ivh https://www.percona.com/redir/downloads/percona-release/redhat/latest/percona-release-0.1-3.noarch.rpm
2.yum安装percona-xtrabackup软件
yum install percona-xtrabackup -y
3.命令使用
完全备份
innobackupex --user=USER --password=PASS /path/to/BACKUP-DIR
预备全备
innobackupex --apply-log /path/to/BACKUP-DIR/DATE-DIR
恢复备份
innobackupex --copy-back /path/to/BACKUP-DIR