#!/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” … Continue reading