How to DB Schema Dump?

Is this done via SSH or can be done via Cpanel?

I don't know what DB a schema dump is, is just the "skeleton" of the DB but without the content - outputted as a .sql file?

 

You could do it via ssh, or you can do it with phpMyAdmin by unchecking the 2 "Data" checkboxes before doing the save.

 

Thanks do you mean Export and unchecking "Data dump options":

- Dump binary columns in hexadecimal notation (for example, "abc" becomes 0x616263)
- Dump TIMESTAMP columns in UTC (enables TIMESTAMP columns to be dumped and reloaded between servers in different time zones)

 

You said you just want the table definitions, not the data, so on the right side of the Export window, the third panel in the options panel, uncheck the word "Data". Then you'll save the "Create Table" statements with all the fields in each table, but no data.

Different versions of phpMyAdmin have different screen setups - I'm looking at version 3.3.9 at the moment - but the option is about the same in all of them. You want to export the database, but you don't want to export any data.

 

Yep I think my version is different. I guess it's this:

Dump table
- structure
- data
- structure and data

So I just click "structure" instead of the default "structure and data"?

thanks again

 

Yes, since that's what it sounds like you want, from your first post.

 

via ssh2 telnet use either --no-data or -d option http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_no-data

mysqldump -d -u mysqlusername -p dbname > backupschema.sql

Code (markup):