Re: Recover database from *.frm files?

[Harrison Fisk]

Hi,

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
MySQL AB, www.mysql.com