MySQL mysqldump Export only table structure does not export data
Copy CodeThe code is as follows:
Mysqldump--opt-d database name-u root-p > Xxx.sql
backing up the database
Copy CodeThe 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
Copy CodeThe code is as follows:
Mysqldump--opt-d database name-u root-p > Xxx.sql
2. Export data does not export 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 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 CodeThe code is as follows:
#mysql Database name < file name
#source/tmp/xxx.sql articles you may be interested in:
- Ways to back up and restore specified tables with mysqldump
- MySQL Backup recovery Mysqldump.exe Several common use cases
- MySQL database backup and restore command Mysqldump,source usage
- Batch processing (copy directory or mysqldump backup) for MySQL automatic backup under Windows
- MySQL Import and Export tool mysqldump and Source command usage detailed
- MySQL mysqldump data backup and incremental backup
- Using mysqldump to import data and mysqldump incremental backups (mysqldump use method)
- PHP uses the mysqldump command to export the database
Mysqldump Usage Summary