MySQL Forums
Forum List  »  Install & Repo

Re: Recover database from *.frm files?
Posted by: Harrison Fisk
Date: October 27, 2004 05:38PM


Unfortunately, the .frm file contains only the table structure itself. The data is stored in other files, which it sounds like you don't have. There should have been two other files for each table, a MYD and a MYI (assuming you were using MyISAM, if not, might be different files). Regardless, without those extra files, you can't get the data back, since the data isn't in them.

In the future you should either use mysqldump or just copy the entire datadir contents (all files in it, not just .frm's)

Sorry for your loss!

Harrison Fisk, Trainer and Consultant

Options: ReplyQuote

Written By
Re: Recover database from *.frm files?
October 27, 2004 05:38PM

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.