There was a problem loading the comments.

How do I dump the table structure for my MySQL Database, but none of the data?

Support Portal  »  Knowledgebase  »  Viewing Article

  Print
 

The command line option from SSH is:
mysqldump -d -u -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. 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.

Share via
Did you find this article useful?  

Related Articles


Comments

Add Comment

Replying to  

CAPTCHA

On-Premise Help Desk Software by SupportPal
© Eleven2.com