#!/bin/sh

# Uber simple mysqldump script. Daily, Monday overwrites last Monday's backup. No compression!
# Don't expect any nitty gritty ;)

MYSQL_USER="root"
MYSQL_PASS=""
MYSQL_ARGS="-u$MYSQL_USER -p$MYSQL_PASS --database "
DATABASES=`echo "show databases" | mysql -u$MYSQL_USER -p$MYSQL_PASS |grep -v "Database"`
SUFFIX="`date +%a`.sql"
for DATABASE in $DATABASES; do
	/bin/rm -rf /backups/database_backups/$DATABASE-$SUFFIX.gz  #Remove previous week's backup
	/usr/bin/mysqldump $MYSQL_ARGS $DATABASE | gzip - > /backups/database_backups/$DATABASE-$SUFFIX.gz
done
RETVAL=$?
if [ $RETVAL -eq 0 ]; then
	echo "Databases backed up successfully"
else
	echo "There was an issue with the backups"
fi