Mysqlmysqldump only exports the table structure or only exports data. For more information, see.
Mysql mysqldump only exports the table structure or only exports data. For more information, see.
Mysql mysqldump only exports the table structure and does not export data
The Code is as follows:
Mysqldump -- opt-d database name-u root-p> xxx. SQL
Back up database
The 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
The Code is as follows:
Mysqldump -- opt-d database name-u root-p> xxx. SQL
2. Export data without exporting the 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 Name> xxx. SQL
Import data:
Mysqldump exports complete SQL statements, so it is easy to import data into mysql client programs:
The Code is as follows:
# Mysql database name <file name
# Source/tmp/xxx. SQL
