User Tools

Site Tools

You are here: Home » Start Searching Anything About CloudBacko Here! » Modules » MariaDB Backup Module for CloudBacko Pro » Creating a MariaDB Database Backup Set
public:module:mariadb_database:create_backup_set

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
public:module:mariadb_database:create_backup_set [2021/02/02 13:45]
ronnie.chan 		public:module:mariadb_database:create_backup_set [2021/02/02 14:27] (current)
ronnie.chan
Line 1: Line 1:
 ====== Creating a MariaDB Database Backup Set ====== ====== Creating a MariaDB Database Backup Set ======
 +----
  
 1. Click the Backup Sets icon. 1. Click the Backup Sets icon.
-{{public:​module:​mariadb_database:​image036.png}}+ 
 +| {{public:​module:​mariadb_database:​image036.png}} ​|
    
 2. Create a new backup set by clicking the **Add** button to created new backup set. 2. Create a new backup set by clicking the **Add** button to created new backup set.
-{{public:​module:​mariadb_database:​image038.png?​800}}+ 
 +| {{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. 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:​image038.png?800}}+ 
 +| {{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. +4. In the Backup Source menu, select the MariaDB databases you would like to backup. Click **Next** to proceed.
-{{public:​module:​mariadb_database:​image040.png?​800}}+
  
-NOTE +| {{public:​module:​mariadb_database:​image042.png?800}} |
-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. . +
-5. In the Schedule menu, you can configure a backup schedule for backup job to run automatically at your specified time interval. ​     ​+
  
-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.+<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}} |
    
-NOTE+<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. 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. ​    ​+6. Select a backup mode and click the "**+**" ​sign icon to select a backup storage destination.
  
-7. Select the backup storage destination. Click on OK to proceed. +| {{public:module:​mariadb_database:​image048.png?​800}} |
-Example: AhsayCBS server ​     ​+
  
-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. ​    +7. Select ​the backup ​storage destination. Click on **OK** ​to proceed.
-You can choose from one of the following three Encryption Type options: +
- Default – an encryption key with 44 alpha numeric characters will be randomly generated by the system. +
- User password – the encryption key will be the same as the login password of your AhsayOBM at the time when this backup ​set is created. Please be reminded that if you change the AhsayOBM login password later, the encryption keys of the backup sets previously created with this encryption type will remain unchanged. +
- Custom – you can customize your encryption key, where you can set your own algorithm, encryption key, method, and key length. +
-  +
-NOTE +
-For best practice ​on managing your encryption key, refer to the following wiki article. https://​wiki.ahsay.com/​doku.php?​id=public:​8015_faq:​best_practices_for_managing_encryption_key+
  
-Click Next when you are done setting. +| {{public:​module:​mariadb_database:​image050.png?​800}} | 
-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.+ 
 +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: 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.+ 
 +  * **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. +  * **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.  ​+
  
-NOTE+  * **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. 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**.
  
-11. Backup set created. +| {{public:​module:​mariadb_database:​image062.png?800}} |
-i. To start a manual backup job, click on Backup now.+
    
-ii. To verify the backup set settings, click on Close and then click on the MariaDB backup set to complete the setup.+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.
    
-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. 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. +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 +
- +
  
 +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}} |
public/module/mariadb_database/create_backup_set.1612244713.txt.gz · Last modified: 2021/02/02 13:45 by ronnie.chan

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki