#!/bin/bash
prefix=mysql
suffix=$(date +%F).sql
filename=$prefix.$suffix
mysqldump --opt -uroot -pxxx --all-databases > /backup/mysql/$filename

cd /backup/mysql
tar -cvf $filename.tar $filename
gzip $filename.tar
chown root:root /backup/mysql/$filename.tar.gz
chmod 600 /backup/mysql/$filename.tar.gz

rm $filename

#SUBJECT="MySQL Dump completed"
#EMAIL="my@email.com"
#EMAILMESSAGE="$filename created"
#echo $EMAILMESSAGE | /bin/mail -s "$SUBJECT" "$EMAIL"