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