mysql_backup.sh

#!/bin/bash
# Backup mysql databases nightly
# Scott B.
# 6/2/2013

# Create a current date string
DATE=`date +%Y.%m.%d-%H.%M.%S`
BACKUP_DIR=/mnt/CHD_DB_BACKUP/
BACKUP_FILE=$BACKUP_DIR$DATE"_Mysql44_databases.sql"

echo "------------- MySQL Backup Starting on " $DATE " -------------"

# Back up all databases to one file
#mysqldump --single-transaction --all-databases --add-drop-database > $BACKUP_FILE
mysqldump --single-transaction --all-databases --add-drop-database | bzip2 -c > $BACKUP_FILE

END_DATE=`date +%Y.%m.%d-%H.%M.%S`
echo "------------- MySQL Backup Complete at " $END_DATE " -------------"

COMP_DATE=`date +%Y.%m.%d-%H.%M.%S`
echo "------------- MySQL Compression Starting on " $COMP_DATE " -------------"
# Compress previous backup(s) - Do not compress tonight's backup (18 hours old)
# It is needed for staging refresh (until staging moves to PNAP)
#find $BACKUP_DIR -type f -mmin +1080 -exec bzip2 {} \;

# Clean up the backup space - keep 5 days of backups
find $BACKUP_DIR -type f -mtime +5 -exec rm -f {} \;

COMP_END_DATE=`date +%Y.%m.%d-%H.%M.%S`
echo "------------- MySQL Compression Complete at " $COMP_END_DATE " -------------"