#!/bin/bash

cd /home/myuserroot/

S3CONF=/home/myuserroot/.s3conf

BUCKET=offsite.mydomain.net

DB_BASE=db_
DB_USER=username
DB_PWD=password

NOW=$(date +%Y%m%d)

DB_GLOBAL=db_global

#

cd /home/myuserroot/s3sync/s3backup

# Backup the global DB

touch $DB_GLOBAL.backup$NOW.sql.gz

mysqldump -u $DB_USER -p$DB_PWD $DB_GLOBAL | gzip -9 > $DB_GLOBAL.backup$NOW.sql.gz

# Now on to the 255 other dbs

for i in {1..255}
do
touch $DB_BASE$(printf "%s" ""$i" "16" o p" | dc | tr '[A-Z]' '[a-z]').backup$NOW.sql.gz

mysqldump -u $DB_USER -p$DB_PWD $DB_BASE$(printf "%s" ""$i" "16" o p" | dc | tr '[A-Z]' '[a-z]') | gzip -9 > $DB_BASE$(printf "%s" ""$i" "16" o p" | dc | tr '[A-Z]' '[a-z]').backup$NOW.sql.gz

done

cd ..

/usr/local/bin/ruby s3sync.rb -r --ssl s3backup/ $BUCKET:mybackups

cd s3backup

rm -f *