MySQL Forums :: Partitioning :: EXCHANGE PARTITION and DATA DIRECTORY errors


Advanced Search

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
EXCHANGE PARTITION and DATA DIRECTORY errors 2160 Ekundayo Lasode 08/16/2014 09:47AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors 995 Mattias Jonsson 08/19/2014 03:32AM
Re: EXCHANGE PARTITION and DATA DIRECTORY errors 1014 Ekundayo Lasode 08/19/2014 06:28AM


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.