How To Fix MySQL Error 28
MySQL: 1030: got error 28 from server handlercd /tmp df -i /tmp df -h /tmp
Delete anything that’s not supposed to be there.
Stop all databases:
/etc/rc.d/init.d/chkservd stop /etc/rc.d/init.d/mysql stop
Then fix tables:
cd /var/lib/mysql
Check each letter for errors:
myisamchk -cs a*/*.MYI
Repair where necessary:
myisamchk -r a*/*.MYI myisamchk -r b*/*.MYI myisamchk -r c*/*.MYI myisamchk -r d*/*.MYI myisamchk -r e*/*.MYI myisamchk -r f*/*.MYI myisamchk -r g*/*.MYI myisamchk -r h*/*.MYI myisamchk -r i*/*.MYI myisamchk -r j*/*.MYI myisamchk -r k*/*.MYI myisamchk -r l*/*.MYI myisamchk -r m*/*.MYI myisamchk -r n*/*.MYI myisamchk -r o*/*.MYI myisamchk -r p*/*.MYI myisamchk -r q*/*.MYI myisamchk -r r*/*.MYI myisamchk -r s*/*.MYI myisamchk -r t*/*.MYI myisamchk -r u*/*.MYI myisamchk -r v*/*.MYI myisamchk -r w*/*.MYI myisamchk -r x*/*.MYI myisamchk -r y*/*.MYI myisamchk -r z*/*.MYI
Turn everything back on:
/etc/rc.d/init.d/chkservd start /etc/rc.d/init.d/mysql start