Yesterday was one of those days when things that can go wrong went wrong and today was MySQL day, and problem when accessing any table on a live site resulted in following error
MySQL Error - Can't create/write to file '/tmp/#sql_7d3f_0.MYI' (Errcode: 30)
It took me some time to figure out that the error was due to /usr/tmpDSK getting corrupted, and and not really a problem with MySQL or our database as we were thinking all this time, and as usual google came to rescue.
Here are the steps to fix this for cpanel users… run the following commands in the order mentioned
/usr/sbin/lsof /tmp
/bin/umount -l /tmp
/bin/umount -l /var/tmp
/bin/rm -fv /usr/tmpDSK
/scripts/securetmp
This will create a new /tmp partition for you and the problem will go away. By the way error code 30 means that file system is read only.
FYI. I ran into this error today myself. It also happens if your hdd starts having errors, and goes into read-only mode… (The drive is multi-purpose, and went into read-only due to a non-mysql related activity. Have a great day.