# innobackupex/xtrabackup and partitioned tables?

**URL:** <https://forums.percona.com/t/innobackupex-xtrabackup-and-partitioned-tables/7232>\
**Category:** Percona Toolkit\
**Created:** [October 9, 2019, 2:06am UTC](https://forums.percona.com/t/innobackupex-xtrabackup-and-partitioned-tables/7232 "2019-10-09T02:06:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![j4nd3r53n](https://avatars.discourse-cdn.com/v4/letter/j/3d9bf3/32.png) [@j4nd3r53n](https://forums.percona.com/u/j4nd3r53n)\
**Post date:** [October 9, 2019, 2:06am UTC](https://forums.percona.com/t/innobackupex-xtrabackup-and-partitioned-tables/7232/1 "2019-10-09T02:06:15Z")

</div>

Sorry, I’m rather new to this, so please forgive if I ask something obvious (I have searched, but came up blank). So, I have inherited a number of mysql databases with backups stretching back several years. The backups are of single databases (MySQL 5.5), mostly, and they all contain partitioned tables. As I understand it, in order to restore a single database, I have to do it table by table, but right now I’m blocked at the partitioned tables - I’m trying to extract the table definitions with mysqlfrm, which dosn’t seem to understand the partitioned files. I know this program isn’t developed by Percona, but I’m a bit worried that there may be problems waiting later on, when I try to import partitioned tables (?)

And, of course, if somebody around here knows mysqlfrm and can help me with that, that would be great too!

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [October 9, 2019, 8:47am UTC](https://forums.percona.com/t/innobackupex-xtrabackup-and-partitioned-tables/7232/2 "2019-10-09T08:47:28Z")

</div>

Hello [j4nd3r53n](https://www.percona.com/forums/member/43245-j4nd3r53n) thanks for reaching out. Looks like you’ve inherited an old set up there…  
What version of innobackupex are you using?  
I found this recipes link which may help you, if not come back and I will see if I can find someone who can help you out. [URL][Percona XtraBackup](https://www.percona.com/doc/percona-xtrabackup/2.2/_sources/howtos/recipes_ibkx_partition.txt%5B/URL%5D)

---

<div class="post-metadata">

**Author:** ![j4nd3r53n](https://avatars.discourse-cdn.com/v4/letter/j/3d9bf3/32.png) [@j4nd3r53n](https://forums.percona.com/u/j4nd3r53n)\
**Post date:** [October 10, 2019, 8:42am UTC](https://forums.percona.com/t/innobackupex-xtrabackup-and-partitioned-tables/7232/3 "2019-10-10T08:42:17Z")

</div>

$ innobackupex -v  
innobackupex version 2.4.9 Linux (x86\_64) (revision id: a467167cdd4)

---

<div class="post-metadata">

**Author:** ![j4nd3r53n](https://avatars.discourse-cdn.com/v4/letter/j/3d9bf3/32.png) [@j4nd3r53n](https://forums.percona.com/u/j4nd3r53n)\
**Post date:** [October 10, 2019, 8:45am UTC](https://forums.percona.com/t/innobackupex-xtrabackup-and-partitioned-tables/7232/4 "2019-10-10T08:45:08Z")

</div>

Thank you for the link - I’ll study it is detail
