[ Window ] Backup MySql using script :
Automating It All
Linux has cron, Windows has at. The at command schedules commands to run as often as you’d like. In this case, we’re going to run the backup one day a week at 2 AM.
Open up the command prompt and type the following:
at 02:00 /every:M,T,W,Th,F,S,Su c:\path\mysql-backup.bat
Once you run this, it should return “Added a new job with job ID = X”
Type at to make sure that it’s in the schedule.