# Innobackupex incremental backup not work

**URL:** <https://forums.percona.com/t/innobackupex-incremental-backup-not-work/2288>\
**Category:** Percona XtraBackup\
**Created:** [September 11, 2012, 12:11am UTC](https://forums.percona.com/t/innobackupex-incremental-backup-not-work/2288 "2012-09-11T00:11:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![irmorteza](https://avatars.discourse-cdn.com/v4/letter/i/e47c2d/32.png) [@irmorteza](https://forums.percona.com/u/irmorteza)\
**Post date:** [September 11, 2012, 12:11am UTC](https://forums.percona.com/t/innobackupex-incremental-backup-not-work/2288/1 "2012-09-11T00:11:54Z")

</div>

Hi  
I have a problem on restoring myincremental backup.

I did Following:  
First, I make full backup in day one:  
innobackupex -user=root -password=123 --no-timestamp mysqlbackup/incremental/base  
innobackupex -user=root -password=123 --apply-log --redo-only mysqlbackup/incremental/base

then after some changes in day two I make a incremental in day two:  
innobackupex -user=root -password=123 --no-timestamp --incremental mysqlbackup/incremental/inc01 --incremental-basedir=mysqlbackup/incremental/base  
innobackupex -user=root -password=123 --apply-log mysqlbackup/incremental/base --incremental-basedir=mysqlbackup/incremental/inc01  
innobackupex --apply-log mysqlbackup/incremental/base

And, restored it in day 3:  
/etc/init.d/mysqld stop  
mv /var/lib/mysql/ /var/lib/mysql-old  
innobackupex -user=root -password=123 --copy-back mysqlbackup/incremental/base  
chown -R mysql:mysql /var/lib/mysql/  
/etc/init.d/mysqld start

But i were wondered when I see, the changes of day two (incremental backup) not applied to backup.  
Does anyone know what the problem is?  
Thanks in advance  
morteza.

Software and versions  
CentOS 6.2  
Mysql 5.1  
xtrabackup : last version from percona repository ,last weak

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [September 18, 2012, 12:49am UTC](https://forums.percona.com/t/innobackupex-incremental-backup-not-work/2288/2 "2012-09-18T00:49:47Z")

</div>

Hi Morteza,

I have tested locally and it works fine for me. There is only one change in steps. While applying incremental backup to the base backup, you are using this.

innobackupex -user=root -password=123 --apply-log mysqlbackup/incremental/base –incremental-basedir=mysqlbackup/incremental/inc01

and I’m using this.

innobackupex -user=root -password=123 --apply-log –redo-only mysqlbackup/incremental/base –incremental-dir=mysqlbackup/incremental/inc01

Reference: [http://www.percona.com/doc/percona-xtrabackup/howtos/recipes](http://www.percona.com/doc/percona-xtrabackup/howtos/recipes) \_ibkx\_inc.html

Can you try again with above step and check? thanks.

---

<div class="post-metadata">

**Author:** ![irmorteza](https://avatars.discourse-cdn.com/v4/letter/i/e47c2d/32.png) [@irmorteza](https://forums.percona.com/u/irmorteza)\
**Post date:** [September 20, 2012, 3:57am UTC](https://forums.percona.com/t/innobackupex-incremental-backup-not-work/2288/3 "2012-09-20T03:57:14Z")

</div>

Hi niljoshi and thanks for replying.

i applied new changes, but when i run:  
innobackupex -user=root -password=123 --apply-log --redo-only mysqlbackup/incremental/base --incremental-dir=mysqlbackup/incremental/inc01  
it error!!

* * *

the error content is:  
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy  
and Percona Inc 2009-2012. All Rights Reserved.

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

IMPORTANT: Please check that the apply-log run completes successfully.  
At the end of a successful apply-log run innobackupex  
prints “completed OK!”.

120920 13:22:46 innobackupex: Starting ibbackup with command: xtrabackup\_55 --defaults-file="/root/mysqlbackup/incremental/base/backup-my.cnf " --defaults-group=“mysqld” --prepare --target-dir=/root/mysqlbackup/incremental/base --apply-log-only --incremental-dir=mysqlbackup/incremental/inc01

xtrabackup\_55 version 2.0.2 for Percona Server 5.5.16 Linux (x86\_64) (revision id: 461)  
incremental backup from 2725276 is enabled.  
xtrabackup: cd to /root/mysqlbackup/incremental/base  
xtrabackup: This target seems to be already prepared.  
120920 13:22:46 InnoDB: Operating system error number 2 in a file operation.  
InnoDB: The error means the system cannot find the path specified.  
xtrabackup: Warning: cannot open mysqlbackup/incremental/inc01/xtrabackup\_logfile. will try to find.  
120920 13:22:46 InnoDB: Operating system error number 2 in a file operation.  
InnoDB: The error means the system cannot find the path specified.  
xtrabackup: Fatal error: cannot find mysqlbackup/incremental/inc01/xtrabackup\_logfile.  
xtrabackup: Error: xtrabackup\_init\_temp\_log() failed.  
innobackupex: Error:  
innobackupex: ibbackup failed at /usr/bin/innobackupex line 374.

* * *

* * *

the directory of mysqlbackup/incremental/inc01 contains below files:  
mysql [dir]  
mydb [dir]  
backup-my.cnf  
ibdata1.delta  
ibdata1.meta  
xtrabackup\_binary  
xtrabackup\_binlog\_info  
xtrabackup\_checkpoints  
xtrabackup\_logfile

thanks.  
morteza