MySQL Forums
Forum List  »  Partitioning

Re: Exchange MyISAM partitions in MySQL 5.1
Posted by: Mattias Jonsson
Date: March 21, 2011 04:03PM

This is in no way supported :)

(TRUNCATE PARTITION is in 5.5, and EXCHANGE PARTITION is in mysql-trunk)

You can also do CREATE TABLE t2 LIKE t1 or do a SHOW CREATE TABLE t1 and create the table from it.

What you also would need to do is to FLUSH TABLES and lock the tables BEFORE you start moving the files around.

I can however not see any problems with it. Since you only swap MyISAM files between the same partition definition (but different tables), the data will match the partition.

But as I said, you are on your own when moving the files around!

Options: ReplyQuote

Written By
Re: Exchange MyISAM partitions in MySQL 5.1
March 21, 2011 04:03PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.