Not the answer you need?
Register and ask your own question!

Moving partitioned tables between MySQL 5.6 instances (transportable tablespaces)

rreddyrreddy ContributorCurrent User Role Beginner
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 ( http://dev.mysql.com/doc/refman/5.6/en/tablespace-copying.html ). 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

Comments

  • rreddyrreddy Contributor Current User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.