mysql_backup.sh

#!/bin/bash

DRY_RUN=
DATABASE=
cd /tmp/

mysqldump --skip-dump-date --opt --flush-logs --single-transaction ${DATABASE} bzcat -zc > ${DATABASE}.sql.bz2

for i in `seq 5 -1 2`; do 
  PREV_I=$(expr $i - 1)
  ${DRY_RUN}s3cmd mv s3://kodekoan-backups/${DATABASE}.sql.bz2.${i} s3://kodekoan-backups/${DATABASE}.sql.bz2.${PREV_I}
done
${DRY_RUN}s3cmd mv s3://kodekoan-backups/${DATABASE}.sql.bz2 s3://kodekoan-backups/${DATABASE}.sql.bz2.1
${DRY_RUN}s3cmd put ${DATABASE}.sql.bz2 s3://kodekoan-backups/${DATABASE}.sql.bz2

rm ${DATABASE}.sql.bz2