Check, Optimize and Repair MySQL Tables Using Mysqlcheck

To check all the tables in a particular database, don’t specify the table name. Just specify the database name.

        mysqlcheck -c  -u root -p  --all-databases >"D:check.log"

To check the specific table.

        check table [yourtablename];

To repair a table

        repair table [yourtablename];