Windows command line msyqldump Export database backup

In the DOS MySQL installation directory/bin directory with the following command:

Mysqldump-u user name-p database name > exported file name

Then use the following command

#test is the name of the library

The code is as follows	Copy Code
D:/webserver/mysql/bin>mysqldump Test > E:/test.sql-u root-p

Import Database

Common source Commands

Enter the MySQL database console,

such as Mysql-u root-p
　　

The code is as follows	Copy Code
Mysql>use Database

Then use the source command, followed by the script file (such as the. SQL used here)

Mysql>source D:wcnc_db.sql