Shulou(Shulou.com)06/01 Report--

This article mainly gives you a brief introduction to the method of mysqldump backup and recovery database. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic of mysqldump backup and recovery database method. I hope it can bring you some practical help.

When backing up a database, it is inevitable to encounter unfamiliar problems that are different from habits, such as the following

Mysqldump.exe-uroot-p root database name > beifen.sql

This command means that you want to back up the xingming library data to beifen.sql, so the following prompt appears, and the execution is unsuccessful.

Mysqldump: [Warning] Using a password on the commadn line interface can be insecure.

Warning: it may not be safe to use passwords on the command line interface. "

So in the / etc/my.ini configuration file, modify the configuration and enter it under the myslqdump line in the file. If not, you can add the following

However, execute again.

Mysqldump.exe-uroot-p root database name > beifen.sql

It seems to be of no use!

So, it should be used this way.

Mysqldump.exe database name > beifen.sql

Add the configuration file, which means that it is probably a secret-free function!

So, find a beifen.sql file in the myslq\ bin directory

This file can be opened and edited.

Let's verify whether it is successful or not.

The old driver began to delete the library, so you should be careful to delete the library:

Drop database database name

The database was deleted successfully, and the recovery of the database begins:

Check the database without the library just now.

Mysqldump.exe beifen

Mysqldump backup and recovery database analysis will first tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

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.