# Xtrabackup query

**URL:** <https://forums.percona.com/t/xtrabackup-query/17217>\
**Category:** Percona XtraBackup\
**Created:** [August 30, 2022, 11:51am UTC](https://forums.percona.com/t/xtrabackup-query/17217 "2022-08-30T11:51:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pankaj\_Vare](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pankaj_vare/32/7319_2.png) [@Pankaj\_Vare](https://forums.percona.com/u/Pankaj_Vare)\
**Post date:** [August 30, 2022, 11:51am UTC](https://forums.percona.com/t/xtrabackup-query/17217/1 "2022-08-30T11:51:32Z")

</div>

how can i merge incemental backup with previous incremental backup rather than full backup in percona xtrabackup

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [August 31, 2022, 2:08pm UTC](https://forums.percona.com/t/xtrabackup-query/17217/2 "2022-08-31T14:08:05Z")

</div>

Hello, I am assuming you mean at restore time? you should apply incrementals in order as the following:

```auto
xtrabackup --prepare --apply-log-only --target-dir=BASE-DIR
xtrabackup --prepare --apply-log-only --target-dir=BASE-DIR --incremental-dir=INCREMENTAL-DIR-1
xtrabackup --prepare --apply-log-only --target-dir=BASE-DIR --incremental-dir=INCREMENTAL-DIR-2

```

when you reach the last incremental, run it as follows:

`xtrabackup --prepare --target-dir=BASE-DIR --incremental-dir=INCREMENTAL-DIR-3`

If you are talking about the backup phase, the incremental of an incremental is taken as follows:

```auto
xtrabackup --backup --target-dir=INCREMENTAL-DIR-2 --incremental-basedir=INCREMENTAL-DIR-1

```