Creates a backup of your Uberspace home folder, as well as your websites and MySQL databases.

backup_uberspace.sh

#!/bin/bash

# This script creates a backup of your Uberspace home folder, as well as your
# websites and MySQL databases. Configure username and server before running.
#
# TODO ^C should quit this entire script and clean up first (remove db backup)
# TODO some error handling and exit codes
# TODO set username and server via flags
# TODO sanity checking before backup: "these server contents get copied to this local folder"

USERNAME="doersino"
SERVER="draco"
IN="$USERNAME@$SERVER.uberspace.de"
OUT="$HOME/Desktop/uberspace_$(date +%F)"

function echob() {
	BOLD=$(tput bold)
	NORMAL=$(tput sgr0)
	echo "${BOLD}$@${NORMAL}"
}

[[ -d "$OUT" ]] && echob "You've already made a backup today, no refill for you!" && exit

STARTTIME=$(date +%s)

echob "Backing up database..."
ssh -4 "$IN" "mysqldump -u $USERNAME -p --all-databases > all-databases.sql"

echob "Backing up home directory, including database backup..."
mkdir -p "$OUT/home/$USERNAME"
scp -pr "$IN:/home/$USERNAME" "$OUT/home/"

echob "Backing up web-accessible files..."
mkdir -p "$OUT/var/www/virtual/$USERNAME"
scp -pr "$IN:/var/www/virtual/$USERNAME" "$OUT/var/www/virtual/"

echob "Removing database backup..."
ssh -4 "$IN" "rm all-databases.sql"

ENDTIME=$(date +%s)
TOTALTIMESECONDS=$(($ENDTIME - $STARTTIME))
TOTALTIMEMINUTES=$(($TOTALTIMESECONDS / 60))

echob "Done! Elapsed time: $TOTALTIMEMINUTES minutes"