Backup mysql using duplicity

backup.sh

#!/bin/bash

# ######################################################
# Use duplicity to backup all files in BACKUP_DIR
#
# 1. run mysqldump
# 2. transfer all *.sql files to AWS_BUCKET w/ duplicity
# 3. remove all files older than 7 days
#
# ######################################################

# source env variables
. "$HOME/.duplicity/.env_variables.conf"

# run 3 steps
cd $BACKUP_DIR \
  && mysqldump $DB_NAME -r $DB_FILE \
  && duplicity \
    --verbosity info \
    --encrypt-sign-key=$GPG_KEY \
    --full-if-older-than 7D \
    --log-file $HOME/.duplicity/info.log \
      $BACKUP_DIR $AWS_ENDPOINT/$AWS_BUCKET \
  && find $BACKUP_DIR -type f -mtime +7 -name '*.sql' -execdir rm -- '{}' +

# unset env variables
unset AWS_ACCESS_KEY_ID
unset AWS_SECRET_ACCESS_KEY
unset AWS_BUCKET
unset GPG_KEY
unset PASSPHRASE
unset DB_NAME
unset DB_DATE
unset DB_FILE
unset BACKUP_DIR