Mysql-repair

check table employee

# mysqlcheck -c thegeekstuff employee -u root -p

check all tables

# mysqlcheck -c alfresco  -u root -p

check all tables all databases

# mysqlcheck -c  -u root -p --all-databases

Optimize Tables using Mysqlcheck

# mysqlcheck -o thegeekstuff employee -u root -p

Repair Tables using Mysqlcheck

# mysqlcheck -r thegeekstuff employee -u root -p

Combine Check, Optimize, and Repair Tables

# mysqlcheck -u root -p --auto-repair -c --all-databases