How to back up mysqldump

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

< d:\20090219.sql mysql 还原命令 root 用户名(root管理员) dbcurr 备份的数据库名; < 还原符号 20090219.sql 还原的文件名 mysqldump 远程备份 mysqldump -h ip -u root -p root database >

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!