Portal Home > Knowledgebase > Databases > I would like to dump the Table Structure for my MySQL Database, but none of the data.

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.

Add to Favourites    Print this Article

What are the Basic Connection Settings for MySQL? (Views: 329)

Do I use localhost or remotemysqlhost for my mysql connection? (Views: 322)

How do I create a MySQL backup? (Views: 335)

I can't log into MySQL from a remote computer using a MySQL admin tool. (Views: 352)

How do I create a MySQL database? (Views: 354)