MySQL mysqldump Export only table structure does not export data
The code is as follows:
Mysqldump--opt-d database name-u root-p > Xxx.sql
backing up the database
The 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
The code is as follows:
Mysqldump--opt-d database name-u root-p > Xxx.sql
2. Export data does not export structure
The code is as follows:
MYSQLDUMP-T database name-uroot-p > Xxx.sql
3. Export Data and table structure
The code is as follows:
Mysqldump database name-uroot-p > Xxx.sql
4. Export the structure of a specific table
The 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:
The 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