Just Host Web Hosting Help

MySQL dump of tables only no 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, with the "-d" option, you tell it to not include the data, but just the table structure.