Repair all Database Table on Cpanel Server

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!

Be Sociable, Share!

Leave a Reply

Your email address will not be published. Required fields are marked *