XtraBackup Incremental

gistfile1.txt

# backup

innobackupex --no-timestamp /var/lib/mysql-backup/full
innobackupex --no-timestamp --incremental /var/lib/mysql-backup/incremental1 --incremental-basedir=/var/lib/mysql-backup/full
innobackupex --no-timestamp --incremental /var/lib/mysql-backup/incremental2 --incremental-basedir=/var/lib/mysql-backup/incremental1
innobackupex --no-timestamp --incremental /var/lib/mysql-backup/incremental3 --incremental-basedir=/var/lib/mysql-backup/incremental2

#prepare incrementals into full

innobackupex --apply-log --redo-only /root/backup/full
innobackupex --apply-log --redo-only /root/backup/full --incremental-dir=/root/backup/incremental0
innobackupex --apply-log --redo-only /root/backup/full --incremental-dir=/root/backup/incremental1
innobackupex --apply-log /root/backup/full --incremental-dir=/root/backup/incremental2
## Note --redo-only should be used when merging all incrementals **except the last one**
innobackupex --apply-log /root/backup/full
xtrabackup --prepare --target-dir=/root/backup/full

# restore prepared backup

service mysql stop
rm -rf /var/lib/mysql
install -d -o mysql -g mysql -m 755 /var/lib/mysql
innobackupex --copy-back /root/backup/full
chown -R mysql:mysql /var/lib/mysql
service mysql start