# Applying new incremental backup on already prepared backup

**URL:** <https://forums.percona.com/t/applying-new-incremental-backup-on-already-prepared-backup/5886>\
**Category:** Percona XtraBackup\
**Created:** [September 27, 2017, 4:59am UTC](https://forums.percona.com/t/applying-new-incremental-backup-on-already-prepared-backup/5886 "2017-09-27T04:59:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![si\_maxicoffee](https://avatars.discourse-cdn.com/v4/letter/s/ed655f/32.png) [@si\_maxicoffee](https://forums.percona.com/u/si_maxicoffee)\
**Post date:** [September 27, 2017, 4:59am UTC](https://forums.percona.com/t/applying-new-incremental-backup-on-already-prepared-backup/5886/1 "2017-09-27T04:59:13Z")

</div>

Hello datafriends,

I have a problem with xtrabackup,i cant apply an incremental backup on already prepared backup.

This is my step:  
 → Full backup ( 30gb )  
 → incremental ( 1gb )  
 → restore data on spare mysql ( ok )  
 → \*\*\*\* incremental ( 1gb ) \*\*\*\*

Try to restore from full:  
 → xtrabackup --prepare --apply-log-only --target-dir=“${full\_backup\_dir}”

Add increment:  
 → xtrabackup --prepare --apply-log-only --incremental-dir=“${increment}” --target-dir=“${full\_backup\_dir}”

Prepare dataset for restoring:  
-\>xtrabackup --prepare --target-dir=“${full\_backup\_dir}”

My problem is for the next incremental backup, i cant reuse my restored directory for my new increment:  
-\>xtrabackup --prepare --apply-log-only --incremental-dir=“${new\_increment}” --target-dir=“${full\_backup\_dir}”

xtrabackup version 2.3.3 based on MySQL server 5.6.24 Linux (x86\_64) (revision id: 525ca7d)  
incremental backup from 3814998463174 is enabled.  
xtrabackup: This target seems to be already prepared.  
xtrabackup: error: applying incremental backup needs target prepared with --apply-log-only.

For restoring the backup i need to start again from full backup and reapply all the increment and it take long time.

There is a way to undo the “xtrabackup --prepare --target-dir=”${full\_backup\_dir}" and add a new incremental backup to the full ?  
For the moment for each increment, i need to redo all step from full backup …

If i’am not clear sorry, but i think its possible to add new increment ? For the moment the only way to add my new increment is to delete all my decompressed/prepared backup and redo it from the full backup

Thanks a lot