MySQL Export table structure

Mysqldump-D option enables the ability to export the table structure of a database

1. The table structure of the entire library is exported with the following statement:

Mysqldump-uroot-p-d-b Database >/path/databasename.sql,

With the-B option, you can have the statement that creates the database in the exported table structure so that the import

These table structures, you do not have to create a corresponding database.

2. Export the structure of the specified table:

Mysqldump-uroot-p-D database table >/path/table.sql

MySQL Export table structure