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

Remote Access To MySQL Database Server?

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

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

How do I restore a MySQL database?

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

How can I connect to a MySQL database from Dreamweaver?

To connect to a MySQL database from Dreamweaver follow the below steps:Login to your cPanel...

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