Import and export MySQL database via CMD window

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)

5.5\>-->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.sql2. Export a table mysqldump-u user Name-P Database Name Table name>exported file name mysqldump-U dbuser-P dbname Users>Dbname_users.sql3. 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

Import and export MySQL database via CMD window