MySQL Import and Export command

[From] http://www.blogjava.net/hh-lux/archive/2007/05/05/115419.html

 

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 (Note: If source d:/wcnc_db. SQL is written, a syntax error is reported)