mysqldump Batch export (multiple tables) table structure and table data

Mysql Bulk export table structure (data)

Export structure only, do not export data:

1. Export the table structure of the database as dbname
Mysqldump-h host Address-u user name-p password-D dbname >db.sql;

2. Export the database as dbname a table (test) structure
Mysqldump-h host Address-u user name-p password-D dbname test>db.sql;

Export Structure + data:
3. Export the database to dbname all table structures and table numbers (without-D)
Mysqldump-h host Address-u user name-p password dbname >db.sql;

4. Export the database as dbname a table (test) structure and table numbers (without-D)
Mysqldump-h host Address-u user name-p password dbname test>db.sql;

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

Mysqldump-h host Address-u user name-p password dbname test1 test2 test3>db.sql;

mysqldump Batch export (multiple tables) table structure and table data