problem with the MYSQL database

[ivantravis]

Hello,
I work with the mysql database for a couple of months now could not open it, because there was an error: “Incorrect key file for table: '...'. Try to repair it”
Who can tell how open the database?
Thanks to all.

 

[Mynight]

I've seen this come up before when a query returns a huge dataset beyond what the temp file is capable of storing. ie a lack of diskspace or a hard limit on the amount of space available to the temp.

Edit: should ask have you had a crash recently?

Is it a large database?

Has it always returned this error or is it a new occurance? If the latter any changes software wise?

 

[celliott]

Did you get this fixed? If not first thing to do is check/repair the tables:

mysqlcheck -r <database> -u<user> -p<pass>

Or run with -c instead of -r if you want to see the results before it attempts repairs.