Creating a MariaDB Database Backup Set []

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Creating a MariaDB Database Backup Set ======
----

1. Click the Backup Sets icon.

| {{public:module:mariadb_database:image036.png}} |
 
2. Create a new backup set by clicking the **Add** button to created new backup set.

| {{public:module:mariadb_database:image038.png?800}} |

3. Select the **Backup set type** and name your new backup set and enter the login information for the MariaDB server then click **Next** to proceed.

| {{public:module:mariadb_database:image040.png?800}} |
 
4. In the Backup Source menu, select the MariaDB databases you would like to backup. Click **Next** to proceed.

| {{public:module:mariadb_database:image042.png?800}} |

<WRAP info>
The "information_schema" and "performance_schema" databases are MariaDB virtual system databases, which contains information about the user databases on the MariaDB instance, are automatically excluded from the backup source.  They are read-only and cannot be backed up, therefore they are grayed out and cannot be selected.
</WRAP>

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

| {{public:module:mariadb_database:image044.png?800}} |

Click **Add** to add a new schedule or double click on the existing schedule to change the values.  Click Next to proceed when you are done setting.

| {{public:module:mariadb_database:image046.png?800}} |
 
<WRAP info>
The default backup schedule is daily backup at 3:00 with the backup job will run until completion and the retention policy job will be run immediately after the backup job.
</WRAP>

6. Select a backup mode and click the "**+**" sign icon to select a backup storage destination.

| {{public:module:mariadb_database:image048.png?800}} |

7. Select the backup storage destination. Click on **OK** to proceed.

| {{public:module:mariadb_database:image050.png?800}} |

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. 

| {{public:module:mariadb_database:image052.png?800}} |
   
You can choose from one of the following 2 Encryption Type options:

  * **Default** – an encryption key with 44 alpha numeric characters will be randomly generated by the system.
  * **Custom** – you can customize your encryption key, where you can set your own algorithm, encryption key, method, and key length. 
<WRAP indent>
| {{public:module:mariadb_database:image054.png?800}} |
</WRAP>

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.

| {{public:module:mariadb_database:image056.png?800}} |
 
The pop-up window has the following three options to choose from:

  * **Unmask encryption key** – The encryption key is masked by default. Click this option to show the encryption key.

<WRAP indent>
| {{public:module:mariadb_database:image058.png?800}} |
</WRAP>
 
  * **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. Enter the Windows login credentials used by AhsayOBM to authenticate the scheduled or continuous backup job and click Next to proceed.  

| {{public:module:mariadb_database:image060.png?800}} |

<WRAP indent?
If the backup schedule is turned off and the selected destination storage is not a network shared drive, the Windows User Authentication screen will be automatically skipped.  The Windows User Authentication login credentials can be added or updated post backup set creation.
</WRAP>

11. Backup set created.

i. To start a manual backup job, click on **Backup now**.

| {{public:module:mariadb_database:image062.png?800}} |
 
ii. To verify the backup set settings, click on Close and then click on the MariaDB backup set to complete the setup.

| {{public:module:mariadb_database:image064.png?800}} |

| {{public:module:mariadb_database:image066.png?800}} |
 
12. It is highly recommended to change the Temporary Directory. Select another location with sufficient free disk space other than Dive C\Users\Administrator\temp.
 
Go to Others > Temporary Directory. Click Change to browse for another location.

| {{public:module:mariadb_database:image068.png?800}} |
 
It is recommended to check the **Remove temporary files after backup** to make sure the spooled database files are cleaned up after each backup job to free up space on the temporary drive.  Otherwise, if the temporary drive runs out of space the database backup job will not run.

13. **Optional**: Select your preferred **Compression** type. By default, the compression is Fast with optimization 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
 
| {{public:module:mariadb_database:image070.png?800}} |
User Tools

Site Tools

Page Tools
