maria-discuss team mailing list archive

[Marko Mäkelä <marko.makela@xxxxxxxxxxx>]

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/