MySQL uses mysqldump to copy a database

1. Export 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 has no data -- add-drop-table adds a drop Table 4 before each create statement. import Database
Common source commands
Go to the MySQL Database Console,
For example, MySQL-u root-P

Mysql> Use Database and then use the source command. The following parameter is a script file (for example,. SQL used here)
Mysql> source D: \ wcnc_db. SQL

5. Add to new database

Go to the mysq Console

Mysql-u root-P

Enter the root password.

Create a database

Create Database database name;

Note: ";" Semicolon.

Then on the MySQL Console

Use Database

Source D: \ wcnc_db. SQL

From:

Http://www.blogjava.net/Alpha/archive/2007/08/10/135694.html