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