DOS command import Export MySQL database

One, in your computer DOS mode, at the beginning of the-> run input "cmd"

Second, then go to your MySQL directory in the bin directory.

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

Mysql>source D:wcnc_db.sql (This is import)

Here is a reference:

1. Export the entire database

The code is as follows	Copy Code
Mysqldump-u user name-p database name > exported file name Mysqldump-u wcnc-p SMGP_APPS_WCNC > Wcnc.sql

2. Export a table

The code is as follows	Copy Code
Mysqldump-u user name-P database name Table name > exported file name Mysqldump-u wcnc-p SMGP_APPS_WCNC users> wcnc_users.sql

3. Export a database structure

The code is as follows	Copy Code
Mysqldump-u Wcnc-p-D--add-drop-table SMGP_APPS_WCNC >d:wcnc_db.sql

-D No data--add-drop-table add a drop table before each CREATE statement

4. Import Database

Common source Commands

Enter the MySQL database console,

Such as

The code is as follows	Copy Code
Mysql-u root-p

Mysql>use Database

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

　

The code is as follows	Copy Code
Mysql>source D:wcnc_db.sql