MySQL Forums
Forum List  »  Partitioning

Re: EXCHANGE PARTITION and DATA DIRECTORY errors
Posted by: Mattias Jonsson
Date: August 19, 2014 03:32AM

To overcome this limitation you can use use FLUSH FOR EXPORT + ALTER TABLE DISCARD/IMPORT TABLESPACE:
http://dev.mysql.com/doc/refman/5.6/en/tablespace-copying.html
and in 5.7 it will be expanded to also be per partition:
http://dev.mysql.com/doc/refman/5.7/en/tablespace-copying.html

The reason for not allowing mismatching DATA/INDEX DIRECTORY in EXCHANGE PARTITION is to avoid copying data between different file systems and that ordinary ALTER TABLE does not allow DATA/INDEX DIRECTORY to be altered.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: EXCHANGE PARTITION and DATA DIRECTORY errors
1149
August 19, 2014 03:32AM


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.