Incremental backup with Xtrabackup


I’m trying to use innobackupex and xtrabackup to make incremental backups but so far no luck.

First I created a full backup

innobackupex --password=xxxxx --no-lock --tmpdir=/tmp /data/backups/full/…innobackupex: Backup created in directory '/data/backups/full/2011-05-02_02-13-49’110502 02:21:03 innobackupex: completed OK!

Everything went smoothly and I end up with a time stamped folder containing

I tried then to create a incremental backup based on this full back up

innobackupex --incremental --password=xxxxx --tmpdir=/tmp --no-lock --incremental-basedir=/data/backups/full/2011-05-02_02-13-49/ incremental/…xtrabackup: The latest check point (for incremental): ‘245:3281249024’>> log scanned up to (245 3288192768)xtrabackup: Stopping log copying thread.xtrabackup: Transaction log of lsn (245 3257702458) to (245 3288192768) was copied.innobackupex: Backup created in directory ‘/data/backups/incremental/2011-05-02_02-27-29’

So far everything looks ok
delta files have been successfully created

When I try to apply those delta files to the full backup directory I get the following

xtrabackup --prepare --apply-log-only --target-dir=/data/backups/full/2011-05-02_02-13-49/ --incremental-dir=/data/backups/incremental/2011-05-02_02-27-29/xtrabackup: error: failed to read metadata from /data/backups/incremental/2011-05-02_02-27-29//xtrabackup_checkpoints

Any help would be really appreciated.

Thx in advance

Please try this.It may sort out the problem.Hope this helps.

xtrabackup --backup --target-dir=/full_backups

To make changes to the database to take an incremental backup.

To take a incremental backup I ran the following:

xtrabackup --backup --target-dir=/incremental --incremental-


Preparing the full backup:

xtrabackup --prepare --target-dir=/full_backups

Applied incremental backup to the full backup.

xtrabackup --prepare --target-dir=/full_backups --incremental-dir=/


innobackupex-1.5.1 --copy-back /full_backups/

Thx a lot for your answer. I finally figured it out and will post a full how to very soon.