#!/bin/sh
#---+> MySQL Backup Script by isok@korea.cnet.com 2003. 11. 22
<+-----------

wd=/var/server/backup/
user=mysqluser
passwd=mysqlpass
preserve="2 days ago"

sqlexec() {
    result=$($sql "$query")
}

date=$(date +%Y.%m.%d-%H%M%S)
dir=$(date +%Y.%m.%d)
last=$(date +%Y.%m.%d --date "$preserve")

sql=$(which mysql)" -u$user -p$passwd -s -e"
sqldump=$(which mysqldump)" -u$user -p$passwd"


query="show databases"
sqlexec

[ ! -d $wd/$dir ] && mkdir $wd/$dir

for db in $result
do
    $sqldump $db >$wd/$dir/$db-$date.sql
done
[ -d $wd/$last ] && rm -rf $wd/$last