How to backup MySQL databases on Windows?

Backup all your MySQL database servers with Ahsay for total protection. To ensure data consistency Ahsay uses the mysqldump utility to stream the backup data directly to the storage destination, without the need for a staging file simplifying the setup. Ahsay supports logical MySQL backups for flexible recovery options, the backup data can be used to recover the database on different MySQL versions and or operating systems for total peace of mind.

Please use the following steps to backup MySQL databases using AhsayOBM.

1. On your desktop, click the AhsayOBM icon.
2. Once you're on the AhsayOBM login page, enter your credentials to access your account. Then, click [OK].
3. From the AhsayOBM home screen, select [Backup Sets].
4. Click the [+] sign to create a new backup set.
5. Rename the file backup set or use the default name provided.
6. Change the backup set type to MySQL Backup.
7. Enter the root password.
8. Keep the Host and Port on default. Unless your MariaDB database utilizes an alternate port, adjust the value accordingly.
9. Enter the path for mysqldump.
10. Click [Next] to continue.
11. Select the databases that you aim to backup, then click [Next].
12. Turn on scheduled backup.
13. Click the [+] sign to create a new backup schedule.
14. Enable Run Retention Policy after backup. Click [OK], then [Next] to proceed.
15. Select Concurrent as backup mode
16. Leave the maximum concurrent backup destinations on default.
17. Then click the [+] sign to add a new storage destination. Ahsay Drive is selected by default.
18. Click [OK].
19. Click [Add] to add another destination, then select a local destination.
20. Click [Next].
21. Keep the default setting for Encryption. Click [Save].
22. Keep a copy of your encryption key. Click [Confirm].
23. For Windows User Authentication, enter your Windows password to provide AhsayOBM permissions to access various components on the selected local destination.
24. Click [Next].
25. You now have the option to backup your files by clicking [Backup Now].
26. Or click [Close] and wait for AhsayOBM to backup your files on the schedule you set it on.