# restoring from innobackupex increment backup

**URL:** <https://forums.percona.com/t/restoring-from-innobackupex-increment-backup/2254>\
**Category:** Percona XtraBackup\
**Created:** [June 8, 2012, 3:54am UTC](https://forums.percona.com/t/restoring-from-innobackupex-increment-backup/2254 "2012-06-08T03:54:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rei125](https://avatars.discourse-cdn.com/v4/letter/r/3da27b/32.png) [@rei125](https://forums.percona.com/u/rei125)\
**Post date:** [June 8, 2012, 3:54am UTC](https://forums.percona.com/t/restoring-from-innobackupex-increment-backup/2254/1 "2012-06-08T03:54:40Z")

</div>

Hi,

I’ve tried incremental backup.  
I followed the intruction below, but it just doesn’t work.  
[http://www.percona.com/doc/percona-xtrabackup/innobackupex/i ncremental\_backups\_innobackupex.html](http://www.percona.com/doc/percona-xtrabackup/innobackupex/incremental_backups_innobackupex.html)

* * *

## backup

(1) First, making a full backup

innobackupex --user=root /var/testbk/full

(2) Making incremental backup after one hour

innobackupex --user=root --incremental /var/testbk/inc --incremental-basedir=/var/testbk/full/2012-06-08\_17-38-46

* * *

## prepare

Now i would like to prepare it.

First, --apply-log --redo-only on the full backup (base)

innobackupex --user=root --apply-log --redo-only /var/testbk/full/2012-06-08\_17-38-46

The problem is next, when i tried to apply-log on the increment backup.

innobackupex --user=root --apply-log --redo-only /var/testbk/full/2012-06-08\_17-38-46 --incremental-dir=/var/testbk/inc/2012-06-08\_17-53-07

IT fails and give me the following errors.

xtrabackup: cd to /var/testbk/full/2012-06-08\_17-38-46xtrabackup: This target seems to be not prepared yet.xtrabackup: error: applying incremental backup needs target prepared.

Do i need to omit the --read-only before apply-log for the increment directory?

Thank you.

---

<div class="post-metadata">

**Author:** ![rei125](https://avatars.discourse-cdn.com/v4/letter/r/3da27b/32.png) [@rei125](https://forums.percona.com/u/rei125)\
**Post date:** [June 8, 2012, 4:07am UTC](https://forums.percona.com/t/restoring-from-innobackupex-increment-backup/2254/2 "2012-06-08T04:07:49Z")

</div>

sorry… i forgot to --apply-log for the full backup.  
What a careless mistake.

Thank you anyway.

Another question.  
As in manual,

innobackupex --apply-log --redo-only BASE-DIR --incremental-dir=INCREMENTAL-DIR-1innobackupex --apply-log BASE-DIR --incremental-dir=INCREMENTAL-DIR-2

–redo-only is only needed for first incremental?

Thank you.