Github action needed to take database (running on azure vm) to storage account

Job ID: 34681040

Budget: ₹600 – ₹1,100 INR

Scenerio :
have a vm which has a blob fuse mounted on storage account
have a script which have logic to take backup and copy the database into the fuse mount point
this script runs as cron job daily

Already have script : $backupscript.sh
USAGE $ ./backupscript.sh <serverip> <name of db>

Solution Needed

Have a github action to take the entire backup with below steps in workflow
1.Checks out the github which has the backup.sh (already written) script
2.Copy the script in any running path .Say /mnt/workingfusepath
3.Checks if mount path is fully working , if not remount the fuse path (https://learn.microsoft.com/en-us/azure/storage/blobs/storage-how-to-mount-container-linux)
4.Run the backup script ,which was copied in 2 against the name of the database passed by the UI of githib actions.
Eg ./ backscript.sh 10.2.3.1 testdb1
5. The above will create a backupwithcurretndate.testdb1.ta.gz
this will automatically copy the same file via fuse to container .

So in one button click and by selecting db name in the UI was able to take the entire backup to storage account
Related categories: Linux Shell Script Microsoft Azure