Moving partitioned tables between MySQL 5.6 instances (transportable tablespaces)

MySQL & MariaDB Other MySQL® Questions
1

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] ). 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

2

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.