Mysqldump the implementation method of exporting only table structure or exporting data only "go"

MySQL mysqldump export only table structure does not export data

Mysqldump--opt-d database name-u root-p > Xxx.sql

Backing Up the database

#mysqldump database name > Database backup Name
#mysqldump-A-u user name-p password database name > database backup Name
#mysqldump-D-A--add-drop-table-uroot-p >xxx.sql

1. Export structure does not export data

Mysqldump--opt-d database name-u root-p > Xxx.sql

2. Export data does not export structure

MYSQLDUMP-T database name-uroot-p > Xxx.sql

3. Export Data and table structure

Mysqldump database name-uroot-p > Xxx.sql

4. Export the structure of a specific table

Mysqldump-uroot-p-B database name--table table name > Xxx.sql

Import data:
Since mysqldump exports a complete SQL statement, it is easy to import the data using the MySQL client program:

#mysql Database name < file name
#source/tmp/xxx.sql

Mysqldump the implementation method of exporting only table structure or exporting data only "go"