One command : repair all MySql databases in your server

[CaLViN]

With the command given below you will be able to repair all the dbs in your server.
It may take some time.

mysqlcheck -A -h localhost -u root -r -p

After you enter this command,you will be asked for your mysql root password.just write your mysql root password and hit enter.
If you dont know your mysql root password,you can reset it here
WHM >> SQL Services >> Reset Local MySQL Root Password

[alper60]

hi,
I'm a reseller.but I have limited control over WHM.also I'm able to access ssh.is it possible
for me that to repair all db on my reseller account?

[CaLViN]

Nope.
You can request your server administrator to apply the above commands.