How To Repair, analyze & optimize all database in mysql

[Sanju Kr]

Login as root and run following command

mysqlcheck --all-databases -r

#repair, it will repair all database

mysqlcheck --all-databases -a

#analyze, it will analyze all database

mysqlcheck --all-databases -o

#optimize, it will optimize all database

[amylee]

or use phpmyadmin :/

[Sanju Kr]

or use phpmyadmin :/

this for vps and dedicated server, phpmyadmin has limited ability.

[subzero]

You can do this in php my admin..

lol in like repair.php why rooting it ?

[Sanju Kr]

obviously it can be done in phpmyadmin but as i have already said it for all databse including roudncube and other db and command only for server having root access,,
Its better to run one command or fix one my one from phpmyadin