mysqlcheck

To check and repair all databases in a database run mysqlcheck -A –auto-repair -u root -p Forcefully optimize all tables, automatically fixing table errors that may come up. mysqlcheck -A –auto-repair -f -o -u root -p To check all databases mysqlcheck –all-databases -u root -p -c To analyze all tables in all databases: mysqlcheck –all-databases … Read more