#!/bin/bash

S3_BUCKET=my_backups
MYSQL_USER=user
MYSQL_PASS=secret@pass
MYSQL_DB=db

cd /tmp

file="db-$(date +%a).sql"

mysqldump \
  -u ${MYSQL_USER} \
  -p"${MYSQL_PASS}" \
  ${MYSQL_DB} > ${file}

if [ "${?}" -eq 0 ]; then
  gzip ${file}
  s3cmd put ${file}.gz s3://${S3_BUCKET}
  rm ${file}.gz
else
  echo "Error backing up mysql"
  exit 255
fi