Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to repair the data damage of mysql database". In the daily operation, I believe that many people have doubts about how to repair the data damage of mysql database. The editor has consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for you to answer the doubt of "how to repair the data damage of mysql database". Next, please follow the editor to study!

Sometimes the database is damaged due to power outage or other reasons, we can use the mysqlcheck command that comes with mysql to quickly repair all databases or specific databases; for example

Check the optimization and repair all databases with:

1. First type CMD in the run and start the command line.

two。 Enter Mysql's Bin directory: E:Program FilesMySQLMySQL Server 5.0in. If you don't know how to enter another directory, you should refer to the online materials to learn the basics.

Common ways:

Run E:

Run CD "E:Program FilesMySQLMySQL Server 5.0in"

3. Run: mysqlcheck-A-o-r-uroot-p888888

Note that change 888888 to your own root password

Mysql.columns_priv OK

Mysql.db OK

Mysql.func OK

Mysql.help_category OK

Mysql.help_keyword OK

Mysql.help_relation OK

Mysql.help_topic OK

Mysql.host OK

Mysql.tables_priv OK

Mysql.time_zone OK

Mysql.time_zone_leap_second OK

Mysql.time_zone_name OK

Mysql.time_zone_transition OK

Mysql.time_zone_transition_type OK

Mysql.user OK

.

.

.

Be careful!

In the repair process, if you see an error prompt, indicating that the table is bad and can not be repaired, for the database containing bad tables, you can only delete it or stop it, otherwise it will affect the stability of the whole Mysql and cause mysql to stop automatically. (prompt that the table of "The storage engine for the table doesnt support repair" does not need to be processed)

If the fix is too fast to see the results, you can run

Mysqlcheck-A-o-r-uroot-p888888 > > C: est.txt

After running, open test.txt and you can see it.

At this point, the study on "how to repair the data corruption of mysql database" is over. I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.