MySQL Forums
Forum List  »  Data Recovery

Incorrect key file for table
Posted by: Tomasz Fiedor
Date: September 14, 2011 06:45AM

when I try to make a query on my database that uses multiple tables it sometimes returns that kind of error: "Incorrect key file for table '/tempfs/#sql_2747_0.MYI'; try to repair it". But when I limit data with WHERE it is sometimes returning good result. I tried backuping and restoring db in other schema and repairing the only one myisam table that is in this query.

Options: ReplyQuote

Written By
Incorrect key file for table
September 14, 2011 06:45AM

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.