HostMonster 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.sqlWhere "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.
Click Here for information on requesting SSH access.
Knowledgebase Article 257,971 views bookmark
sharetags: dump mysql ssh structure table
Share or save this via:
Recommended Help Content
This article will instruct you how to export a database from the command line (SSH).
This article will instruct you how to import a database from the command line (SSH).
A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin
Knowledgebase Article 161,995 views tags: databases mysql phpmyadmin
Related Help Content
Guidance on adding tables to your mySQL database in phpMyAdmin
Knowledgebase Article 99,175 views tags: mysql phpmyadmin
Database Size and Table Limits.
How to repair and optimize your database using phpMyAdmin:
This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database.
This article will show you how to rename a database table in phpMyAdmin.
Knowledgebase Article 294,480 views tags: databases mysql phpmyadmin
I need to Export or Import a MySQL database
Knowledgebase Article 400,903 views tags: mysql phpmyadmin ssh
How do I make my MySQL database compatible with the version you provide?
Knowledgebase Article 207,288 views tags: compatible database mysql
This article will explain how to change the password for a database in the event that the original password is lost.