Here's a quick & ditry trick to repair all MySQL databases on a server, in one go.

Run the following commands on your server, in the console as root.

PHP Code:
PHP Code: 
mysqlcheck --all-databases -r #repair 
mysqlcheck --all-databases -a #analyze 
mysqlcheck --all-databases -o #optimize 
Albert.Nawaro Reviewed by Albert.Nawaro on . How to repair all MySQL databases on a server in one go Here's a quick & ditry trick to repair all MySQL databases on a server, in one go. Run the following commands on your server, in the console as root. PHP Code: mysqlcheck --all-databases -r #repair mysqlcheck --all-databases -a #analyze mysqlcheck --all-databases -o #optimize Rating: 5