linux poison RSS
linux poison Email

How to Check and repair mysql tables

mysqlcheck is the command line program to check and repair mysql tables.
It performs the same functions as the check table and repair table query statements.
 
Examples:
# 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


5 comments:

Post a Comment

Related Posts with Thumbnails