MySQL Export and Import command example

1. Export the entire database
Mysqldump-u username-p Database Name> exported file name

Mysqldump-u wcnc-p smgp_rj_wcnc> wcnc. SQL

2. Export a table

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

Mysqldump-u wcnc-p smgp_rj_wcnc users> wcnc_users. SQL

3. Export a database structure

Mysqldump-u wcnc-p-d -- add-drop-table smgp_apps_wcnc> d: wcnc_db. SQL

-D no data -- add-drop-table adds a drop table before each create statement.

4. Import the database

Common source commands

Go to the mysql Database Console,

For example, mysql-u root-p

Mysql> use Database

Then run the source command. The following parameter is the script file (for example,. SQL used here)

Mysql> source d: wcnc_db. SQL