#!/bin/sh
#
# mysql-incremental.sh v1.1
# TiChou <tichou@tichou.org>

BACKUPDIR="/data/backup"
USER="root"
PASS="foobar"

DAY="`date +%w`"
HOST="`hostname`"

umask 037

# mysql / log-bin in my.cnf
BINLOG="/var/lib/mysql/`tail -n 1 /var/lib/mysql/$HOST-bin.index`"
echo 'FLUSH LOGS;' | mysql --user="$USER" --password="$PASS" --socket=/var/run/mysqld/mysqld.sock
ARCHIVE="$BACKUPDIR/archives/sql-inc-day-$DAY.gz"
chattr -i "$ARCHIVE"{,.md5}
gzip -c9 "$BINLOG" > "$ARCHIVE"
md5sum "$ARCHIVE" > "$ARCHIVE.md5"
chattr +i "$ARCHIVE"{,.md5}