MySQL Export database table structure command detailed

Export Database command:

The following specific usage of the command line is as follows: Mysqldump-u user name-p password-d database Name table name Script name;

Mysqldump-h host Address-u user name-p password database name >sql.txt

Mysqldump-h host Address-u username-p password database name-D >sql.txt only export Sechema, do not export data

To import a database command:

Mysql-h host Address-P Port-u user name-p password <sql.txt

It's a very simple way to export a table structure with the-D argument only.