MySQL Forums :: Database Administration & Monitoring :: how to recover .frm

Advanced Search

how to recover .frm
Posted by: Michael Nino ()
Date: October 14, 2004 12:30AM

The table in question cannot be queried because MySQL says it cannot find the .frm file (1017 error). The file is obviously there. And this started happening since our software crashed. Running myisamchk doesn't resolve the issue. The data and index seem to be unaffected. We do not have a backup that doesn't exhibit the same issue. We'd like to know what is happening but would settle for how to recreate the structure so we can once again query that table. Currently, we can get to our data!!!

Options: ReplyQuote

Subject Written By Posted
how to recover .frm Michael Nino 10/14/2004 12:30AM

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.