MySQL備份工具percona-xtrabackup安裝，xtrabackup備份mysql

MySQL備份工具percona-xtrabackup安裝，xtrabackup備份mysql

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