#!/bin/bash

BACKUPPATH=/var/mysql_backup/
mkdir -p $BACKUPPATH
if [ $(ls -l $BACKUPPATH*.gz 2>/dev/null | wc -l) -gt 7 ]; then
        OLD=$(find $BACKUPPATH -type f -name '*.gz' -printf '%T+ %pn' | sort | head -n 1 | awk '{print $2}')
        rm $OLD # Removing oldest compressed archive
        logger -p local3.info -t mysql_backup "Removing oldest compressed .gz"
fi

if [ $(ls -l $BACKUPPATH*.sql 2>/dev/null | wc -l) -eq 1 ]; then
        LATESTLOG=$(find $BACKUPPATH -type f -name '*.sql' -printf '%pn' | head -n 1)
        gzip $LATESTLOG
        logger -p local3.info -t mysql_backup "Compressing most recent .sql file"
fi

/usr/bin/mysqldump -u db_user -p'password' --single-transaction  --all-databases > $BACKUPPATH$(date "+%Y.%m.%d-%H.%M.%S")_dump.sql