# Restoring Incrementals, with full backup stored on remote location

**URL:** <https://forums.percona.com/t/restoring-incrementals-with-full-backup-stored-on-remote-location/29556>\
**Category:** Percona XtraDB Cluster 5.x\
**Tags:** mysql, percona\
**Created:** [April 5, 2024, 7:41am UTC](https://forums.percona.com/t/restoring-incrementals-with-full-backup-stored-on-remote-location/29556 "2024-04-05T07:41:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![AK\_Work](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ak_work/32/15733_2.png) [@AK\_Work](https://forums.percona.com/u/AK_Work)\
**Post date:** [April 5, 2024, 7:41am UTC](https://forums.percona.com/t/restoring-incrementals-with-full-backup-stored-on-remote-location/29556/1 "2024-04-05T07:41:35Z")

</div>

Hello All,  
My use case is as follows, I need to store the backups taken to a remote location for which I stream the output of the backup to another host storage location using the xbstream binary. Now when I need to take an incremental backup. I figured out that we will need xtrabackup\_checkpoint, Then I just copied the xtrabackup\_checkpoints of the previous full backup and was able to run incrementals.

Is this the standard method to do so? Or am I missing something?

I understand that in the docs it is mentioned that we need to point to the previous full backup to take the incremental using the --incremental-basedir flag, But for my use case I need to stream the full backup elsewhere.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [April 5, 2024, 4:17pm UTC](https://forums.percona.com/t/restoring-incrementals-with-full-backup-stored-on-remote-location/29556/2 "2024-04-05T16:17:51Z")

</div>

Hello @AK_Work,  
You are correct in that all you need is the xtrabackup\_checkpoints file in order to take incrementals.

---

<div class="post-metadata">

**Author:** ![AK\_Work](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ak_work/32/15733_2.png) [@AK\_Work](https://forums.percona.com/u/AK_Work)\
**Post date:** [April 6, 2024, 8:04am UTC](https://forums.percona.com/t/restoring-incrementals-with-full-backup-stored-on-remote-location/29556/3 "2024-04-06T08:04:04Z")

</div>

Hey @matthewb  
Thanks for the confirmation. The second part of the question now would be can I re-create that file using the logs that xtrabackup generates while taking a backup? Coz in the case of streaming the output of the backup, we’ll not the xtrabackup\_checkpoints readily available correct?

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [April 6, 2024, 2:24pm UTC](https://forums.percona.com/t/restoring-incrementals-with-full-backup-stored-on-remote-location/29556/4 "2024-04-06T14:24:49Z")

</div>

@AK_Work,  
Use this parameter, [The xtrabackup command-line options - Percona XtraBackup](https://docs.percona.com/percona-xtrabackup/8.0/xtrabackup-option-reference.html#extra-lsndir) during your backup process to store an extra copy of the checkpoints file locally, which can be used as a further incremental base.

---

<div class="post-metadata">

**Author:** ![AK\_Work](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ak_work/32/15733_2.png) [@AK\_Work](https://forums.percona.com/u/AK_Work)\
**Post date:** [April 7, 2024, 5:41pm UTC](https://forums.percona.com/t/restoring-incrementals-with-full-backup-stored-on-remote-location/29556/5 "2024-04-07T17:41:53Z")

</div>

Thanks @matthewb. This helps