MySQL export table structure and table data mysqldump usage

The specific usage of the command line is as follows: mysqldump-u uses the anonymous name-P password-D Data Warehouse name table name Script Name;

1. Export the table structure of the database named dbname (the database name is root, the password is dbpasswd, And the generated Script Name Is dB. SQL)
Mysqldump-uroot-pdbpasswd-D dbname> dB. SQL;

2. Export the data library as a dbname table (TEST) Structure
Mysqldump-uroot-pdbpasswd-D dbname test> dB. SQL;

3. Export all table structures and table data records (without-d) in the database dbname)
Mysqldump-uroot-pdbpasswd dbname> dB. SQL;

4. Export the data warehouse to dbname a table (TEST) structure and table data volume (without-d)
Mysqldump-uroot-pdbpasswd dbname test> dB. SQL;