MySQL: Schedule Automatic Database Backup on Windows

Quite simple. Since you have already read my older post about creating a backup (dump) file, here we will see how to automatically take a backup of a MySQL database at a particular time on your local Windows system.

This can be done using a batch file and Windows Task Scheduler.

Steps to create a scheduled backup:

Step 1: Create a batch file with the mysqldump command and the required options, as mentioned in the old post.

Step 2: Open Windows Task Scheduler.

You can search for Task Scheduler from the Windows Start menu.

Step 3: Create a new task or basic task and configure it to run the batch file at the required date and time.

After completing the configuration, wait for the scheduled time and check the destination directory. If everything is configured correctly, the MySQL backup file should be created automatically.

How to Stop Windows 8 “Maintenance in Progress”

How to Stop “Maintenance in Progress” in Windows 8

This is always a ridiculous task. I just want to get rid of this because it is troubling me. Apparently, you need to change a few settings.

Follow these steps:

• Click the lower-left corner to open the Start screen.
• Type Schedule tasks in the Start screen.
• Click Settings.
• Click Schedule tasks.
• Go to Task Scheduler Library → Microsoft → Windows → TaskScheduler.
• Right-click Regular Maintenance.
• Click Properties.
• Click the Settings tab.
• Check the box Allow task to be run on demand.
• Click OK.
• Right-click Regular Maintenance again to test whether it is running, and click Run.
• Right-click Regular Maintenance again and click End to stop the process.

Now the maintenance icon should be removed from the taskbar.

 

Note: This guide applies to Windows 8. Windows 8 is no longer supported by Microsoft.