backup.sh

#!/bin/bash
BUCKET=$1
if [ -z "$BUCKET" ]
then
      echo "-bucket must be specified"
      exit 1;
fi
d=`date +%Y-%m-%d`
wproot="${HOME}/public_html"   # change this to your actual wordpress directory
echo "`date`" - WordPress Backup started
cd ${wproot}
wp db export --add-drop-table - > "${HOME}/tmp/wordpress-${d}.sql"
gsutil -q cp "${HOME}/tmp/wordpress-${d}.sql" gs://${BUCKET}
rm "${HOME}/tmp/wordpress-${d}.sql"
tar -czf - -C ${wproot} . > "${HOME}/tmp/wordpress-${d}.tar.gz"
gsutil -q cp "${HOME}/tmp/wordpress-${d}.tar.gz" gs://${BUCKET}
rm "${HOME}/tmp/wordpress-${d}.tar.gz"
echo "`date`" - WordPress Backup ended