HostMonster Web Hosting Help
MySQL dump of tables only, no data
I would like to dump the Table Structure for my MySQL Database, but none of the 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 132,414 views bookmark
sharetags: mysql ssh (updated 2174 days ago)
Share or save this via:
Recommended Help Content
This article will instruct you how to export a database from the command line (SSH). (updated 763 days ago)
This article will instruct you how to import a database from the command line (SSH). (updated 157 days ago)
Users having problems connecting to mysql database using SSH and/or putty/other client. (updated 1889 days ago)
Related Help Content
What necessitates "Database Repair"? (updated 1166 days ago)
A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin (updated 994 days ago)
Guidance on adding tables to your mySQL database in phpMyAdmin (updated 993 days ago)
An exported .sql file shows as a different size than the reported size in cPanel (updated 1579 days ago)
This article will explain how to convert a MySQL database to UTF-8. (updated 90 days ago)
How to repair and optimize your database using phpMyAdmin: (updated 1185 days ago)
Instructions on deleting tables from your database using phpMyAdmin (updated 994 days ago)
This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database. (updated 50 days ago)