17 Jan
2018
17 Jan
'18
2:09 p.m.
Hi Conor, Did you try the following? ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2; It might allow you to work around the problem. You'd first need to convert the partitions to tables, then export and import the .ibd files, and finally exchange with partitions again. Disclaimer: I only know InnoDB, not partitioning. I hope that this will actually only rename the tables inside InnoDB. (In InnoDB, each partition is treated as a separate table.) Marko -- Marko Mäkelä, Lead Developer InnoDB MariaDB Corporation DON’T MISS M|18 MariaDB User Conference February 26 - 27, 2018 New York City https://m18.mariadb.com/