Import and export MySQL database via CMD window

This article transferred from: https://www.cnblogs.com/hanmk/p/7574376.html

1. Import the database

Using the Source command

First, connect the database in the cmd window, and then use the Source command to import the operation

Mysql>use database name

Mysql>source D:/dbname.sql

2. Export the database

Note When you export a database, you do not need to connect to the database, directly to the directory where Mysqld.exe is located, execute the following command (the exported SQL file is in the bin directory of the MySQL installation path)

D:\Program files\mysql\mysql Server 5.5\bin>mysqldump-u root-p gd_dbwizard >gd_dbwizard.sql (you will be prompted to enter your password after execution)

1. Export the entire database

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

Mysqldump-u dbuser-p dbname > Dbname.sql

2. Export a table

Mysqldump-u user name-P database name Table name > exported file name

Mysqldump-u dbuser-p dbname users> dbname_users.sql

3. Export a database structure

Mysqldump-u Dbuser-p-D--add-drop-table dbname >d:/dbname_db.sql

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

(go) Import and export MySQL database via CMD window