Shell script that dumps a database and uses archiver.rb to send to an S3 bucket. I run this from cron.

backup-db.sh

#!/bin/bash

BUDIR="/home/mike/backup/db"

UN="username"
PW="password"
DB="database_name"
BUCKET="bucket-name"

ARCHIVER="/home/mike/backup/bin/archiver.rb"
MYDUMP="/usr/bin/mysqldump"
GZIP="/bin/gzip"

BUFILE="APPNAME-`date +'%Y%m%d-%H%M%S'`.sql.gz"

${MYDUMP} --opt --user="${UN}" --password="${PW}" ${DB} | ${GZIP} > ${BUDIR}/${BUFILE}

${ARCHIVER} "${BUCKET}" "${BUDIR}/${BUFILE}"