mysql mysqldump is an implementation that exports only table structures or only data

mysql mysqldump exports only table structures and not data

mysqldump --opt -d  The database name  -u root -p > xxx.sql 

Backup database

 
#mysqldump The database name > Database backup name  
#mysqldump　-A　-u The 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

 
mysqldump　--opt　-d The database name -u　root　-p　>　xxx.sql　　 

2. Export data without exporting structure

 
mysqldump　-t The database name -uroot　-p　>　xxx.sql　 

Export data and table structures

 
mysqldump The database name -uroot　-p　>　xxx.sql　 

Export the structure of a particular table

 
mysqldump　-uroot　-p　-B The database name --table The name of the table >　xxx.sql　　 

Import data:
Since mysqldump exports the full SQL statement, it is easy to import data using the mysql client:

 
#mysql The database name < The file name  
#source　/tmp/xxx.sql