wp-backup.sh

#!/bin/bash
sitename="$1"
if [[ "$sitename" =~ ^/.* ]]; then
    wwwdir="$sitename"
else
    wwwdir="/var/www/sites/$sitename"
fi
files="wp-content"
bucket="$2"
s3cmd="$HOME/bin/s3cmd"

if [ -z "$sitename" -o -z "$bucket" ]; then
    echo "Usage: $0 [sitename] [bucket-name]"
    exit 1
fi

prefix=`basename $sitename`
s3loc="s3://$bucket/`date +%Y/%m`/"
today=`date +%Y%m%d`
dir="$HOME"

wp db export - --path="$wwwdir" --skip-themes --skip-plugins --add-drop-table | gzip > $dir/$prefix-db-$today.sql.gz
bash -c "cd $wwwdir && tar czf $dir/$prefix-content-$today.tar.gz $files"

# Copy files to S3
$s3cmd --quiet put "$dir/$prefix-db-$today.sql.gz" "$dir/$prefix-content-$today.tar.gz" "$s3loc" && rm "$dir/$prefix-db-$today.sql.gz" "$dir/$prefix-content-$today.tar.gz"