General Category > General Discussion

MySQL: got error 28 from server handler

(1/1)

joseletk:
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

--- Code: ---# /etc/init.d/mysql stop
--- End code ---

OR

--- Code: ---# /etc/init.d/mysqld stop

--- End code ---
b) Check filesystem and /tmp directories:

--- Code: ---$ df -h
$ cd /tmp
$ df -h /tmp
--- End code ---

c) Remove files from /tmp to free up space:

--- Code: ---# cd /tmp
# rm -rf *

--- End code ---

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

e) Use myisamchk command to check and repair of ISAM table:

--- Code: ---# cd /var/lib/mysql
# myisamchk
--- End code ---

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

g) Start the mysql server:

--- Code: ---# /etc/init.d/mysql start

--- End code ---
OR

--- Code: ---# /etc/init.d/mysqld start

--- End code ---
================================================================

Navigation

[0] Message Index