物理备份恢复mariadb

#全备份
innobackupex --user=root --password=abc123 /u01/mysql/backup
#基于第一次全备份的增量备份1
innobackupex --user=root --password=abc123 --incremental /u01/mysql/backup --incremental-basedir=/u01/mysql/backup/2017-06-01_16-26-00
#基于增量备份1的增量备份2
innobackupex --user=root --password=abc123 --incremental /u01/mysql/backup --incremental-basedir=/u01/mysql/backup/2017-06-01_16-27-13


#将两次增量备份应用到第一次的全备份，注意查看第一次全备份下xtrabackup_checkpoints文件中 backup_type，from_lsn，to_lsn，last_lsn的变化
innobackupex --apply-log --redo-only /u01/mysql/backup/2017-06-01_16-26-00
innobackupex --apply-log --redo-only /u01/mysql/backup/2017-06-01_16-26-00 --incremental-dir=/u01/mysql/backup/2017-06-01_16-27-13
innobackupex --apply-log             /u01/mysql/backup/2017-06-01_16-26-00 --incremental-dir=/u01/mysql/backup/2017-06-01_16-28-25


#恢复
innobackupex --copy-back /u01/mysql/backup/2017-06-01_16-26-00 #(apply-log)