# My MySQL database has partitions and they are stored in three different directories

**URL:** https://forums.percona.com/t/my-mysql-database-has-partitions-and-they-are-stored-in-three-different-directories/18367
**Category:** Percona XtraBackup
**Tags:** mysql
**Created:** [November 3, 2022, 6:25pm UTC](https://forums.percona.com/t/my-mysql-database-has-partitions-and-they-are-stored-in-three-different-directories/18367 "2022-11-03T18:25:30Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Mhmd\_Althaf](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mhmd_althaf/32/8253_2.png) [@Mhmd\_Althaf](https://forums.percona.com/u/Mhmd_Althaf)
#### Post date: [November 3, 2022, 6:25pm UTC](https://forums.percona.com/t/my-mysql-database-has-partitions-and-they-are-stored-in-three-different-directories/18367/1 "2022-11-03T18:25:30Z")

</div>

Hi , my MySQL database has multiple partitions and those are stored in multiple different directories. Would it still be possible to use xtrabackup to backup my database and for it to contain all the data from all those different directories?

---

<div class="post-metadata">

### Author: ![satya.bodapati](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/satya.bodapati/32/1322_2.png) [@satya.bodapati](https://forums.percona.com/u/satya.bodapati)
#### Post date: [November 3, 2022, 10:00pm UTC](https://forums.percona.com/t/my-mysql-database-has-partitions-and-they-are-stored-in-three-different-directories/18367/2 "2022-11-03T22:00:10Z")

</div>

Hello, it should work fine.  
During backup, xtrabackup will copy them to backupdir/dbname. It will also save remote tablespaces location in xtrabackup\_tablespaces file.

on copy-back/ move-back, it will move the remote tablespaces from backup dir to remote location

---

<div class="post-metadata">

### Author: ![Mhmd\_Althaf](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mhmd_althaf/32/8253_2.png) [@Mhmd\_Althaf](https://forums.percona.com/u/Mhmd_Althaf)
#### Post date: [November 4, 2022, 2:56am UTC](https://forums.percona.com/t/my-mysql-database-has-partitions-and-they-are-stored-in-three-different-directories/18367/3 "2022-11-04T02:56:19Z")

</div>

Thank you so much. Would definitely give this a go

---

<div class="post-metadata">

### Author: ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)
#### Post date: [November 4, 2022, 3:20pm UTC](https://forums.percona.com/t/my-mysql-database-has-partitions-and-they-are-stored-in-three-different-directories/18367/4 "2022-11-04T15:20:47Z")

</div>