Announcement

Announcement Module
Collapse
No announcement yet.

Moving partitioned tables between MySQL 5.6 instances (transportable tablespaces)

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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/...e-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

  • #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.

    Comment

    Working...
    X