MySQL Errcode: 2 Problem
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!
Comments(5)