MySQL Error 28
How To Fix MySQL Error 28
Overview: MySQL: 1030: got error 28 from server handler
cd /tmp
df -i /tmp
df -h /tmp
Delete anything which is 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 deemed 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
