≡ Menu

MySQL error 28 and solution

Q. I am getting an error that read as follows:

MySQL: got error 28 from server handler

How do I fix this problem?

A. This error means no space left on hard disk. According to official MySQL docs, “If you get his error, you need to check all filesystems where MySQL operates. It may be single filesystem or as we recommend you can have datadir, tmpdir and log files split into dedicated filesystems.”


a) Stop mysql server
# /etc/init.d/mysql stop
# /etc/init.d/mysqld stop
b) Check filesystem and /tmp directories:
$ df -h
$ cd /tmp
$ df -h /tmp

c) Remove files from /tmp to free up space:
# cd /tmp
# rm -rf *

d) Look into /var/log directory and remove or compress logs file.

e) Use myisamchk command to check and repair of ISAM table:
# cd /var/lib/mysql
# myisamchk

f) Increase disk space (add new hard disk or remove unwanted software(s) )

g) Start the mysql server:
# /etc/init.d/mysql start
# /etc/init.d/mysqld start

Share this tutorial on:

Your support makes a big difference:
I have a small favor to ask. More people are reading the nixCraft. Many of you block advertising which is your right, and advertising revenues are not sufficient to cover my operating costs. So you can see why I need to ask for your help. The nixCraft, takes a lot of my time and hard work to produce. If you use nixCraft, who likes it, helps me with donations:
Become a Supporter →    Make a contribution via Paypal/Bitcoin →   

Don't Miss Any Linux and Unix Tips

Get nixCraft in your inbox. It's free:

{ 10 comments… add one }
  • Peter February 2, 2010, 8:28 am

    Thank you for this! This helped save me a ‘VERY’ large headache!

  • tom July 21, 2010, 6:33 am

    Very helpful. First hit on google and saved my morning!

  • Juniefer February 21, 2011, 5:39 am

    Thanks. It was a great help indeed.

    I am saving the solution to my email.

    great help cheers

  • Stan April 18, 2011, 7:25 am


    This one thing saved my lot of time.

  • Anton July 1, 2011, 2:24 am

    Excellent guide.
    Worked perfectly to solve this headache!

  • Vaibhav Agarwal July 13, 2011, 11:58 am

    Thanks a lot. Saved a lot of time just before an important demo…

  • jose luis March 10, 2012, 6:08 pm

    Thank you very much for your information. it was very interesting for me to resolve my problem.

  • sanjay June 4, 2014, 6:11 am

    found this problem can you give a any solution
    #1030 – Got error 28 from storage engine

  • radouane December 20, 2014, 12:03 pm

    Merci :)

  • Aravinda August 22, 2016, 4:58 am

    thank you so much. very useful page

Leave a Comment

You can use these HTML tags and attributes: <strong> <em> <pre> <code> <a href="" title="">

   Tagged with: , , , , , , ,