MySQL Forums
Forum List  »  Newbie

Re: BLOB storage file
Posted by: Rick James
Date: November 16, 2012 08:24PM

If you are using MyISAM:
.frm contains schema
.MYD contains data
.MYI contains indexes (they can be reconstructed from the other two files)
Those 3 files can be copied while mysql is shut down.

If you are using InnoDB:
.frm contains schema
.ibd (if present contains the data)
ibdata1 contains vital information and possibly the data.
You _cannot_ copy those files with any success. You must use some other technique, such as mysqldump.

Options: ReplyQuote


Subject
Written By
Posted
November 15, 2012 03:51AM
Re: BLOB storage file
November 16, 2012 08:24PM


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.