FastDomain 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.

Click Here for information on requesting SSH access.

Knowledgebase Article 196,347 views bookmark tags: dump mysql ssh structure table


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).
Knowledgebase Article 675,497 views tags: database mysql ssh

This article will instruct you how to import a database from the command line (SSH).
Knowledgebase Article 589,771 views tags: database mysql ssh

A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin
Knowledgebase Article 72,217 views tags: databases mysql phpmyadmin

Related Help Content

Guidance on adding tables to your mySQL database in phpMyAdmin
Knowledgebase Article 41,027 views tags: mysql phpmyadmin

How to repair and optimize your database using phpMyAdmin:
Knowledgebase Article 270,625 views tags: database mysql optimizing repairing slow speed

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database.
Knowledgebase Article 630,309 views tags: creation database mysql

This article will show you how to rename a database table in phpMyAdmin.
Knowledgebase Article 119,147 views tags: databases mysql phpmyadmin

I need to Export or Import a MySQL database
Knowledgebase Article 318,574 views tags: mysql phpmyadmin ssh

How do I make my MySQL database compatible with the version you provide?
Knowledgebase Article 112,635 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.
Knowledgebase Article 89,032 views tags: database mysql password

A repository of information on how you can manage your database by using the phpMyAdmin interface.
Knowledgebase Article 245,557 views tags: commands database mysql phpmyadmin