MySQL mysqldump only export table structure do not export data
Copy Code code as follows:
Mysqldump--opt-d database name-u root-p > Xxx.sql
backing up a database
Copy 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 Code code as follows:
Mysqldump--opt-d database name-u root-p > Xxx.sql
2. Export data does not export structure
Copy Code code as follows:
MYSQLDUMP-T database name-uroot-p > Xxx.sql
3. Export Data and table structure
Copy Code code as follows:
Mysqldump database name-uroot-p > Xxx.sql
4. Export the structure of a specific table
Copy Code code as follows:
Mysqldump-uroot-p-B database name--table table name > Xxx.sql
Import Data:
Since mysqldump is exporting complete SQL statements, it is easy to import data into the MySQL client program:
Copy Code code as follows:
#mysql Database name < filename
#source/tmp/xxx.sql
