Installation
      Back to home
      1. Knowledge Base
      2. Installation and System Setup
      3. Installation

      How to Schedule MySQL AutoDB Backup in Windows

      This article xplains scheduling automatic database (autodb) backups using Task Scheduler in Windows.

      Prerequisites

      • You must have Administrator access to the MySQL VM.
      • You need the MySQL root password to take the backup.
      • (Optional) Ensure the MySQL dump can be moved to an NFS (mount) server.
      • Know the name of the MySQL database used by the OvalEdge application.

      Steps to Follow

      1. Create a folder, download the following file, and save it in that folder: https://ovaledge.s3.us-west-1.amazonaws.com/OvalEdge+Clients/European+Commission/backup_mysql.bat
      2. Now open the .bat file and update the MySQL username, password, hostname, database name, and backup folder path as shown below.
      3. After adding the details, test the script manually before scheduling it.
        1. Open Command Prompt, go to the folder with the .bat file and run the script.
        2. If it runs successfully, the script is working fine.
      4. Now schedule the backup_mysql.bat file using Task Scheduler. Go to the Windows search bar and open Task Scheduler.
      5. Click Create Basic Task.
        1. Enter a name for the task and click Next.
      6. In the Trigger section, select Daily to run the task every day.
        1. Set the scheduled time and click the Next button.
        2. Select Start a program as the action for the task to perform.
        3. Browser the bat.file
        4. Check the dialog box and click on the finish button. 
        5. You will find a new window below.  Now check the option as shown in the screenshot below. Click on the Ok button. 
        6. Enter the VM password when prompted, and click OK.
      7. Open the Task Scheduler dashboard to verify the task.  As shown below, Task Scheduler ran successfully and created the MySQL backup at the scheduled time.

      Conclusion

      By following the steps in this document, you can automate MySQL database backups using Task Scheduler in Windows. This ensures regular backups without manual effort, helping you secure and restore your OvalEdge data when needed.