Backup script -- runs on hosting site, assumes already setup aliases for wp-cli

backup

#!/bin/bash

PATH=$PATH:/usr/local/bin

# Loop through all sites,
echo "Starting backups @$(date)"
for site in $(cat $HOME/etc/sites); do
        cd $HOME/backups
        BKDIR="$HOME/backups/$site/"
        if [ ! -d "$BKDIR" ]; then
                #make sure new directory exists
                mkdir -p $BKDIR
        fi
        echo "Starting backup for $site"
        cd $BKDIR
        wp @$site db export --add-drop-table - |gzip > database.sql.gz
        tar czf wordpress.tgz -C /var/www/html $site
        echo "Finished backukp for $site"
        echo
done