Re: Exchange MyISAM partitions in MySQL 5.1
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!
Subject
Views
Written By
Posted
3465
March 21, 2011 12:43PM
Re: Exchange MyISAM partitions in MySQL 5.1
2041
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.