How To Fix MySQL Error – Error Code 30

December 3rd, 2009 | Save to del.icio.us now(0)

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.

Related posts

  1. Simplified AJAX For WordPress Plugin Developers using Jquery
  2. Simple JavaScript ‘Frame Busting’ Code
  3. Simple Way To Add Global Exception Handling In CodeIgniter
  4. Integrating With Twitter API In CodeIgniter
  5. How to Remove Antivirus XP 2008

Wondering what to do next?
Grab my feed
Catch Me On Twitter


Filed under how too? | Comment (0)
(Search web development related contents)


Trackback URI | Comments RSS

Say Something, and Be Counted

Name (required)

Email (required)

Website

Speak your mind