Cameron J. Smith

I’ve continued to get errors like so

WordPress database error: [Can’t create/write to file ‘/tmp/mysqld/#sql_10b5_0.MYI’ (Errcode: 2)]

on our intranet that runs Wordpress.  I’m not quite sure how to fix this longterm yet, but here’s a diagnosis and a patch for the problem:

It seems as though every time the computer restarts the /tmp/mysqld directory is removed (either on shutdown or on reboot) and isn’t put back in place.  So here’s what you need to do to put it back

sudo mkdir /tmp/mysqld && sudo chown -R mysql.mysql /tmp/mysqld

I’m having this problem on an Ubuntu 6.06 machine so if anyone has useful suggestions about why this is being removed and how I can prevent it, please let me know.  Thanks!