Cacher is the code snippet organizer for pro developers

#!/bin/bash

export DB_BACKUP=`pwd`
# modify the following to suit your environment

export PROJECT="alias_site"

# title and version
echo ""
echo "Backup and rotate all mysql databases"
echo "--------------------------"

echo $DB_BACKUP
rm -rf $DB_BACKUP/05
mv $DB_BACKUP/04 $DB_BACKUP/05
mv $DB_BACKUP/03 $DB_BACKUP/04
mv $DB_BACKUP/02 $DB_BACKUP/03
mv $DB_BACKUP/01 $DB_BACKUP/02
mkdir $DB_BACKUP/01

echo "* Creating backup..."
echo $PROJECT-$(date +%Y-%m-%d-%H.%M.%S).sql.gz
drush @$PROJECT sql-dump | gzip -9 > $DB_BACKUP/01/$PROJECT-$(date +%Y-%m-%d-%H.%M.%S).sql.gz
echo "----------------------"
echo "Done"
exit 0