物理备份恢复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)