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