How do you fix a MySQL “Incorrect key file” error when you can’t repair the table?

Posted by Wayne M on Server Fault See other posts from Server Fault or by Wayne M
Published on 2010-03-11T22:10:43Z Indexed on 2010/03/12 0:37 UTC
Read the original article Hit count: 438

Filed under:

I'm trying to run a rather large query that is supposed to run nightly to populate a table. I'm getting an error saying Incorrect key file for table '/var/tmp/#sql_201e_0.MYI'; try to repair it but the storage engine I'm using (whatever the default is, I guess?) doesn't support repairing tables.

how do I fix this so I can run the query? We are under pressure to get this table loaded for a client.

© Server Fault or respective owner

Related posts about mysql