# Use Xtrabackup for multiple databases - full and incremental

**URL:** <https://forums.percona.com/t/use-xtrabackup-for-multiple-databases-full-and-incremental/16237>\
**Category:** Percona XtraBackup\
**Created:** [June 21, 2022, 10:49am UTC](https://forums.percona.com/t/use-xtrabackup-for-multiple-databases-full-and-incremental/16237 "2022-06-21T10:49:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![khaledhu](https://avatars.discourse-cdn.com/v4/letter/k/ac91a4/32.png) [@khaledhu](https://forums.percona.com/u/khaledhu)\
**Post date:** [June 21, 2022, 10:49am UTC](https://forums.percona.com/t/use-xtrabackup-for-multiple-databases-full-and-incremental/16237/1 "2022-06-21T10:49:46Z")

</div>

Hello,  
I moved from MySQL 5.7 to Percona 8 MySQL, and I am planing to use xtrabackup to do the full and incremental backups, I have many databases around 1500 database, and I need to have a backup for each database and keep it for longtime, so I need to take a full backup per database once a week and diff for the rest of the week, does xtrabackup do this and how to do it, if there is a good documentation how to take backup per database and how to restore it

Thanks

---

<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:** [June 21, 2022, 11:15am UTC](https://forums.percona.com/t/use-xtrabackup-for-multiple-databases-full-and-incremental/16237/2 "2022-06-21T11:15:50Z")

</div>

Hi, xtrabackup can do this. Check out [Partial Backups - Percona XtraBackup](https://docs.percona.com/percona-xtrabackup/8.0/xtrabackup_bin/partial_backups.html)

---

<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:** [June 21, 2022, 12:53pm UTC](https://forums.percona.com/t/use-xtrabackup-for-multiple-databases-full-and-incremental/16237/3 "2022-06-21T12:53:56Z")

</div>

A physical backup for each of 1500 databases will be a nightmare to manage. Do you really want to mess with 1500 separate backups each week, plus 1500 incrementals every day?

If you truly need separate backups for each 1,500 individual databases, I would recommend you use [mydumper](https://github.com/mydumper/mydumper). I believe the management of all the backup files will be easier and single-database restore would be FAR EASIER with mydumper.