使用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;