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

This article mainly explains "how to restore the mysql database after reinstalling the operating system". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to restore the database of mysql after reinstalling the operating system".

Take carnumber as an example:

1. Back up the following files

Data\ ib_logfile0

Data\ ib_logfile1

two。 Back up the following folders (including all files)

Data\ carnumber

3. Delete the carnumber folder

4. Re-enroll the service

D-nt-install

5. Start the service

Net start mysql

6. Modify the password

Mysqladmin-uroot-pqazxsw password qazxsw

7. Connect mysql

Mysql-uroot-p

8. Set up a database

Create database carnumber

9. Out of Service

Net stop mysql

10. Copy the following files to the data folder

Ib_logfile0

Ib_logfile1

11. Copy the following folder (including all files) to the data folder

Carnumber

twelve。 Start the service

Net start mysql

End.

At this point, I believe you have a deeper understanding of "how to restore the mysql database after reinstalling the operating system". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.