HostMonster Web Hosting Help

MySQL dump of tables only, no data

Problem:

I would like to dump the Table Structure for my MySQL Database, but none of the data.

Solution:

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.

Click Here for information on requesting SSH access.

Knowledgebase Article 126,634 views bookmark tags: mysql ssh (updated 2074 days ago)


Was this resource helpful?

Did this resolve your issue?


Please add any other comments or suggestions about this content:





Recommended Help Content

This article will instruct you how to export a database from the command line (SSH). (updated 663 days ago)
Knowledgebase Article 440,771 views tags: database mysql ssh

This article will instruct you how to import a database from the command line (SSH). (updated 56 days ago)
Knowledgebase Article 401,229 views tags: database mysql ssh

Users having problems connecting to mysql database using SSH and/or putty/other client. (updated 1789 days ago)
Knowledgebase Article 61,654 views tags: connection ip mysql putty ssh whitelist

Related Help Content

What necessitates "Database Repair"? (updated 1066 days ago)
Knowledgebase Article 100,642 views tags: corruption damaged database mysql postgres repair tables

A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin (updated 893 days ago)
Knowledgebase Article 42,083 views tags: databases mysql phpmyadmin

Guidance on adding tables to your mySQL database in phpMyAdmin (updated 893 days ago)
Knowledgebase Article 15,273 views tags: mysql phpmyadmin

An exported .sql file shows as a different size than the reported size in cPanel (updated 1479 days ago)
Knowledgebase Article 24,789 views tags: backup database dump export mysql mysqldump size sql

How to repair and optimize your database using phpMyAdmin: (updated 1085 days ago)
Knowledgebase Article 188,772 views tags: database mysql optimizing repairing slow speed

Instructions on deleting tables from your database using phpMyAdmin (updated 894 days ago)
Knowledgebase Article 37,292 views tags: Plesk cpanel databases mysql phpmyadmin

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database. (updated 118 days ago)
Knowledgebase Article 465,153 views tags: creation database mysql

I need to Export or Import a MySQL database (updated 663 days ago)
Knowledgebase Article 223,743 views tags: mysql phpmyadmin ssh