MySQL Dump Database Table Definitions

Use the following command to dump the database without the data.

mysqldump --user=user --password --host=localhost --no-data database

It's even possible to supply tables names to just export single tables.

mysqldump --user=drupal --password --host=localhost --no-data database table1 table2 table3

 

Add new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
7 + 12 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.