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.
Just Host Help Center
If you can't find what you're looking for,
please click here to submit a support ticket.
If you can't remember your cPanel or Billing Logins,
Please click here to have them resent .
Article Details
Last Updated
24th o June, 2008
