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

This article mainly introduces "the simplest backup and restore method of mysql". In the daily operation, I believe that many people have doubts about the simplest backup and restore method of mysql. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "the simplest backup and restore method of mysql". Next, please follow the editor to study!

Note: do not operate in mysql, operate directly in cmd.

Backup: backs up a file named taskone to a specified file under a specified location

Dump-h 127.0.0.1-uroot-proot taskone > D:/taskone

Restore:

Step 1: set up a database of corresponding names in mysql

Step 2:

Mysql-h 127.0.0.1-uroot-proot taskone < D:/taskone

Note:

1. When restoring, we should first establish the database, and then restore the data in it.

two。 The backed-up files will be stored under their own specified name. If you want to see their contents, you can back them up as follows:

Taskone.sql

If the file name is taskone at the time of backup, you can also change it to taskone.sql

At this point, the study of "the simplest backup and restore method of mysql" is over. I hope to be able to solve your 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.