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


4 comments:

Sam Joseph said...

Good information but there is a problem. These commands are helpful to check the simple bugs and helpful to repair simple corrupted file. If your file is badly corrupted then these process fails. During that time you need the MySQL Recovery software that repair and recover your corrupted and damaged database.

Sam Joseph said...

Good information but there is a problem. These commands are helpful to check the simple bugs and helpful to repair simple corrupted file. If your file is badly corrupted then these process fails. During that time you need the MySQL Recovery software that repair and recover your corrupted and damaged database.

David said...

Nice post. Keep writing.
When your data is critically corrupted than you need mysql recovery software to repair your MySQL database.

Photo Recovery said...

Thanks for this great information about repair mysql database.After corruption of your mysql database we need good third party mysql repair tool to get back our precious database.

Post a Comment

Related Posts with Thumbnails