# Moving partitioned tables between MySQL 5.6 instances (transportable tablespaces)

**URL:** <https://forums.percona.com/t/moving-partitioned-tables-between-mysql-5-6-instances-transportable-tablespaces/3375>\
**Category:** Other MySQL® Questions\
**Created:** [April 1, 2014, 2:03pm UTC](https://forums.percona.com/t/moving-partitioned-tables-between-mysql-5-6-instances-transportable-tablespaces/3375 "2014-04-01T14:03:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rreddy](https://avatars.discourse-cdn.com/v4/letter/r/49beb7/32.png) [@rreddy](https://forums.percona.com/u/rreddy)\
**Post date:** [April 1, 2014, 2:03pm UTC](https://forums.percona.com/t/moving-partitioned-tables-between-mysql-5-6-instances-transportable-tablespaces/3375/1 "2014-04-01T14:03:00Z")

</div>

Hi, I would like to know if there is anyway of moving a partitioned InnoDB table from one MySQL 5.6 instance to another, moving regular InnoDB tables is straightforward using transportable tablespaces ( [url][http://dev.mysql.com/doc/refman/5.6/en/tablespace-copying.html[/url]](http://dev.mysql.com/doc/refman/5.6/en/tablespace-copying.html%5B/url%5D) ). but there are limitations to this procedure that it only applies to regular tables and not partitioned tables.

Is anyone aware of a way of moving such tables, partial mysql backups?

Appreciate your help.

Regards,  
Ramki

---

<div class="post-metadata">

**Author:** ![rreddy](https://avatars.discourse-cdn.com/v4/letter/r/49beb7/32.png) [@rreddy](https://forums.percona.com/u/rreddy)\
**Post date:** [April 1, 2014, 2:05pm UTC](https://forums.percona.com/t/moving-partitioned-tables-between-mysql-5-6-instances-transportable-tablespaces/3375/2 "2014-04-01T14:05:18Z")

</div>

I cannot use mysqldump as these tables are very large with billions of records, we need these copied to our test system for each release.
