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