How to backup MySQL databases on Google Cloud SQL Platform?

Please use the following steps to backup MySQL databases using AhsayOBM on Google Cloud SQL.

Create backup set

1. Login to your OBM user account via the AhsayCBS web management console.
2. Go to User.
3. Open Backup Sets.
4. Click the [+] sign to create a new backup set.
5. To proceed, check the names of the databases you aim to backup first (You may use a utility like MySQL Workbench).
6. Ater confirming the databases, go back to your AhsayCBS web management console.
7. Change the backup set type to MySQL Backup.
8. Rename the file backup set.
9. Select Linux for platform.
10. Enter the login ID and password, followed by the host of the machine used.
11. You may keep the Port value on default or change it accordingly if your MySQL database instance is setup using a different port.
12. Before entering the path for mysqldump, make sure that the MySQL version on the Google Cloud SQL matches the version installed on the backup machine you're using.
13. Under Other selected source, click the [+] button to add a backup source.
14. Manually enter the directory path of each database you intent to backup. Click the [+] to continue.
15. Repeat the same step if you intend to add other sources as well.
16. Click Next to continue.
17. Enter the host name to use the computer name for the scheduler.
18. You may use the default schedule provided or create a new one.
19. Click Next.
20. Click the [+] button to add a new storage destination and select Ahsay Drive.
21. Click the [+] button again.
22. Leave the backup mode on Sequential.
23. Click Save.

Configure the settings before running backup job

1. Click on the backup set.
2. Recommended: Open Retention Policy and enable Simple retention policy for 30 days.
3. Click Others and configure the Temporary Directory.
4. Leave Compressions on default. Encryption key will be set up on Linux CLI.
5. Scroll down and enable File Viewer.
6. Click Save.

Set up the encryption key

1. Login as root to the Linux backup machine using an SSH client.
2. Use the cd command to go to bin: cd /usr/local/obm/bin
3. Open AhsayOBM to setup the encryption key: sh RunConfigurator.sh
4. Enter 1 to login.
5. Enter the login name and password.
6. Enter Y to setup the encryption key of your backup set.
7. Enter Y again to confirm.
8. Enter 1 to select Default.
9. Enter 8 to quit

Run the backup job

1. Use the sh command to run the backup job: sh RunBackupSet.sh '[backup set name]'
2. After the backup job, a line will indicate Backup Completed Successfully.

Check the backed up databases from File Viewer

1. Open File Viewer and reload the page.
2. Select the backup set.
3. Click on the MySQL folder to see all the databases backed up.