# Innobackupex incremental backup size

**URL:** <https://forums.percona.com/t/innobackupex-incremental-backup-size/3425>\
**Category:** Percona XtraBackup\
**Created:** [April 25, 2014, 3:20am UTC](https://forums.percona.com/t/innobackupex-incremental-backup-size/3425 "2014-04-25T03:20:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![leserek](https://avatars.discourse-cdn.com/v4/letter/l/8491ac/32.png) [@leserek](https://forums.percona.com/u/leserek)\
**Post date:** [April 25, 2014, 3:20am UTC](https://forums.percona.com/t/innobackupex-incremental-backup-size/3425/1 "2014-04-25T03:20:53Z")

</div>

Hi,  
I have a problem with incremental backup. I dont have password for mysql-server, and doing full backup this command: innobackupex --user=root /backup\_mysql

file xtrabackup\_checkpoints:

backup\_type = full-prepared  
from\_lsn = 0  
to\_lsn = 44556  
last\_lsn = 44556

then doing incremental backup command:  
innobackupex --incremental /backup\_mysql/ --incremental-basedir=/backup\_mysql/2014-04-24\_15-00-12/

backup performed without errors, but this size is the same as full backup, why?

file xtrabackup\_checkpoints: backup\_type = incremental  
from\_lsn = 44556  
to\_lsn = 44556  
last\_lsn = 44556

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [April 25, 2014, 11:59am UTC](https://forums.percona.com/t/innobackupex-incremental-backup-size/3425/2 "2014-04-25T11:59:24Z")

</div>

Try following this guide and doing it again to make sure you are doing things in the right order:  
[url][Percona XtraBackup](http://www.percona.com/doc/percona-xtrabackup/2.1/howtos/recipes_ibkx_inc.html%5B/url%5D)

Looking at your incremental xtrabackup\_checkpoints, it’s going from and to the same lsn. So either there was no new data changes to backup, or the process you are following is wrong. So I would first make sure you actually have data changes from the full backup (i.e. insert a new record if this is a test database), and then follow the above guide to make sure you are following the correct process.

---

<div class="post-metadata">

**Author:** ![leserek](https://avatars.discourse-cdn.com/v4/letter/l/8491ac/32.png) [@leserek](https://forums.percona.com/u/leserek)\
**Post date:** [April 28, 2014, 4:27am UTC](https://forums.percona.com/t/innobackupex-incremental-backup-size/3425/3 "2014-04-28T04:27:18Z")

</div>

Hello,  
I’ve done the whole backup from the beginning according to your link. The effect is the same, xtrabackup\_checkpoints files are identical. Write data to the database all the time because, one of database it is a network monitor logs.

Below the result of full and incremental backup: innobackupex --user=root /backup\_mysql/

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy  
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.

This software is published under  
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

140428 10:08:56 innobackupex: Starting mysql with options: --user=‘root’ --unbuffered –  
140428 10:08:56 innobackupex: Connected to database with mysql child process (pid=9152)  
140428 10:09:02 innobackupex: Connection to database server closed  
IMPORTANT: Please check that the backup run completes successfully.  
At the end of a successful backup run innobackupex  
prints “completed OK!”.

innobackupex: Using mysql Ver 14.14 Distrib 5.1.69, for redhat-linux-gnu (x86\_64) using readline 5.1  
innobackupex: Using mysql server version Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

innobackupex: Created backup directory /backup\_mysql/2014-04-28\_10-09-02  
140428 10:09:02 innobackupex: Starting mysql with options: --user=‘root’ --unbuffered –  
140428 10:09:02 innobackupex: Connected to database with mysql child process (pid=9175)  
140428 10:09:04 innobackupex: Connection to database server closed

140428 10:09:04 innobackupex: Starting ibbackup with command: xtrabackup --defaults-group=“mysqld” --backup --suspend-at-end --target-dir=/backup\_mysql/2014-04-28\_10-09-02 --tmpdir=/cache  
innobackupex: Waiting for ibbackup (pid=9181) to suspend  
innobackupex: Suspend file ‘/backup\_mysql/2014-04-28\_10-09-02/xtrabackup\_suspended’

xtrabackup version 2.0.8 for Percona Server 5.1.59 unknown-linux-gnu (x86\_64) (revision id: 587)  
xtrabackup: uses posix\_fadvise().  
xtrabackup: cd to /var/lib/mysql  
xtrabackup: Target instance is assumed as followings.  
xtrabackup: innodb\_data\_home\_dir = ./  
xtrabackup: innodb\_data\_file\_path = ibdata1:10M:autoextend  
xtrabackup: innodb\_log\_group\_home\_dir = ./  
xtrabackup: innodb\_log\_files\_in\_group = 2  
xtrabackup: innodb\_log\_file\_size = 536870912

> > log scanned up to (44556)  
> > [01] Copying ./ibdata1 to /backup\_mysql/2014-04-28\_10-09-02/ibdata1  
> > [01] …done  
> > log scanned up to (44556)  
> > xtrabackup: Creating suspend file ‘/backup\_mysql/2014-04-28\_10-09-02/xtrabackup\_suspended’ with pid ‘9181’

140428 10:09:06 innobackupex: Continuing after ibbackup has suspended  
140428 10:09:06 innobackupex: Starting mysql with options: --user=‘root’ --unbuffered –  
140428 10:09:06 innobackupex: Connected to database with mysql child process (pid=9195)

> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > 140428 10:09:08 innobackupex: Starting to lock all tables…  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > 140428 10:09:18 innobackupex: All tables locked and flushed to disk

140428 10:09:18 innobackupex: Starting to backup non-InnoDB tables and files  
innobackupex: in subdirectories of ‘/var/lib/mysql’  
innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEvents.frm’  
innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEvents.MYI’

> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEventsProperties.MYD’  
> > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEventsProperties.frm’  
> > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/db.opt’  
> > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEventsProperties.MYI’  
> > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEvents.MYD’  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > innobackupex: Backing up files ‘/var/lib/mysql/postfix/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (40 files)  
> > innobackupex: Backing up files '/var/lib/mysql/radiusdb/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (28 files)  
> > innobackupex: Backing up files ‘/var/lib/mysql/phpbb\_optimist/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (193 files)  
> > log scanned up to (44556)  
> > innobackupex: Backing up files '/var/lib/mysql/mysql/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (69 files)  
> > innobackupex: Backing up files ‘/var/lib/mysql/wordpress/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (118 files)  
> > log scanned up to (44556)  
> > innobackupex: Backing up files '/var/lib/mysql/meganet\_new/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (82 files)  
> > innobackupex: Backing up files ‘/var/lib/mysql/meganet/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (82 files)  
> > log scanned up to (44556)  
> > innobackupex: Backing up files '/var/lib/mysql/bacula/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (76 files)  
> > log scanned up to (44556)  
> > innobackupex: Backing up file ‘/var/lib/mysql/bweb/db.opt’  
> > innobackupex: Backing up files ‘/var/lib/mysql/redmine/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (145 files)  
> > innobackupex: Backing up files '/var/lib/mysql/loganalyzer/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (34 files)  
> > innobackupex: Backing up file ‘/var/lib/mysql/lego/db.opt’  
> > innobackupex: Backing up files ‘/var/lib/mysql/zabbix/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (325 files)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > innobackupex: Backing up files '/var/lib/mysql/roundcube\_flux/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (49 files)  
> > innobackupex: Backing up files ‘/var/lib/mysql/mailscanner/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (43 files)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > innobackupex: Backing up files '/var/lib/mysql/ipplan/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (76 files)  
> > log scanned up to (44556)  
> > 140428 10:11:28 innobackupex: Finished backing up non-InnoDB tables and files

140428 10:11:28 innobackupex: Waiting for log copying to finish

xtrabackup: The latest check point (for incremental): ‘44556’  
xtrabackup: Stopping log copying thread.  
…\>\> log scanned up to (44556)

xtrabackup: Creating suspend file ‘/backup\_mysql/2014-04-28\_10-09-02/xtrabackup\_suspended’ with pid ‘9181’  
xtrabackup: Transaction log of lsn (44556) to (44556) was copied.  
140428 10:11:32 innobackupex: All tables unlocked  
140428 10:11:32 innobackupex: Waiting for ibbackup (pid=9181) to finish  
140428 10:11:32 innobackupex: Connection to database server closed

innobackupex: Backup created in directory ‘/backup\_mysql/2014-04-28\_10-09-02’  
innobackupex: MySQL binlog position: filename ‘’, position  
140428 10:11:32 innobackupex: completed OK!

---

<div class="post-metadata">

**Author:** ![leserek](https://avatars.discourse-cdn.com/v4/letter/l/8491ac/32.png) [@leserek](https://forums.percona.com/u/leserek)\
**Post date:** [April 28, 2014, 4:27am UTC](https://forums.percona.com/t/innobackupex-incremental-backup-size/3425/4 "2014-04-28T04:27:52Z")

</div>

and incremental:

innobackupex --incremental /backup\_mysql/ --incremental-basedir=/backup\_mysql/2014-04-28\_10-09-02/ --user=root

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy  
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.

This software is published under  
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

140428 10:30:09 innobackupex: Starting mysql with options: --user=‘root’ --unbuffered –  
140428 10:30:09 innobackupex: Connected to database with mysql child process (pid=10951)  
140428 10:30:15 innobackupex: Connection to database server closed  
IMPORTANT: Please check that the backup run completes successfully.  
At the end of a successful backup run innobackupex  
prints “completed OK!”.

innobackupex: Using mysql Ver 14.14 Distrib 5.1.69, for redhat-linux-gnu (x86\_64) using readline 5.1  
innobackupex: Using mysql server version Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

innobackupex: Created backup directory /backup\_mysql/2014-04-28\_10-30-15  
140428 10:30:15 innobackupex: Starting mysql with options: --user=‘root’ --unbuffered –  
140428 10:30:15 innobackupex: Connected to database with mysql child process (pid=10974)  
140428 10:30:17 innobackupex: Connection to database server closed

140428 10:30:17 innobackupex: Starting ibbackup with command: xtrabackup --defaults-group=“mysqld” --backup --suspend-at-end --target-dir=/backup\_mysql/2014-04-28\_10-30-15 --tmpdir=/cache --incremental-basedir=‘/backup\_mysql/2014-04-28\_10-09-02/’  
innobackupex: Waiting for ibbackup (pid=10980) to suspend  
innobackupex: Suspend file ‘/backup\_mysql/2014-04-28\_10-30-15/xtrabackup\_suspended’

xtrabackup version 2.0.8 for Percona Server 5.1.59 unknown-linux-gnu (x86\_64) (revision id: 587)  
incremental backup from 44556 is enabled.  
xtrabackup: uses posix\_fadvise().  
xtrabackup: cd to /var/lib/mysql  
xtrabackup: Target instance is assumed as followings.  
xtrabackup: innodb\_data\_home\_dir = ./  
xtrabackup: innodb\_data\_file\_path = ibdata1:10M:autoextend  
xtrabackup: innodb\_log\_group\_home\_dir = ./  
xtrabackup: innodb\_log\_files\_in\_group = 2  
xtrabackup: innodb\_log\_file\_size = 536870912

> > log scanned up to (44556)  
> > [01] Copying ./ibdata1 to /backup\_mysql/2014-04-28\_10-30-15/ibdata1.delta  
> > [01] …done  
> > log scanned up to (44556)  
> > xtrabackup: Creating suspend file ‘/backup\_mysql/2014-04-28\_10-30-15/xtrabackup\_suspended’ with pid ‘10980’

140428 10:30:19 innobackupex: Continuing after ibbackup has suspended  
140428 10:30:19 innobackupex: Starting mysql with options: --user=‘root’ --unbuffered –  
140428 10:30:19 innobackupex: Connected to database with mysql child process (pid=10994)

> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > 140428 10:30:21 innobackupex: Starting to lock all tables…  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > 140428 10:30:31 innobackupex: All tables locked and flushed to disk

140428 10:30:31 innobackupex: Starting to backup non-InnoDB tables and files  
innobackupex: in subdirectories of ‘/var/lib/mysql’  
innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEvents.frm’  
innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEvents.MYI’

> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEventsProperties.MYD’  
> > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEventsProperties.frm’  
> > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/db.opt’  
> > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEventsProperties.MYI’  
> > innobackupex: Backing up file ‘/var/lib/mysql/rsyslogdb/SystemEvents.MYD’  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > innobackupex: Backing up files ‘/var/lib/mysql/postfix/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (40 files)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > innobackupex: Backing up files '/var/lib/mysql/radiusdb/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (28 files)  
> > innobackupex: Backing up files ‘/var/lib/mysql/phpbb\_optimist/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (193 files)  
> > innobackupex: Backing up files '/var/lib/mysql/mysql/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (69 files)  
> > log scanned up to (44556)  
> > innobackupex: Backing up files ‘/var/lib/mysql/wordpress/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (118 files)  
> > innobackupex: Backing up files '/var/lib/mysql/meganet\_new/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (82 files)  
> > innobackupex: Backing up files ‘/var/lib/mysql/meganet/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (82 files)  
> > innobackupex: Backing up files '/var/lib/mysql/bacula/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (76 files)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > innobackupex: Backing up file ‘/var/lib/mysql/bweb/db.opt’  
> > innobackupex: Backing up files ‘/var/lib/mysql/redmine/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (145 files)  
> > innobackupex: Backing up files '/var/lib/mysql/loganalyzer/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (34 files)  
> > innobackupex: Backing up file ‘/var/lib/mysql/lego/db.opt’  
> > innobackupex: Backing up files ‘/var/lib/mysql/zabbix/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (325 files)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > innobackupex: Backing up files '/var/lib/mysql/roundcube\_flux/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (49 files)  
> > innobackupex: Backing up files ‘/var/lib/mysql/mailscanner/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (43 files)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > log scanned up to (44556)  
> > innobackupex: Backing up files '/var/lib/mysql/ipplan/_.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (76 files)  
> > 140428 10:32:52 innobackupex: Finished backing up non-InnoDB tables and files

140428 10:32:52 innobackupex: Waiting for log copying to finish

xtrabackup: The latest check point (for incremental): ‘44556’  
xtrabackup: Stopping log copying thread.  
.\>\> log scanned up to (44556)

xtrabackup: Creating suspend file ‘/backup\_mysql/2014-04-28\_10-30-15/xtrabackup\_suspended’ with pid ‘10980’  
xtrabackup: Transaction log of lsn (44556) to (44556) was copied.  
140428 10:32:56 innobackupex: All tables unlocked  
140428 10:32:56 innobackupex: Waiting for ibbackup (pid=10980) to finish  
140428 10:32:56 innobackupex: Connection to database server closed

innobackupex: Backup created in directory ‘/backup\_mysql/2014-04-28\_10-30-15’  
innobackupex: MySQL binlog position: filename ‘’, position  
140428 10:32:56 innobackupex: completed OK!

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [April 28, 2014, 10:51am UTC](https://forums.percona.com/t/innobackupex-incremental-backup-size/3425/5 "2014-04-28T10:51:30Z")

</div>

Are all of the tables you actually use MyISAM?

[www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/incremental\_backups\_innobackupex.html](https://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/incremental_backups_innobackupex.html)

> [@](#):
>
> Warning  
> This procedure only affects [XtraDB](http://www.percona.com/doc/percona-xtrabackup/2.1/glossary.html#term-xtradb) or [InnoDB](http://www.percona.com/doc/percona-xtrabackup/2.1/glossary.html#term-innodb)-based tables. Other tables with a different storage engine, e.g. [MyISAM](http://www.percona.com/doc/percona-xtrabackup/2.1/glossary.html#term-myisam), will be copied entirely each time an incremental backup is performed.