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. Export the database to DBNAME table structure (where username is root, password is dbpasswd, the generated script is named 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 structures 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;

This article is from the "Intelligent Future _XFICC" blog, please be sure to keep this source http://xficc.blog.51cto.com/1189288/1831589

MySQL export table structure and table data mysqldump usage