Server backup - MySQL & Vhosts - to S3 usign s3cmd

mysql-backup.sh

#! /bin/bash

# MySQL requirements
# CREATE USER 'backup'@'localhost' IDENTIFIED BY 'secret';
# GRANT SELECT, SHOW VIEW, RELOAD, REPLICATION CLIENT, EVENT, TRIGGER ON *.* TO 'backup'@'localhost';
# GRANT LOCK TABLES ON *.* TO 'backup'@'localhost';

TIMESTAMP=$(date +"%A")
DATE=$(date +"%F")
BACKUP_DIR="./mysql-backup"
MYSQL_USER="backup"
MYSQL=/usr/bin/mysql
MYSQL_PASSWORD="*****"
MYSQLDUMP=/usr/bin/mysqldump

mkdir -p "$BACKUP_DIR/$TIMESTAMP"

databases=`$MYSQL --user=$MYSQL_USER -p$MYSQL_PASSWORD -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)"`

for db in $databases; do
  $MYSQLDUMP -v --force --opt --user=$MYSQL_USER -p$MYSQL_PASSWORD --databases $db | gzip > "$BACKUP_DIR/$TIMESTAMP/$db.gz"
done

if [ $(date +"%d") = "01" ]; then
  mkdir -p "$BACKUP_DIR/$DATE"
  cp -R $BACKUP_DIR/$TIMESTAMP/* "$BACKUP_DIR/$DATE/"
fi

s3cmd sync --recursive --delete-removed ./mysql-backup s3://server-backup-syd/

vhosts-backup.sh

#!/bin/bash

s3cmd sync --recursive --exclude-from=/root/backup/vhosts-backup.exclude /var/www/vhosts/ s3://server-backup-syd/vhosts-backup/

Todo: consider to use automysqlbackup tool