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

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.

Was this answer helpful?

 Print this Article

Also Read

How do I restore a MySQL database?

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

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 create a MySQL database?

To create a MySQL database please follow the steps below:- 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...

Remote Access To MySQL Database Server?

Host name = (use the server IP address) Database name = (cpanelUsername_databaseName) Database...