# Restore of Backups faster

**URL:** <https://forums.percona.com/t/restore-of-backups-faster/8290>\
**Category:** Percona Server for MySQL\
**Created:** [November 20, 2020, 11:07am UTC](https://forums.percona.com/t/restore-of-backups-faster/8290 "2020-11-20T11:07:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ca1990](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@ca1990](https://forums.percona.com/u/ca1990)\
**Post date:** [November 20, 2020, 11:07am UTC](https://forums.percona.com/t/restore-of-backups-faster/8290/1 "2020-11-20T11:07:56Z")

</div>

Hi There

How to restore the backups fastly at Percona MySQL …Is there any specific tool…?

backup size is 200GB.

OS : Ubuntu 18 LTS

---

<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:** [November 20, 2020, 12:31pm UTC](https://forums.percona.com/t/restore-of-backups-faster/8290/2 "2020-11-20T12:31:56Z")

</div>

Hello @ca1990 , the fastest methodology for backups is doing disk-based snapshots. If this is not something you can do, the next fastest is physical backup using a tool like Percona XtraBackup. This is fast to backup and fast to restore.

The slowest method is logical, using mysqldump. This is slowest to backup and slowest to restore.

Your backup is 200GB? What style? Logical? Physical? What tool did you use to take the backup?

---

<div class="post-metadata">

**Author:** ![ca1990](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@ca1990](https://forums.percona.com/u/ca1990)\
**Post date:** [November 20, 2020, 1:47pm UTC](https://forums.percona.com/t/restore-of-backups-faster/8290/3 "2020-11-20T13:47:41Z")

</div>

@matthewb

I use percona xtrabackup.

---

<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:** [November 20, 2020, 3:49pm UTC](https://forums.percona.com/t/restore-of-backups-faster/8290/4 "2020-11-20T15:49:21Z")

</div>

If you use xtrabackup to create the backup, then you use xtrabackup to restore the backup. Check out the documentation [https://www.percona.com/doc/percona-xtrabackup/8.0/](https://www.percona.com/doc/percona-xtrabackup/8.0/) for how to do this.