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: 470
mysql
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