MySQL Forums
Forum List  »  Partitioning

Re: How to (temporary) disable one partition in the partitioned table
Posted by: Rick James
Date: February 22, 2013 01:00AM

MyISAM? Rename the .MYD and .MYI files.
InnoDB and file_per_table? Rename the .ibd file.
However, I can't be sure that the subsequent rename(s) will adequately restore the PARTITIONed table.

Do you have the PARTITION on a different device? Generally, that is not a good idea.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to (temporary) disable one partition in the partitioned table
1770
February 22, 2013 01:00AM


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.