There is a few different ways you can backup your database on a Windows system. I normally use a script that just takes the database and dump it out to a file.
Here is a really simple example but it does it’s job. Go to a folder and create a new file called backup.bat and open it with a text editor. And enter the following syntax.
mysqldump -u root -pPASSWORD zoogen > e:\backup\zoogen-%date%.sql
forfiles /p E:\backup\ /m zoogen-*.* /d -7 /c "cmd /c del @path"
The first line here tells the script to login as the user root with the password PASSWORD and it should use the database zoogen if you want all databases to be backed up you can add the –all-databases instead of just zoogen. And the > tells where should the script save the database dump to. Here it will be saved to e:\backup\ and all files will be called zoogen-<todays date>.
The next row uses the function called forfiles. It looks in E:\backup and match every file that has zoogen-<something>.<something> and checks if the file is older then 7 days. If it’s older then 7 days it will remove the old files. This is done to prevent having 1000 different backups that you never will use.
Now we need to schedule the script. Open Task Scheduler and create a basic task. Name the new schedule and add a description. Now select how often the schedule should run. I recommend running the backup once a day. When you have selected the time the scrip will run select that the scheduled task should run a program. Now select the bat script we just created.
Before you click finish select Open the properties dialog for this task when I click Finish and change the security options from Run only when user is logged on to Run whether user is logged or not.
Now everything should be done and your backup will run at the time you specified.