MySQL Export/import table structure and table data

Export:

The following command-line specific usage is as follows: Mysqldump-u user name-p password-d database name name Script name;

1, export the database to DBNAME table structure (where the username is root, password is dbpasswd, the generated script name is Db.sql)
Mysqldump-uroot-pdbpasswd-d dbname >db.sql;

2. Export the database to dbname a table (test) structure
Mysqldump-uroot-pdbpasswd-d dbname test>db.sql;

3. Export the database to dbname all table structure and table data (without-D)
MYSQLDUMP-UROOT-PDBPASSWD dbname >db.sql;

4. Export Database to dbname table (test) Structure and table data (without-D)
MYSQLDUMP-UROOT-PDBPASSWD dbname test>db.sql;

Import:

Enter database, select Database->

SOURCE Db.sql;

MySQL Export/import table structure and table data