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.
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.