#!/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"

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

 done

 trace "qnd-mysql-backup done"

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