# Restore a full backup using different version of xtrabackup

**URL:** <https://forums.percona.com/t/restore-a-full-backup-using-different-version-of-xtrabackup/34477>\
**Category:** Percona XtraBackup\
**Tags:** mysql, percona\
**Created:** [October 20, 2024, 2:22pm UTC](https://forums.percona.com/t/restore-a-full-backup-using-different-version-of-xtrabackup/34477 "2024-10-20T14:22:40Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Muhammad\_Hamza\_Khan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/muhammad_hamza_khan/32/18575_2.png) [@Muhammad\_Hamza\_Khan](https://forums.percona.com/u/Muhammad_Hamza_Khan)\
**Post date:** [October 20, 2024, 2:22pm UTC](https://forums.percona.com/t/restore-a-full-backup-using-different-version-of-xtrabackup/34477/1 "2024-10-20T14:22:40Z")

</div>

Hello!  
My database is running mysql 8.0.26, I take its full backup using percona xtrabackup 8.0.26.  
Can i restore this backup on a different server running mysql 8.0.35 using percona xtrabackup 8.0.35?

---

<div class="post-metadata">

**Author:** ![Wayne\_Leutwyler](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wayne_leutwyler/32/20829_2.png) [@Wayne\_Leutwyler](https://forums.percona.com/u/Wayne_Leutwyler)\
**Post date:** [October 20, 2024, 3:34pm UTC](https://forums.percona.com/t/restore-a-full-backup-using-different-version-of-xtrabackup/34477/2 "2024-10-20T15:34:43Z")

</div>

Yes, a backup taken with Percona XtraBackup version 8.0.26 can generally be restored using Percona XtraBackup version 8.0.35. XtraBackup is designed to be forward-compatible across minor version upgrades within the same major release (8.0 in this case), which means backups taken with an earlier minor version can be restored using a later minor version.

However, there are some key considerations:

- **Review Release Notes** : Check the Percona XtraBackup release notes for both versions to ensure no significant changes impact the restore process.
- **Compatibility Testing** : Perform a test restore in a non-production environment to confirm the process works without issues.
- **MySQL Server Version Compatibility** : Ensure that the MySQL or Percona Server version used matches the backup requirements, as database server versions may have additional requirements.

Generally, Percona XtraBackup maintains compatibility across minor releases within the same major version.

I strongly recommend you test in a lower environment before you restore your production database.

---

<div class="post-metadata">

**Author:** ![dogs\_Cute](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/dogs_cute/32/12754_2.png) [@dogs\_Cute](https://forums.percona.com/u/dogs_Cute)\
**Post date:** [October 21, 2024, 1:22am UTC](https://forums.percona.com/t/restore-a-full-backup-using-different-version-of-xtrabackup/34477/3 "2024-10-21T01:22:40Z")

</div>

use same version to restore. then upgrade db and pxb version

---

<div class="post-metadata">

**Author:** ![Muhammad\_Hamza\_Khan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/muhammad_hamza_khan/32/18575_2.png) [@Muhammad\_Hamza\_Khan](https://forums.percona.com/u/Muhammad_Hamza_Khan)\
**Post date:** [October 21, 2024, 4:10am UTC](https://forums.percona.com/t/restore-a-full-backup-using-different-version-of-xtrabackup/34477/5 "2024-10-21T04:10:38Z")

</div>

Wish I could, second machine is el9 and I cant go below 8.0.30 on el9 so I would have to make a new machine to do this…

---

<div class="post-metadata">

**Author:** ![Muhammad\_Hamza\_Khan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/muhammad_hamza_khan/32/18575_2.png) [@Muhammad\_Hamza\_Khan](https://forums.percona.com/u/Muhammad_Hamza_Khan)\
**Post date:** [October 21, 2024, 4:14am UTC](https://forums.percona.com/t/restore-a-full-backup-using-different-version-of-xtrabackup/34477/6 "2024-10-21T04:14:28Z")

</div>

Thanks for the reply! Will test it first as suggested.

---

<div class="post-metadata">

**Author:** ![Yunus](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yunus/32/6430_2.png) [@Yunus](https://forums.percona.com/u/Yunus)\
**Post date:** [October 21, 2024, 4:28am UTC](https://forums.percona.com/t/restore-a-full-backup-using-different-version-of-xtrabackup/34477/7 "2024-10-21T04:28:55Z")

</div>

PXB 8.0.29 release note mention this point

_Percona XtraBackup_ 8.0.29-22 adds new redo log types to support the changes in the `INSTANT` algorithm behavior. _MySQL_ 8.0.29 extended the support for `ALGORITHM=INSTANT` to allow columns to be added to any position in a table and column drops. Older versions of _Percona XtraBackup_ are incompatible with _MySQL_ 8.0.29 because of this new functionality.

---

<div class="post-metadata">

**Author:** ![CTutte](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ctutte/32/1341_2.png) [@CTutte](https://forums.percona.com/u/CTutte)\
**Post date:** [October 21, 2024, 1:48pm UTC](https://forums.percona.com/t/restore-a-full-backup-using-different-version-of-xtrabackup/34477/8 "2024-10-21T13:48:52Z")

</div>

To sum up;

For MySQL/PXB 8.0 and newer the safest and suggested approach is to restore with same PXB into same MySQL version and then upgrade.

For your specific version (8.0.26) you should do the above.  
For newer versions it might work as long as there is no incompatible change but the suggestion is to stick to same version

Regards
