Mysqldump exports data only or only the table structure backup database Linux Code # 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 # 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. export structure do not export data Ruby code mysqldump -- opt-d database name-u root-p> xxx. SQL mysqldump -- opt-d database name-u root-p> xxx. SQL 2. export data without exporting structure Linux code mysqldump-t database name-uroot-p> xxx. SQL mysqldump-t database name-uroot-p> xxx. SQL 3. export data and table structure Linux code mysqldump database name-uroot-p> xxx. SQL mysqldump database name-uroot-p> xxx. SQL 4. export the structure of a specific table. Linux code: mysqldump-uroot-p-B database name -- table Name> xxx. SQL mysqldump-uroot-p-B database name -- table Name> xxx. SQL data import: Because mysqldump exports a complete SQL statement, it is easy to import data using a mysql client program: linux Code # mysql database name <file name # source/tmp/xxx. SQL