DATABASES=$(echo "SHOW DATABASES" | sql | clean)

for db in ${DATABASES}
do
        [ -d "$CWD/$db" ] || mkdir -p "$CWD/$db"

        TABLES=$(echo "SHOW TABLES" | sql $db | clean)
        for table in ${TABLES}
        do
                FILE="$CWD/$db/$table".gz
                if was_table_modified $FILE $db $table
                then
                        mysqldump --opt $db $table | gzip > "$FILE".new
                        if [ ! -f "$FILE" ] || ! cmp -s "$FILE" "$FILE".new
                        then
                                mv "$FILE".new "$FILE"
                        else
                                rm -f "$FILE".new
                        fi
                fi
        done
done

#!/bin/sh

# Directory to store backups in
DST=/data/spool/dbback
# A regex, passed to egrep -v, for which databases to ignore
IGNREG='^snort$'
# The MySQL username and password
DBUSER=root
DBPASS=password
# Any backups older than this will be deleted first
KEEPDAYS=7

DATE=$(date  +%Y-%m-%d)

cd /var/lib/mysql

find ${DST} -type f -mtime +${KEEPDAYS} -exec rm -f {} \;
rmdir $DST/* 2>/dev/null

mkdir -p ${DST}/${DATE}
for db in $(echo 'show databases;' | mysql -s -u ${DBUSER} -p${DBPASS} | egrep -v ${IGNREG}) ; do
        echo -n "Backing up ${db}... "
        mysqldump --opt -u ${DBUSER} -p${DBPASS} $db | gzip -c > ${DST}/${DATE}/${db}.txt.gz
        echo "Done."
done

exit 0

DBLIST=$(echo 'show schemas' | mysql $PARAMS \
| egrep -v '^mysql$|^information_schema$|^Database$')
for db in $DBLIST; do
    mysqldump $PARAMS $db | gzip -9 > DBs/$db.sql.gz
done