Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Creates a backup of your Uberspace home folder, as well as your websites and MySQL databases.
#!/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"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.