ansaurus

Question

MySQL: Incorrect key file for table '/tmp/#sql_185e_0.MYI'; try to repair it

Answer 1

+1 A:

According to google - this error often related to not enough space for the drive your temporary directory is located at.

zerkms 2010-10-26 00:28:31

Thanks zerkms. It seems that the server's /tmp/ directory has no disk space left. These linux commands are useful in solving my error: fg, screen, ps -ef, free -m, top and df -lh.

marknt15 2010-10-26 01:15:53

SO markup ate the solution ;-)

zerkms 2010-10-26 01:18:31

Also, I added a PHP mysql_free_result($result) after my select statements to free some space :) Thanks

marknt15 2010-10-26 01:20:35

@marknt15: if you did not get fatal errors about not enough memory - then `mysql_free_result()` usage is not obligatory. I even would say it is pointless.

zerkms 2010-10-26 01:28:03

ansaurus

tags:

views:

answers:

MySQL: Incorrect key file for table '/tmp/#sql_185e_0.MYI'; try to repair it

related questions