MySQL Forums
Forum List  »  Partitioning

Re: Partition data backup and restore
Posted by: Mattias Jonsson
Date: October 18, 2013 02:59AM

1 + 2:
Seems like you are looking for EXCHANGE PARTITION:
http://dev.mysql.com/doc/refman/5.6/en/partitioning-management-exchange.html

That way you can EXCHANGE a partition with an empty table and then drop the (now) empty partition, or exchange the table back as the original partition.

3:
Yes if innodb-file-per-table is set, then each partition will have its own .ibd file (and can use DATA_DIRECTORY option). For archiving an innodb partition I recommend EXCHANGE PARTITION + DROP PARTITITION + FLUSH TABLES ... FOR EXPORT + ALTER TABLE DISCARD TABLESPACE.
See more about transportable tablespaces:
http://dev.mysql.com/doc/refman/5.6/en/glossary.html#glos_transportable_tablespace

Options: ReplyQuote


Subject
Views
Written By
Posted
10242
October 18, 2013 12:48AM
Re: Partition data backup and restore
4655
October 18, 2013 02:59AM


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.