Backups, Backups, Backups

ssh root@db "mysqldump --all-databases --events --routines --triggers --single-transaction | gzip --rsyncable -3" > backup.sql.gz

ssh root@gogs "cd /home/git/gogs; tar c data | gzip --rsyncable" > gogsdata.tar.gz
ssh root@gogs "cd /home/git; tar c gogs-repositories | gzip --rsyncable" > gogs-repositories.tar.gz

#!/bin/bash

set -e

LOCKFILE=/tmp/usbbackup.lock
ERRFILE=/tmp/usbbackup.err
EMAIL="red@acted.com"

function cleanup {
        echo "Removing /tmp/backuplock"
        if [ -f $LOCKFILE ]; then
                rm $LOCKFILE
        fi
}

trap cleanup EXIT

function mailerr {
        echo $1 | mailx -s '[ERROR] rsync usb backup' $EMAIL
}

if [ $(id -u) -ne 0 ]; then
        echo 'Run as root'
        exit 1
fi

if [ -f $ERRFILE ]; then
        mailerr "Previous Error backing up!"
        exit 1
fi

mounted=$(mount | grep -l usbbackup | wc -l )
if [ $mounted -eq 0 ]; then
        mailerr "Device not mounted!!"
        exit 1
fi

touch $LOCKFILE
echo "Starting backup to external device" | mailx -s '[INFO] rsync usb backup' $EMAIL
rsync -av /backup/rsnapshot/daily.0/ /mnt/usbbackup/ >/tmp/usbbackup 2>&1 

if [ $? -ne 0 ]; then
        mailerr "RSYNC Error backing up!"
        exit 1
fi

umount /mnt/usbbackup/
echo "unmounting"
echo "Finished backup to external device" | mailx -s '[OK] rsync usb backup' $EMAIL

#!/bin/bash
set -e

if [ ! -f /tmp/usbbackup ]; then
        echo "touch /tmp/usbbackup or run a backup" | mailx -s '[Warning] No Last backup file!!' $MAIL #In case of server reboot
        exit 1
fi

now=$(date +%s)
last=$(stat -c %Y /tmp/usbbackup)
days=$(echo "($now-$last)/86400" | bc)

if [ $days -ge 6 ]; then
        echo "Go plug in the disk now" | mailx -s '[Warning] Last backup is over a week old' $MAIL
fi

#!/bin/bash
set -e
backing_up=0
mounted=0
connected=0

if [ $(mount | grep -c usbbackup) -gt 0 ]; then
        mounted=1
fi


usb=$(lsusb | grep -c "1058:0740")
if [ -L /dev/externalhdd ] || [ $usb -ne 0 ]; then
        connected=1
fi

if [ -f /tmp/usbbackup.lock ]; then
        backing_up=1
fi

if [ $backing_up -eq 1 ]; then
        exit 0
fi

if [ $mounted -eq 1 ]; then
        echo "The backup disk is mounted and the backup is done" | mailx -s '[Warning] USB Disk is still mounted' $MAIL
        exit 1
fi

if [ $connected -eq 1 ]; then
        echo "The backup disk is connected (unmounted) and the backup is done" | mailx -s '[Warning] USB Disk is still connected' $MAIL
        exit 1
fi

#!/bin/bash
set -euo pipefail
ROOTPATH="/backup/rsnapshot/daily.0"
function backup() {
        backup_path="$1"
        relative=$(echo $1 | sed "s:^$ROOTPATH/::")
        exclude=""
        while [ $# -gt 1 ]; do
                exclude="$exclude --exclude=$2"
                shift
        done
        /usr/bin/rsync --bwlimit=3m -avz $exclude --delete --numeric-ids --no-relative --delete-excluded "$backup_path" offsite1:backup/"$relative"/
}

backup  $ROOTPATH/server1/mysql/
backup  $ROOTPATH/localhost/            home/   network/ usr/ web/ etc/alternatives etc/ssl
backup  $ROOTPATH/nyc1/                 home/   var/vmail etc/alternatives etc/ssl
backup  $ROOTPATH/db
backup  $ROOTPATH/gogs
backup  $ROOTPATH/mumble
backup  $ROOTPATH/server2                etc/alternatives etc/ssl
backup  $ROOTPATH/pfsense