S3 backup for ServerPilot

awsbackup.sh

#!/bin/bash

export BUCKET=filament-sp-backup

date_daily=`date +"%Y-%m-%d"`
tmp_dir=/tmp/sp-backup-$date_daily

# Get current month and week day number
month_day=`date +"%d"`
week_day=`date +"%u"`

# On first month day do
if [ "$month_day" -eq 1 ] ; then
        destination=$tmp_dir/monthly/`hostname`/$date_daily
        type="monthly"
else
        # On saturdays do
        if [ "$week_day" -eq 6 ] ; then
                destination=$tmp_dir/weekly/`hostname`/$date_daily
                type="weekly"
        else
        # On any regular day do
                destination=$tmp_dir/daily/`hostname`/$date_daily
                type="daily"
        fi
fi

rm -fr $tmp_dir/*

db_destination=db/`hostname`/
echo $db_destination
s3cmd sync --recursive --preserve /var/lib/automysqlbackup/ s3://$BUCKET/$db_destination

shopt -s dotglob


find /srv/users/* -prune -type d | while read d; do

        user=$(basename "$d")
        find $d/apps/* -prune -type d | while read e; do

                app=$(basename "$e")

                # skip daily dev site backups
                if ([[ "$app" =~ ^(dev|staging|proto) ]] || [[ "$app" =~ (dev|staging|proto)$ ]]) &&  [[ "$type" == "daily" ]] ; then
                        continue
                fi


                cd $d/apps
                mkdir -p $destination/$user/apps
                archive=$destination/$user/apps/$app.tgz
                echo "$e => $archive"

                tar cvzfp $archive $e

        done
done

find /etc/apache-sp/vhosts.d/*.d/*.conf ! -name "main.conf" -exec tar -rvf $destination/sp-config.tar {} \;
find /etc/nginx-sp/vhosts.d/*.d/*.conf ! -name "main.conf" -exec tar -rvf $destination/sp-config.tar {} \;
find /etc/nginx-sp/ssl/ -type f -exec tar -rvf $destination/sp-config.tar {} \;


s3cmd put --recursive $tmp_dir/* s3://$BUCKET/

rm -fr $tmp_dir

Seems to work like a charm. Good job!

Is it possible to delete the oldest daily backup when it hits an specific count? In my case, daily backups should only be saved for 7 days.
Same for the weekly and monthly backup.

Hi @robbens

Sorry I didn't see this until now.

I use S3 Lifecycle rules to purge the backups on S3. For instance, daily backups removed after 8 days, weekly after 15, monthly after 65. You could also choose to send to Glacier Storage.

Awesome! Does this get recognized as a backup in serverpiolot? How would you restore from the backup?