windows 7 task schedule / mysqldump

Question

Ive created a batch file to create a dump of a database and save it in a file with the current date as part of the file name. The batch file works brilliantly and all the data is saved correctly.

Ive now tried to set up a scheduled task to do this weekly, but ive run into a problem, although the task runs, the file it creates is empty, as if it has not pulled any data from the remote database. I know its pretty vague, but can anybody tell where id start looking for a reason/solution?

** EDIT **

Right, more progress - looks like it might be a path problem ive put a pause in the batch file, and when run through the task scheduler, it says:'mysqldump is not a recognized program'. However when run through the command line on my user account it works fine, just to confirm, ive set it run on the same user account ive been testing it on.

** EDIT 2 **

Ive found a sort of solution: ive had to refer the mysqldump application by its absolute path. However i still cant understand why it can find mysqldump from the path when run directly from the command line, but not when automated through the task scheduler

Answer 1

Maybe the network was unavailable ? You could try scheduling it to run every 5/10 minutes, and see if the commands / variables are going correct. You sure that the script runs correctly when run as a whole and not just single command at a time ?

---

On your edit 2: Seems like mysqldump is not present in the PATH environment variables. Try adding that, and try again.

Answer 2

Have you tried running mysqldump (in your scheduled task) in verbose mode? (--verbose)

Also, perhaps look at what user your task is running as, make sure that user has permissions to run mysqldump and create a file in the target directory.