MySQL Forums
Forum List  »  Partitioning

Re: Archiving Partition .MYD files
Posted by: Rick James
Date: December 12, 2009 03:48PM

These 3 files comprise a MyISAM table: .MYD (data), .frm (schema), .MYI (indexes). So, in theory, copying those three would capture the records you desire to archive.

If those files are copied to a database directory on another machine, you should be able to do SELECTs on the table.

The .par files are needed for partitioning.

I would not leave the .MYI files behind (as your statements imply).

Caveat: I have not tried any of this.

Options: ReplyQuote


Subject
Views
Written By
Posted
5600
December 11, 2009 05:41AM
2722
December 11, 2009 05:48AM
Re: Archiving Partition .MYD files
2667
December 12, 2009 03:48PM
2899
December 22, 2009 03: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.