#!/bin/sh

# A quick and dirty mysql backup tool

# date +%Y-%m-%d_%H:%M:%S

LOG_FILE="/var/log/qnd-mysql-backup.log"

trace () {

    stamp=`date +%Y-%m-%d_%H:%M:%S`

    echo "$stamp: $*" >> $LOG_FILE

}

ALL_DBS=$(cat <<EOF

list

of

databases

EOF

)

DEST_DIR="/path/to/backups/"

trace "qnd-mysql-backup started"

for a in $ALL_DBS

do

    trace "Working database: $a"

    trace "Clearing old backup"

    rm -vfr $DEST_DIR/$a >> $LOG_FILE 2>&1

    trace "Running backup"

    mysqlhotcopy $a $DEST_DIR >> $LOG_FILE 2>&1

done

trace "qnd-mysql-backup done"

trace "---------------------"