mysql dump

[raynebair]

ok, I've been reading the threads about mysql and ssh. What is the difference between running mysql dump from the command line and using the dump feature in phpmyAdmin?

[DR_LaRRY_PEpPeR]

mysqldump works and phpMyAdmin doesn't.

[raynebair]

Could you explain further? I've used the dump in phpMyAdmin and I was able to run that same script on another database to re-create the table...it worked like a charm. So I don't understand what the difference is...does it generate different script?

[DR_LaRRY_PEpPeR]

try it with a 50MB+ database. i've also seen phpMyAdmin mess up quotes in the data (not escaping them correctly), which is unacceptable. mysqldump works every time, the first time. using it, and mysql to import, is just a lot more efficient than using phpMyAdmin, too -- especially as the database gets bigger.