1, full backuop, must first do:
Innobackupex--defaults-file=/etc/my.cnf--user=root--password=evlink/home/mysql/backup/
2, Incremental Backup, can be done every hour or three hours:
Innobackupex--defaults-file=/etc/my.cnf--user=root--password=evlink--incremental/home/mysql/backup/incre-- Incremental-basedir=/home/mysql/backup
Note: Do an incremental backup the second time--incremental be sure to specify a new directory. --incremental-basedir= not change
Restore, note my.cnf The specified datadir must be empty, otherwise the restore fails:
Prepare Restore:
Innobackupex--defaults-file=/etc/my.cnf--apply-log--redo-only--use-memory=4g/home/backup/2016-05-10_16-06-24/
Innobackupex--defaults-file=/etc/my.cnf--apply-log--redo-only--use-memory=4g/home/backup/2016-05-10_16-06-24/- -incremental-dir=/home/backup/incre/2016-05-10_16-15-55/
Innobackupex--defaults-file=/etc/my.cnf--apply-log---use-memory=4g/home/backup/2016-05-10_16-06-24/
Copy back:
Innobackupex--defaults-file=/etc/my.cnf--copy-back--use-memory=4g/home/backup/2016-05-10_16-06-24/
This article is from the "Technical Blog" blog, please be sure to keep this source http://raytech.blog.51cto.com/7602157/1773780
xtrabackup2.4 backup Precona5.6 database, do incremental backup and restore