MySQL error 28 and solution

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


Revisions

No comments yet.

Leave a Reply