1. bluehost knowledge base

MySQL dump of tables only, no data

In order to dump the table structure but not the data the command line option in SSH is:

     mysqldump -d -u username_user -p username_dbname > file.sql 

where "username_dbname" is the name of your database, and "file.sql" is the name of the file you would like to write the table structure to. It will prompt you for a password (-p) and this is required. Normally, mysqldump gives you the entire database, but with the "-d" option, you tell it to not include the data, just the table structure.

If you need SSH access, please review our article.