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

There are two ways to do this, one being using phpMyAdmin the other is via SSH.

Using phpMyAdmin:

- Login to your control panel at www.yourdomain.com/cpanel 
- Click on 'phpMyAdmin' under the 'Databases' menu
- From the dropdown list to the left, choose the database you wish to export the backup from. 
- Click on the 'Export' Tab. 
- Click to deselect the 'Data 'box, then tick the 'Save as file' box and 'Go'. 
-  You will be asked to save the .sql file to the hard drive, click 'Save'. 
- Choose the location to save to and click 'Save'.

Using SSH:

The command line option from SSH is:

mysql -d -p database_name > file.sql

Where 'database_name' is the name of your database, and 'file.sql' is the name of the file you would like to write the table structure to. You will be prompted you for a password (-p). Normally mysqldump gives you the entire database, with the '-d' option, you need to tell it to not include the data, just the table structure.




  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I restore a MySQL database?

To restore a MySQL database please follow the below steps:- Login to your control panel...

I can't log into MySQL from a remote computer using a MySQL admin tool.

To add yourself to the whitelist so that you can connect to mysql remotely using admin tools such...

What are the Basic Connection Settings for MySQL?

There are two different ways to connect to a MySQL database: Locally - from a script on the...

How do I import a MySQL database?

To import a database follow the below steps:I have a backup of my database that I need to...

How do I create a MySQL backup?

There are two ways to back up your MySQL databases. You can use the backup utility in your cPanel...

Powered by WHMCompleteSolution