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

MySQL mysqldump only export the table structure or only the implementation method of data export, the need for friends can refer to.

MySQL mysqldump export only table structure does not export data

Copy the Code code as follows:

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

Backing Up the database

Copy the Code code 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 the Code code as follows:

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

2. Export data does not export structure

Copy the Code code as follows:

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

3. Export Data and table structure

Copy the Code code as follows:

Mysqldump database name-uroot-p > Xxx.sql

4. Export the structure of a specific table

Copy the Code code 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 the Code code as follows:

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

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