I'm trying to do mysqldump in Windows XP, having done this successfully in WIN98 for a long time, but can't get the script to run. I understand I should create a batch.bat file and place it in the mysql\bin folder. Here's the script:
"C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqldump.exe" mysqldump -u ROOT -pPASSWORD DATABASE FILENAME > d:\new\FILENAME.sql
(no space between -p and the password, one space between -u and root)
The error message says that I should find the right syntax to use near 'batch.bat" which sounds like the file isn't even opening.
Could someone give precise coding and action I should use as I'm not a pro. Thanks.