This error means no space left on hard disk. If you get his error, you need to check all filesystems where MySQL operates.

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 softwares)

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