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
1 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.