PDA

View Full Version : mysqldump problems


batmite
3-17-03, 03:34 PM
___________________________________________

From the command line do

mysqldump --opt -n -hserver.powweb.com -uyourusername -pyourpassword yourDBname > dbdata.sql

___________________________________________


I tried the above from the command prompt and received the following error:

invalid option -- o


Then I tried removing the option --o and I still get an invalid option error.

Any ideas?

Thanks you.

devinemke
3-17-03, 04:14 PM
i believe your syntax is wrong, try this:

/usr/local/bin/mysqldump --user=username --password=password dbname >output.sql

HalfaBee
3-17-03, 04:26 PM
Sorry,

I tried it on my pc at home and it worked fine.
It may be a different version.

take out the --opt and see if it works.

Devinemikes syntax will work on the server not your PC.

HalfaBee