Simple Backup Script

backup.sh

#!/bin/bash

# crontab -e
# 10 3 * * * /root/mysql_backups.sh  > ~/backups/status.log
# change DB_USER and DB_PASSWD as per configuration

export DB_BACKUP="~/domains/baks"
export DB_USER="******"
export DB_PASSWD="*****"
export DB_HOST="*****"

echo ""
echo "Backing up all mysql databases"
echo "--------------------------"

echo "* Creating backup..."
mysqldump --user=$DB_USER --password=$DB_PASSWD --all-databases --host=$DB_HOST | bzip2 > ~/data/baks/mysql-`date +%Y-%m`.bz2
echo "----------------------"
echo "Done"
exit 0