Pick our brains...

Mysql + Repair All Databases or All Tables of Particular Database(s)

Running as root,
this command will repair all mysql databases on the server.

Yes, this will take some time!
Note, on PM servers, if you’re logged in as root, then you do not need to specify the password.  Other servers may vary.

mysqlcheck -Aao --auto-repair -u root

where:

“A” == –all-databases == Consider all the databases
“a” == –analyze == Analyzes tables
“o” == –optimize == Optimize tables

 

You can choose to repair just one (or more) databases with:

mysqlcheck  [options]  --databases  DB_NAME ...

where:

DB_NAME is the database(s) you wish to repair (yes, you can specify several if you with, separated by spaces).