percona mysql 备份_使用Percona Xtrabackup备份Mysql

可以使用Percona Xtrabackup创建Mysql备份数据，运行下面命令：

$ innobackupex --user=DBUSER --password=DBUSERPASS /path/to/BACKUP-DIR/

对应的恢复数据操作如下：

$ xtrabackup --prepare --datadir=/var/lib/mysql --target-dir=/path/to/BACKUP-DIR/

$ sudo service mysql stop

$ sudo mv /var/lib/mysql ~/dbbackup

$ sudo mv /path/to/BACKUP-DIR /var/lib/mysql

$ sudo chown -R mysql:mysql /var/lib/mysql

$ sudo service mysql start

$ mysql -u root -p

mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'password from /etc/mysql/debian.cnf' WITH GRANT OPTION;