It performs the same functions as the check table and repair table query statements.
# mysqlcheck bugs
This checks all of the tables in the bugs database.
# mysqlcheck bugs flags groups
This checks the flags and groups tables in the the bugs database
Using the –repair option you can repair tables using the same syntax as above.
Options to mysqlcheck to just check a table are:
–check-only-changed Same as “check table changed” query
–extended Same as “check table extended” query
–fast Same as “check table fast” query
–medium-check Same as “check table medium” query
–quick Same as “check table quick” query
Options to mysqlcheck to repair a table are:
–repair Same as “repair table” query
–repair –extended Same as “repair table extended” query
–repair –quick Same as “repair table quick” query
–repair –use-frm Same as “repair table use_frm” query