Have you ever experienced crashes on your cpanel server? until the server can not be restrained in the back and had to hard reboot? and will add more problems when the server is up, all your database crashes and can not be running mysql server? If so these tips may be able to treat your database table crashes. No need to panic and confusion, because to fix quite a few command-line only course: D
First maybe you can try the following tips:
1) /etc/rc.d/init.d/mysql stop
2) Repair all SQL databases:
myisamchk -r /var/lib/mysql/*/*.MYI
3) Start mysql again:
/etc/rc.d/init.d/mysql start
If it does not work, could in the following way
mysqlcheck –all-databases -r #repair
mysqlcheck –all-databases -a #analyze
mysqlcheck –all-databases -o #optimize
hopefully this article useful, have a nice day!
