MySQL mysqldump implement method for exporting only table structures or exporting data only

MySQL mysqldump export only table structure does not export data

Copy CodeThe code is as follows:
Mysqldump--opt-d database name-u root-p > Xxx.sql

Backing Up the database

Copy CodeThe code is as follows:
#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

Copy CodeThe code is as follows:
Mysqldump--opt-d database name-u root-p > Xxx.sql

2. Export data does not export structure

Copy CodeThe code is as follows:
MYSQLDUMP-T database name-uroot-p > Xxx.sql

3. Export Data and table structure

Copy CodeThe code is as follows:
Mysqldump database name-uroot-p > Xxx.sql

4. Export the structure of a specific table

Copy CodeThe code is as follows:
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:

Copy CodeThe code is as follows:
#mysql Database name < file name
#source/tmp/xxx.sql

MySQL mysqldump implement method for exporting only table structures or exporting data only