Check all tables on MySQL
database
ID: 20140120
ACCESSING DATA...
SYSTEM: ARCHIVE
FILE: CHECK ALL TABLES ON MYSQL
STATUS: ACTIVE
Data corruption is every DBA’s worst nightmare and can happen anytime. Use this command to check and repair all tables on a MySQL database :
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases