Note to self: MySQL error 28 and /tmp size

#1030 – Got error 28 from storage engine

This means there is no space left on the drive, usually this means your /tmp

If you use cPanel, your /tmp could be mounted from /usr/tmpDSK, this is a file. If you want to increase this file you can type these following commands, change count=512000 to any number thats match your need.

The command dd if=/dev/zero of=/usr/tmpDSK bs=1024 count=512000 is used to create a file whose size is 512000 x 1024 bytes (or approx. 512MB).

service httpd stop

service mysql stop

umount /tmp

umount /var/tmp

dd if=/dev/zero of=/usr/tmpDSK bs=1024 count=512000

mkfs.ext3 /usr/tmpDSK

press ‘y’ to continue

mount -o loop,rw,noexec,nosuid /usr/tmpDSK /tmp

mount -o bind,rw,noexec,nosuid /tmp /var/tmp

service mysql start

service httpd start