mysqldump problems

[Anon]

Hi,

I am trying to create a backup of a database using the command prompt. My command looks like this:

c:\mysql\bin>mysqldump -h localhost - u username -p dbname > backup.txt

...but this doesn't work. Can anyone tell me what I'm doing wrong?

Cheers, Jo

[kerrysl]

One thing that is wrong in your command line is that there is no space after the -p. It should read -pdbname. I am assuming that dbname is the password. If you don't have a password set then just omit the -p.