mysqldump > not working

on my w2k machine

[benihana]

hi
I cannot get:

mysql> mysqldump -u root -p database > backuptest.sql;

to work - I just get 'error in syntax' type messages.

I read somewhere that there is supposed to be a file called mysqldump.exe in the mysql/bin directory, but its not present.

any ideas what i maybe doing wrong?
thanks
ben

p.s. im using the php/mysql/apache bundle from firepages

[grahamstewart]

The mysqldump.exe file should indeed be in the bin directory for MySql, along with mysql.exe, mysql-nt.exe and all that.

If you can't find it then try using the search facility on Windows (I'm assuming its a windows installation). Do a full search, go have a cup of tea and hopefully it will be found by the time you return :)

Note that its a program, not a mysql command, so you need to run it from the DOS command line - not from mysql.

[benihana]

thanks graham.
searched the full machine but no mysqldump anywhere.
after some searching i managed to download a copy and move it to the mysql\bin

Now when i try to run from command prompt i get the following alert message:

The dynamic link library cygwinb19.dll could not be found in specified path C:\phpdev\mysql\bin ...etc... lots of other paths

the dll its looking for is in the mysql\lib directory.

Any ideas what i need to do to change the paths? or can i just shift the dll into the bin?

thanks

[grahamstewart]

On my installation (which is from MySQL directly not firepages) the cygwinb19.dll file appears in my bin directory - so yeah sounds likeyou can safely copy it there.

[benihana]

fixed :)

thanks graham