If you want to take incremental backup use innobackupex
Creating an Incremental Backups with innobackupex
First, you need to make a full backup as the BASE for subsequent incremental backups:
$ innobackupex /data/backups
This will create a timestamped directory in /data/backups. Assuming that the backup is done last day of the year, BASEDIR would be /data/backups/2013-03-31_23-01-18, for example.
Note You can use the innobackupex --no-timestamp option to override this behavior and the backup will be created in the given directory.
If you check at the xtrabackup-checkpoints file in BASE-DIR, you should see something like:
backup_type = full-backuped
from_lsn = 0
to_lsn = 1291135
To create an incremental backup the next day, use the --incremental option and provide the BASEDIR:
$ innobackupex --incremental /data/backups --incremental-basedir=BASEDIR
and another timestamped directory will be created in /data/backups, in this example,
/data/backups/2013-04-01_23-01-18 containing the incremental backup. We will call this INCREMENTAL-DIR-1.
If you check at the xtrabackup-checkpoints file in INCREMENTAL-DIR-1, you should see something like:
backup_type = incremental
from_lsn = 1291135
to_lsn = 1352113
Creating another incremental backup the next day will be analogous, but this time the previous incremental one will be base:
$ innobackupex --incremental /data/backups --incremental-basedir=INCREMENTAL-DIR-1
yielding (in this example) /data/backups/2013-04-02_23-01-18. We will use INCREMENTAL-DIR-2 instead for simplicity.