Data Structure Dump

[mwichmann4]

Is there a quicker way to create a mysql data structure with out having to put all the mysql code into php vars. I mean can the mysql code reside in a file somewhere and I give a command to dump all that to mysql. Need help on this, thanks.

[stolzyboy]

download phpMyAdmin and there are tools built into it to do exactly what you want

[richie]

phpmyadmin is your friend in this case.

You can also use mysql's mysqldump from the command line like this on a Windows machine:

c:\mysql\bin> mysqldump -u username -ppassword dbName > c:\windows\desktop\mydmp.txt

This will dump the structure of your db into the file mydmp.txt on your desktop.