Skip to main content

Creating a MySQL Database Backup Set for Windows

September 19, 2025

  1. Click the Backup Sets icon on the main interface of AhsayOBM.

    Backup Sets

  2. Click the "+" icon before "Add new backup set" to create a new backup set.

    Add new backup set

  3. Select the “Backup set type”, provide a name for your new backup set. Below, select a Host type.

    Create backup set

    For Host type, there will be four options: Self-hosted, Amazon RDS, Azure Database, and Google Cloud SQL.

    If Amazon RDS is selected, users will have to choose an appropriate Region. Below are the available Regions for Amazon RDS.

    • US East (N. Virginia)

    • US East (Ohio)

    • US West (Oregon)

    • Africa (Cape Town)

    • Asia Pacific (Hong Kong)

    • Asia Pacific (Hyderabad)

    • Asia Pacific (Jakarta)

    • Asia Pacific (Malaysia)

    • Asia Pacific (Melbourne)

    • Asia Pacific (Mumbai)

    • Asia Pacific (Osaka-Local)

    • Asia Pacific (Seoul)

    • Asia Pacific (Singapore)

    • Asia Pacific (Sydney)

    • Asia Pacific (Tokyo)

    • Canada (Central)

    • Canada West (Calgary)

    • Europe (Frankfurt)

    • Europe (Ireland)

    • Europe (London)

    • Europe (Milan)

    • Europe (Paris)

    • Europe (Spain)

    • Europe (Stockholm)

    • Europe (Zurich)

    • Israel (Tel Aviv)

    • Middle East (Bahrain)

    • Midde East (UAE)

    • South America (Sao Paulo)

    Amazon RDS

    Enter the rest of the login information:

    • Host - this value is typically set to localhost or 127.0.0.1. If Amazon RDS was selected as the Host type, this section will always have the suffix of .rds.amazonaws.com

      Conversely, if Azure Database is selected, the suffix would be .mysql.database.azure.com

    • Port - set commonly to 3306

    • Login ID - ID used to login to MySQL.

    • Password - Password used to login to MySQL.

    • (Optional) Path to mysqldump

    Click Next to proceed.

  4. In the "Backup Source" menu, select the MySQL databases you would like to backup. Click Next to proceed.

    Backup Source

  5. In the "Schedule" menu, you can configure a backup schedule for backup jobs to run automatically at your specified time interval.

    If enabled, to add the backup schedules click "Add" icon to modify additional backup schedule then click OK. Click Next to proceed.

    Schedule

    The default backup schedule is daily backup at 3:00 where the backup job will run until completion and the retention policy job will be run immediately after the backup job

    For details on how to configure the backup schedule settings, please refer to the Overview section (GUI).

  6. Select a "Backup mode" and click "+" before "Add new storage destination / destination pool" to add a backup storage destination.

    Destination

  7. Select the backup storage destination. Click OK then Next to proceed.

    Destination storage

    • If you have chosen the Local/Mapped Drive/Network Drive/Removable Drive option, click Change to select the storage destination. Tick This share requires access credentials if credentials are needed to access the directory path.

      Local

      Click Test to validate the path, "Test completed successfully" shows when the validation is done.

      Test completed

    • If you have chosen to store the backup files in another Cloud storage, click Test to log in to the corresponding cloud storage service.

      Cloud Storage

    • If you have chosen FTP as the destination, enter the "Host, "Username" and "Password" details.

      FTP

  8. In the “Encryption” window, the default “Encrypt Backup Data” option is enabled with an encryption key preset by the system which provides the most secure protection.

    Encryption

    For details on how to configure the "Encryption" settings, please refer to the Overview (GUI) section.

    For best practices on managing your encryption key, refer to the following article:

    FAQ: Best practices for managing encryption key on AhsayOBM or AhsayACB

    Click Next when you are done setting.

  9. If you have enabled the Encryption Key feature in the previous step, the following pop-up window shows, no matter which encryption type you have selected.

    Encryption Key

    The pop-up window has the following three optoins to choose from:

    • Unmask encryption key - The encryption key is masked by default. Click this option to show the encryption key.

      Encryption Key

    • Copy to clipboard - Click to copy the encryption key, then you can paste it in another location of your choice.
    • Confirm - Click to exit this pop-up window and proceed to the next step.
  10. Backup set created.

    • To start a manual backup job, click on Backup now

      Backup Set Created

    • To verify the backup set settings, click on Close and then click on the MySQL backup set to complete the setup.

      Backup Set

      Settings

  11. Based on Best Practices and Recommendations, it is highly recommended to change the "Temporary Directory". Select another location with sufficient free disk space other than:

    Drive C:\Users\Administrator\temp (e.g. D:\temp)

    Open the Backup set then go to Others > Temporary Directory. Click Change to browse for another location.

    Temporary Directory

  12. Optional: Select your preferred compression type. By default, the compression is Fast with optiomization for local.

    Go to Others > Compressions. Select from the following list:

    • No Compression
    • Normal
    • Fast (Compressed size larger than normal)
    • Fast with optimization for local

    Compressions