AhsayCBSRun a MySQL Backup Job on AhsayOBM
Similar to the process to create a MySQL Database Backup Set, there are great differences between the proccesses on Microsoft and Linux Operating Systems, further nuanced by internal considerations of these platforms.
To view the steps on how to run a MySQL Database Backup Set for these systems, please select from below:
Running a MySQL Database Backup Set on Windows
-
Click the Backup icon on the main interface of AhsayOBM.
- Select the MySQL database backup set which you would like to start a manual backup.
-
You can modify the "Destinations" and "Migrate Data" options.
The Migrate Data option will only be displayed if Deduplication is enabled for the backup set. When the Migrate Data option is enabled, the existing data will be migrated to the latest version during a backup job. Backup job(s) for backup sets with Migrate Data enabled may take longer to finish. For more information about this feature, refer to AhsayCBS v9 New Features Datasheet.
-
Click on Backup to start the backup job. Once finished, "Backup Completed Successfully" will be displayed.
To check the log of your backup, click the "magnifying" icon to show you the log of your backup with corresponding date and time.
Running a MySQL Database Backup Set on Linux
Use the RunBackupSet.sh script to start a backup job manually.
Example: RunBackupSet.sh
#cd /usr/local/obm/bin #sh RunBackupSet.sh "MySQL Database 1" - Using APP_HOME : /usr/local/obm Using SETTING_HOME : Using JAVA_HOME : /usr/local/obm/jvm Using JAVA_EXE : /usr/local/obm/jvm/bin/java Using JAVA_OPTS : -Xrs -Xms128m -Xmx2048m -XX:MaxDirectMemorySize=512m - client -Dsun.nio.PageAlignDirectMemory=true Using JNI_PATH : -Djava.library.path=.:./LinX64 Using CLASSPATH : .:./cb.jar - Running Backup Set - 'MySQL Database 1' ... [2023/03/20 15:18:16] [info] [-] Start [ AhsayOBM v9.5.2.0 ] [2023/03/20 15:18:16] [info] [-] Saving encrypted backup set encryption keys to server... [2023/03/20 15:18:18] [info] [1679289705561] Start Backup ... Database [Deduplication: enabled, Deduplication scope: All files within the same backup set, Migrate Data: disabled, Chunking: CDC(512 K-2 M)] [2023/03/20 15:18:18] [info] [1679289705561] Using Temporary Directory /root/temp/1679282248469/Local@1679289705561 [2023/03/20 15:18:19] [info] [1679289705561] Direct download index /root/temp/1679282248469/Local@1679289705561/index/index.db [2023/03/20 15:18:19] [info] [1679289705561] Skip download index since local index "/root/temp/1679282248469/Local@1679289705561/index" is latest or identical to destination copy on 2023-03-20-13-27-46 [2023/03/20 15:18:20] [info] [-] Start running pre-commands [2023/03/20 15:18:20] [info] [-] Finished running pre-commands [2023/03/20 15:18:20] [info] [-] [Start] Backing up database "test" to "/root/temp/1679282248469/SpoolArea/MySQL/test.sql" [2023/03/20 15:18:21] [info] [-] [End] [2023/03/20 15:18:21] [info] [-] [Start] Backing up database "world" to "/root/temp/1679282248469/SpoolArea/MySQL/world.sql" [2023/03/20 15:18:21] [info] [-] [End] [2023/03/20 15:18:21] [info] [-] Start running post-commands [2023/03/20 15:18:21] [info] [-] Finished running post-commands [2023/03/20 15:18:30] [info] [1679289705561] Downloading server file list... [2023/03/20 15:18:30] [info] [1679289705561] Direct download index /root/temp/1679282248469/Local@1679289705561/index/index.db [2023/03/20 15:18:30] [info] [1679289705561] Skip download index since local index "/root/temp/1679282248469/Local@1679289705561/index" is latest or identical to destination copy on 2023-03-20-13-27-46 [2023/03/20 15:18:31] [info] [1679289705561] Downloading server file list... Completed [2023/03/20 15:18:32] [info] [1679289705561] Reading backup source from hard disk... [2023/03/20 15:18:32] [info] [1679289705561] Reading backup source from hard disk... Completed [2023/03/20 15:18:32] [info] [1679289705561] [Update Attribute]... 100% of "MySQL" [2023/03/20 15:18:32] [info] [1679289705561] [Update File]... 100% of "MySQL/world.sql" [2023/03/20 15:18:32] [info] [1679289705561] [Update File]... 100% of "MySQL/test.sql" [2023/03/20 15:18:33] [info] [1679289705561] Start validating the presence and size of backup data in destination "Local-1"... [2023/03/20 15:18:33] [info] [1679289705561] File: "1679282248469/blocks/2023-03-20-15-18-06/0/000000.bak", Size: 1,072, OK [2023/03/20 15:18:33] [info] [1679289705561] File: "1679282248469/blocks/2023-03-20-15-18-06/0/000001.bak", Size: 1,120, OK [2023/03/20 15:18:33] [info] [1679289705561] Finished validating the presence and size of backup data in destination "Local-1" [2023/03/20 15:18:33] [info] [1679289705561] Total New Files = 0 [2023/03/20 15:18:33] [info] [1679289705561] Total New Directories = 0 [2023/03/20 15:18:33] [info] [1679289705561] Total New Links = 0 [2023/03/20 15:18:33] [info] [1679289705561] Total Updated Files = 2 [2023/03/20 15:18:33] [info] [1679289705561] Total Attributes Changed Files = 1 [2023/03/20 15:18:33] [info] [1679289705561] Total Deleted Files = 0 [2023/03/20 15:18:33] [info] [1679289705561] Total Deleted Directories = 0 [2023/03/20 15:18:33] [info] [1679289705561] Total Deleted Links = 0 [2023/03/20 15:18:33] [info] [1679289705561] Total Moved Files = 0 [2023/03/20 15:18:33] [info] [1679289705561] Total Dedupe Saving for this job = 0 B [2023/03/20 15:18:33] [info] [1679289705561] Total Backup Data Size for this job = 7 KB [2023/03/20 15:18:33] [info] [1679289705561] Total Dedupe Saving for destination = 0 B [2023/03/20 15:18:33] [info] [1679289705561] Total Backup Data Size for destination = 13.99 KB [2023/03/20 15:18:33] [info] [-] Deleting temporary file /root/temp/1679282248469/SpoolArea [2023/03/20 15:18:33] [info] [-] Saving server information to destination. [2023/03/20 15:18:34] [info] [1679289705561] Saving encrypted backup file index to 1679282248469/blocks/2023-03-20-15-18-06 at destination Local-1... [2023/03/20 15:18:37] [info] [1679289705561] Deleting temporary file /root/temp/1679282248469/Local@1679289705561 [2023/03/20 15:18:38] [info] [1679289705561] Backup Completed Successfully