#!/usr/local/bin/bash # # comprehensive TextDrive backup to Strongspace # Joel Dueck (http://jdueck.net) # # This script will backup all websites in your TextDrive account to Strongspace. # # 1. Save this script into your home dir, chmod it to 700 for security # 2. Create a pair of ssh keys; install the public key on your strongspace account and the private one in ~/.ssh # 3. Change the configuration variables below ## Configuration section # [Don't forget trailing slashes for all directories!] MYSQL_USERNAME=name MYSQL_PW=password # Optional: Enter the path in your TextDrive account where your database backups are stored. # If found, this directory will be rsync'd to strongspace separately. If this folder does not exist then # this feature will be ignored. # For a cron job that will create daily rolling MySQL backups, see http://textsnippets.com/posts/show/419 DB_BACKUP_DIR=~/daily-sql-backup/ STRONGSPACE_KEY=/home/YOURUSERNAME/.ssh/ss # Private key file STRONGSPACE_USER=SSUSER # Your strongspace login name STRONGSPACE_DOMAIN=SSDOMAIN.strongspace.com # Your strongspace domain STRONGSPACE_WEB_BACKUP_DIR=private/backup/web/ # strongspace path for storing web file backups STRONGSPACE_DB_BACKUP_DIR=private/backup/databases/ # optional strongspace path for storing SQL backups ## End of configuration section DOMAINS=`ls ~/domains` for dom in $DOMAINS do /usr/local/bin/rsync -azq --delete -e "ssh -i $STRONGSPACE_KEY" ~/domains/$dom/public_html/ $STRONGSPACE_USER@$STRONGSPACE_DOMAIN:/home/$STRONGSPACE_USER/$STRONGSPACE_WEB_BACKUP_DIR/$dom done if [ -d ~/public_html ]; then /usr/local/bin/rsync -azq --delete -e "ssh -i $STRONGSPACE_KEY" ~/public_html/ $STRONGSPACE_USER@$STRONGSPACE_DOMAIN:/home/$STRONGSPACE_USER/$STRONGSPACE_WEB_BACKUP_DIR/$dom fi if [ -d $DB_BACKUP_DIR ]; then /usr/local/bin/rsync -azq --delete -e "ssh -i $STRONGSPACE_KEY" $DB_BACKUP_DIR $STRONGSPACE_USER@$STRONGSPACE_DOMAIN:/home/$STRONGSPACE_USER/$STRONGSPACE_DB_BACKUP_DIR fi