Bluehost 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 173,411 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

Managing Databases with Command Line SSH

This article will instruct you how to export a database from the command line (SSH).

Importing Databases via Command Line SSH

This article will instruct you how to import a database from the command line (SSH).

Modifying table columns - phpMyAdmin

A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin

Related Help Content

Dropping Columns from a Database Table Using PhpMyAdmin

Instructions on deleting tables from your database using phpMyAdmin

How to Add Tables to a DB in PhpMyAdmin

Guidance on adding tables to your mySQL database in phpMyAdmin

MySQL Repair and Optimize Tables in phpMyAdmin

How to repair and optimize your database using phpMyAdmin:

How to Create and Delete MySQL Databases and Users

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database.

Rename database tables in phpMyAdmin

This article will show you how to rename a database table in phpMyAdmin.

MySQL Import and Export

I need to Export or Import a MySQL database

MySQL Database Compatibility

How do I make my MySQL database compatible with the version you provide?

Resetting MySQL Database User and Password

This article will explain how to change the password for a database in the event that the original password is lost.