#!/bin/bash

# This is where the backup gets emailed too
BACKUPMAIL=test@gmail.com
DATE=`date`
DATABASEUSER=root
DATABASEPASS=secret
DATABASENAME=test

PREFIX=topup_
NOW="$(date +"%d-%m-%Y")"

PATH=/usr/home/freebsd/backup/mysql/
cd ${PATH}

#dump DB
/usr/local/bin/mysqldump --opt -u${DATABASEUSER} -p${DATABASEPASS} ${DATABASENAME} > ${DATABASENAME}.sql

# Archive for storage purpose
/usr/bin/tar -zcvf ${PREFIX}${NOW}.tgz *.sql

# Zip send to me
/usr/bin/gzip -c ${DATABASENAME}.sql | /usr/bin/uuencode ${DATABASENAME}.sql.gz  | /usr/bin/mail -s "MySQL DB ${DATABASENAME} for $DATE" ${BACKUPMAIL}

#Remove SQL files
/bin/rm /usr/home/freebsd/backup/mysql/*.sql

# Delete files older than 30 days
/usr/bin/find ${PATH}* -mtime +30 -exec /bin/rm {} \;