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:
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.
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.
Nice post. Keep writing.
When your data is critically corrupted than you need mysql recovery software to repair your MySQL database.
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