How to Move a MySQL Partition from One Table to Another.md 784 B
Title: "How to Move a MySQL Partition from One Table to Another" Date: 2017-01-12 16:20:00 Categories: [data base] tags: [mysql, mariadb, percona]
Authors: sedlav
In this blog post we’ll look at how to move a MySQL partition from one table to another, for MySQL versions before 5.7.
Up to version 5.7, MySQL had a limitation that made it impossible to directly exchange partitions between partitioned tables. Now and then, we get questions about how to import an .ibd for use as a partition in a table, as well as how to exchange partitions with another partitioned table. Below is step-by-step instructions on how to move a partition from one table to another.