Ok I have a client that has a mysql data base file that is 10 megs ...... when ever we try to use phpmyadmin it times out at 300 seconds ..... I tried to do it from the command line with this mysql -uUSERNAME -pPASSWORD username_domain > domain_db.sql but all it does is set there with no activaty for a long time ...... what else can I do?

What version of mysql are you running, are you sure that you are running the latest?

When you posted "large database" I thought you meant in Gb, 10megs is NOTHING. I have had to transfer databases that are many Gb. You should have no real problem doing a backup of a database even close to a gig in size.

mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i686)

yeah I know it aint that large and I have never had this problem with the Ensim servers ........ just cant figure out why it wont do it from the command line?

Am I using the right command?

Hi JamesC,

The command you are using is not correct.

Should be mysqldump -uUSERNAME -pPASSWORD username_domain > domain_db.sql

Then to load the db you would use:
mysql -uUSERNAME -pPASSWORD username_domain < domain_db.sql

HTH

or you can edit the php.ini and add more time to the timeout.