MySQL export table structure and table data mysqldump usage

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


1, the Export database is DBNAME table structure (where the user name 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;

MySQL export table structure and table data mysqldump usage