I had a need to backup some Call logging\/asset management software we have running on a CentOs7 install to a network location, so that we can restore, should everything go tits up.<\/p>\n
It contains a backup of the MySQL DB’s and TARing them for moving to a new location and output to a log file.<\/p>\n
This could probably be slimmed down immensely, but it was my 1st shell script, so it’s rough around the edges!<\/p>\n
Here is the script.<\/p>\n
#!\/bin\/sh<\/em><\/p>\n
<\/p>\n
# GLPI Live Backup of SQL, WWW State currently not being backed up.<\/em><\/p>\n
# Runs at 06:00 evry day via a CronTab<\/em><\/p>\n
<\/p>\n
runat=”$(date “+%F”)”<\/em><\/p>\n
timethen=”$(date +”%H:%M:%S”)”<\/em><\/p>\n
<\/p>\n
printf “Daily Backup for %s\\n” “$runat” >> \/bkp\/logs\/BackupLog.log<\/em><\/p>\n
printf “Start of Task. $timethen %s\\n” >> \/bkp\/logs\/BackupLog.log<\/em><\/p>\n
printf “Create Todays Backup Folder…%s\\n” >> \/bkp\/logs\/BackupLog.log<\/em><\/p>\n
<\/p>\n
mkdir \/bkp\/”$runat”<\/em><\/p>\n
#mkdir \/bkp\/”$runat”\/www<\/em><\/p>\n
<\/p>\n
printf “Extracting SQL File…%s\\n” >> \/bkp\/logs\/BackupLog.log<\/em><\/p>\n
\/usr\/bin\/mysqldump -u glpi -p’Access to GLPI-Live 01′ glpi-live > \/bkp\/”$runat”\/GLPILiveBackup-“$runat”.sql<\/em><\/p>\n
<\/p>\n
printf “Compressing SQL File…%s\\n” >> \/bkp\/logs\/BackupLog.log<\/em><\/p>\n
<\/p>\n
7z a \/bkp\/GLPILiveBackup-“$runat”.7z \/bkp\/”$runat”\/GLPILiveBackup-“$runat”.sql<\/em><\/p>\n
rm -f \/bkp\/”$runat”\/GLPILiveBackup-“$runat”.sql<\/em><\/p>\n
<\/p>\n
#printf “Creating www root archive…%s\\n” >> \/bkp\/logs\/BackupLog.log<\/em><\/p>\n
#env pigz=-9 tar -zcvf \/bkp\/”$runat”\/www\/GLPIwwwBackup-“$runat”.tar.gz \/var\/www\/glpi<\/em><\/p>\n
#7z a \/bkp\/GLPILive-0.90.1-“$runat”.7z \/bkp\/”$runat”<\/em><\/p>\n
<\/p>\n
printf “Copying locally to Bel-NAS-01…%s\\n” >> \/bkp\/logs\/BackupLog.log<\/em><\/p>\n
cp –force \/bkp\/GLPILive-0.90.1-“$runat”.7z \/mnt\/bel-NAS-01\/GLPI-Backups\/<\/em><\/p>\n
<\/p>\n
printf “Copying remotely to Bel_Del…%s\\n” >> \/bkp\/logs\/BackupLog.log<\/em><\/p>\n
cp –force \/bkp\/GLPILive-0.90.1-“$runat”.7z “\/mnt\/bel_del\/Technical Team\/GLPI-Backup\/”<\/em><\/p>\n
<\/p>\n
rm -Rf \/bkp\/”$runat”<\/em><\/p>\n
<\/p>\n
timenow=”$(date +”%H:%M:%S”)”<\/em><\/p>\n
<\/p>\n
printf “\/bkp\/sql\/GLPILiveBackups-“$runat $timenow”.sql.gz %s\\n” >> \/mnt\/bel-NAS-01\/GLPI-Backups\/archive.txt<\/em><\/p>\n
printf “End of Task. $timenow %s\\n” >> \/bkp\/logs\/BackupLog.log<\/em><\/p>\n
printf “==============================%s\\n” >> \/bkp\/logs\/BackupLog.log<\/em><\/p><\/blockquote>\n
This works well and using p7zip i was able to get the over all size of the 100mb SQL dump down to 8mb 4 less than Gzip or TAR.<\/p>\n
As time wore on with this script running i had a need to tidy the out put. So done house keeping was required…<\/p>\n","protected":false},"excerpt":{"rendered":"
I had a need to backup some Call logging\/asset management software we have running on…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11,12],"tags":[],"class_list":["post-39","post","type-post","status-publish","format-standard","hentry","category-scripts","category-shell-scripts"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts\/39","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=39"}],"version-history":[{"count":0,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts\/39\/revisions"}],"wp:attachment":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=39"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=39"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}