MySQL export (multiple tables) table structure and table data mysqldump usage

The following command-line specific usage is as follows: Mysqldump-u username-p password-D is the name of the script in the database name table;

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

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

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

4. Export the database as dbname a table (test) structure and table numbers (without-D)
MYSQLDUMP-UROOT-PDBPASSWD dbname test>db.sql;

5. DBName Multiple tables (TEST1,TEST2,TEST3) structure and table data in the exported data are separated by spaces

MYSQLDUMP-UROOT-PDBPASSWD dbname test1 test2 test3>db.sql;