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

This article mainly introduces how to back up mysqldump. It is very detailed and has a certain reference value. Friends who are interested must finish it!

1MySQL Server mysqldump tool is a very convenient gadget that comes with mysql. It is stored in C:\ Program Files\ MySQL\ MySQL Server 5.1\ bin in the mysql installation directory. 2 mysql mysqldump is the same as MySQL dump. They are all applications, and you can't execute them under mysql. We can type mysqldump-- help in the cmd to see its help, and if it cannot be displayed, add the variable value C:\ Program Files\ MySQL\ MySQL Server 5.1\ bin to the path in the environment variable. 3. The correct format of mysqldump is: mysqldump-u username-p password database name > export file, for example, my user name is root, the password is 123database is erm, then the command format is mysqldump-u root-p 123 erm > d:\ erm.sql (there is no semicolon after it).

Mysql data backup and restore commands:

Backup: mysqldump-u root-p 123 dbcurr > 20090219.sql

Mysqldump backup command

Root user name (root administrator)

Database name of the dbcurr backup

Backup symbols

File name of the 20090219.sql backup

Restore:

Mysql-u root-p 123 dbcurr

C:\ data.sql

The above is all the contents of this article "how to back up mysqldump". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.