MySQL error 28 and solution

Posted on in Categories , , , , , , , , , last updated December 17, 2007

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.”

Solution

a) Stop mysql server
# /etc/init.d/mysql stop
OR
# /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
OR
# /etc/init.d/mysqld start

Posted by: Vivek Gite

The author is the creator of nixCraft and a seasoned sysadmin and a trainer for the Linux operating system/Unix shell scripting. He has worked with global clients and in various industries, including IT, education, defense and space research, and the nonprofit sector. Follow him on Twitter, Facebook, Google+.

Share this on (or read 10 comments/add one below):

10 comment

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

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

Comments are closed.