Backup Script for WordPress to s3 using s3cmd

backup.sh

#!/usr/bin/env bash
# Back up Script to Amazon S3
# Source: 
# Author: Amit

#path to WordPress installations
SITESTORE=/var/www

#S3 bucket
S3DIR="s3://bucket-name/"

MYSQL_USER=''
MYSQL_PASS=''

DATE=$(date +%Y%m%d)
LOGFILE=/var/log/s3backup/$DATE.log
EMAIL=''

mkdir -p /var/log/s3backup
touch $LOGFILE

#create array of sites based on folder names
SITELIST=($(ls -lh $SITESTORE | awk '{print $9}'))

#start the loop
for SITE in ${SITELIST[@]}; do
    echo Backing up $SITE
    #enter the WordPress folder
    #cd $SITESTORE/$SITE
    if [ $SITE == '22222' ]|| [ $SITE == 'html' ]; then
        echo Skipping $SITE
		continue
		
    fi

	DBNAME=${SITE//./_}
	
	echo database is $DBNAME
	if [ ! -e $SITESTORE/$SITE/db ]; then
        mkdir $SITESTORE/$SITE/db
    fi
	#back up the WordPress database
	mysqldump -u $MYSQL_USER -p$MYSQL_PASS --routines --single-transaction --quick --lock-tables=false $DBNAME | gzip -9 > $SITESTORE/$SITE/db/$DBNAME.sql.gz
	
done
 #back up the WordPress folder
/usr/local/bin/s3cmd sync --exclude '22222/*' --exclude 'html' --exclude '.git/*' --exclude 'logs/*' $SITESTORE/ --delete-removed --preserve $S3DIR | tee -a $LOGFILE

#/usr/bin/mail -s "Backup report for KABIR DO Server ON $DATE" $EMAIL < $LOGFILE

LOGFILE="/var/log/s3backup/$DATE-loantap-uploads.log"
touch $LOGFILE

#/usr/local/bin/s3cmd sync $SITESTORE/ --preserve $S3DIR >> $LOGFILE
/usr/local/bin/aws s3 sync $SITESTORE/ $S3DIR --endpoint-url http://s3-accelerate.amazonaws.com --profile default | tee -a $LOGFILE