#!/bin/sh

xdbhost=127.0.0.1
xdbuser=bonap
xdbpass=veselI#21*02
xdbname=bonap
# -------------------------

xtmp=/opt/db-backup
# max age in days for backup, delete older
xmaxage=60
# ------------------------

xname=backup-$(date '+%Y%m%d-%H%M%S')
# ------------------------

mysqlcheck -a $xdbname -h $xdbhost -u $xdbuser -p$xdbpass
mkdir -p $xtmp
echo Changing dir to $xtmp ...
cd $xtmp
echo "Deleting older backups (maxage: $xmaxage) ..."
find . -mtime +$xmaxage | xargs rm -Rf
#find . -mmin +$xmaxage | xargs rm -Rf
echo Dumping data to $xname.sql ...
mysqldump --quick --ignore-table=bonap.newver --routines -h $xdbhost -u $xdbuser -p$xdbpass $xdbname > $xname.sql
echo Taring data to $xname.sql.tgz ...
tar czvf $xname.sql.tgz $xname.sql
rm $xname.sql

echo Done.