Mysqldump Specific Application examples

1. Export the entire database
Mysqldump-h host-u user name-P database name > exported file name
Mysqldump-h127.0.0.1-u wcnc-p SMGP_APPS_WCNC--opt> wcnc.sql
2. Export a table
Mysqldump-u user name-P database name Table name > exported file name
Mysqldump-u wcnc-p SMGP_APPS_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 add a drop table before each CREATE statement

4. Import the database
Common source Commands
Go to MySQL Database console,
such as Mysql-u root-p

Mysql>use Database

Then use the source command, followed by the script file (for example, the. SQL used here)
Mysql>source D:/wcnc_db.sql

Mysqldump Specific Application examples