AnsweredAssumed Answered

Automated MySQL backup on Microsoft Server 2003 R2

Question asked by kristian kristian on Jul 25, 2014
Latest reply on Jul 25, 2014 by kristian kristian
I need to automate MySQL backup on a daily basis, i'm currently working on a Microsoft Server 2003 R2.

I'm using this command but it's not working:

schtasks /create /sc daily /st 04:30 /ru SYSTEM /tn MySQL_backup /tr "\"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe\" -B <sugarcrm> -u <root> -p<password> -r C:\MySQL_backup\<sugarcrm>_%date:~0,2%.sql

I don't know what I'm missing here, all credentials are ok, and paths too, anyone has tried this on Microsoft Environment?

Thanks in advance!