Repair all Database Table on cPanel Server

You can try the following commands:

First, stop MySQL

 /etc/rc.d/init.d/mysql stop


Repair all SQL databases:

myisamchk -r /var/lib/mysql/*/*.MYI

 
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


That's it !!

Was this answer helpful? 0 Users Found This Useful (0 Votes)