Mysql mysqldump: How to export only the table structure or data

Mysql mysqldump only exports the table structure and does not export data Copy codeThe Code is as follows: mysqldump -- opt-d database name-u root-p> xxx. SQL

Back up database
Copy codeThe Code is as follows: # mysqldump Database Name> Database Backup name
# Mysqldump-A-u username-p Password Database Name> Database Backup name
# Mysqldump-d-A -- add-drop-table-uroot-p> xxx. SQL

1. the exported structure does not export data
Copy codeThe Code is as follows: mysqldump -- opt-d database name-u root-p> xxx. SQL

2. Export data without exporting the 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 Name> xxx. SQL

Import data:
Mysqldump exports complete SQL statements, so it is easy to import data into mysql client programs:Copy codeThe Code is as follows: # mysql database name <file name
# Source/tmp/xxx. SQL