Membership Membership:
Latest New User Latest: vpros
Past 24 Hours Past 24 Hours: 0
Prev. 24 Hours Prev. 24 Hours: 0
User Count Overall: 137

People Online People Online:
Visitors Visitors: 61
Members Members: 0
Total Total: 61

NakedMCSE Computer Tech Support Forums

So you have passed all of the exams and you are now out in the real world of windows servers, linux servers and freebsd servers faced with a tech support problem you have never seen before...

Find free online tech support in the forums below, respecting that advice is free, but work beyond advice is not...

The General forum is provided for off topic discussion.

You need a user account to post - please Register or Login.

Online Tech Support Forums
 
  Forum  Open Source Tec...  MySQL Server  mysqld: Incorrect key file for table '/tmp/#sql_6fef_315.MYI'; try to repair it error
Previous Previous
 
Next Next
New Post 5/13/2011 2:55 PM
Informative
  Walker
119 posts
www.lairdscomputer.com
10th Level Poster


mysqld: Incorrect key file for table '/tmp/#sql_6fef_315.MYI'; try to repair it error 

If you see errors like the following in your mysqld log:

110512  9:28:02 [ERROR] /usr/libexec/mysqld: Incorrect key file for table '/tmp/#sql_6fef_315.MYI'; try to repair it
110512  9:28:02 [ERROR] /usr/libexec/mysqld: Incorrect key file for table '/tmp/#sql_6fef_131.MYI'; try to repair it

Then you need to change where your temp tables are being created.  It means that the temp tables are overflowing the assigned filesystem space.

Edit your /etc/my.cnf file with the following to change the location of the temp area:

tmpdir = /var/tmp

Walker
www.lairdscomputer.com

 
Previous Previous
 
Next Next
  Forum  Open Source Tec...  MySQL Server  mysqld: Incorrect key file for table '/tmp/#sql_6fef_315.MYI'; try to repair it error
Send me One Million FREE Guaranteed Visitors