Backup script for mysql database to amazon s3 bucket

vim /opt/scripts/MySqlDBBackup.sh

#!/bin/bash

##Introduction part of script which provides you the info your script like date,version,author etc.

#########################################################
# Title            : MySqlDBBackup.sh                                                         #
# Description : Backup MYSQL Database Dump                                    #
# Author        : PRASHANT THORAT                                                      # 

# Date           : 9th July 2016                                                                  #
# Version       : 0.1v                                                                                #
# Usage         : ./MySqlDBBackup.sh                                                     #
########################################################

##Basic variables which we are using further in script

MYSQLHOST="localhost"      ##Add your Mysql Host Name or IP 
MYSQLUSER="user"            ##Username of Mysql who has access to your                                                        database"
MYSQLPASS='password'      ##Password of User

DOC="/data/DbBackup"       ##Provide directory details where to store backup                                                 files
MAIL=$(which mail)           ##This variable store the mail command which is                                                    use to send emails 
MAILTO='emailid'             ##Add your email id for notification on backup                                                         complete or errors"

##Timestamp (sortable AND readable)

TIMESTAMP=`date +"%Y%m%d-%H%M"` ## This variable store the current date and time which we attach further with name of backup file

# This variable store the available database on the server and grep command will give input of default database to tr command and tr command will skip those databases from 
# backup. we do not need default database like information_schema,MySQL etc so we skipped it.

DATABASES=`mysql -h$MYSQLHOST -u$MYSQLUSER -p$MYSQLPASS -e "SHOW DATABASES;" | tr -d "| " | grep -v "(Database|information_schema|mysql|performance_schema)"`

# Below find command search for five days older backup files on the server and delete it. We use this to save storage on the server.

find $DOC/*.sql.gz -mtime +5 -exec rm {} ;

# Here, we execute the for loop because if we have more than one database on the server then for loop will take a dump of first DB, second DB etc save it on the server and also use 
# s3 command to transfer or copy files on s3 bucket.if server faces any issue while take dump or backup of the database you will get the notification email for error message 
# that mail command mention in if statement.

for db in $DATABASES; do

# Define our filenames
FILENAME="$db-$TIMESTAMP.sql.gz"
# Feedback
echo -e "e[1;34m$dbe[00m"

# Dump and zip
echo -e " creating e[0;35m$FILENAMEe[00m"
mysqldump --single-transaction -h$MYSQLHOST -u$MYSQLUSER -p$MYSQLPASS --databases "$db" | gzip -c > "$DOC/$FILENAME"

#s3 upload
echo -e " Uploading db dump on S3 bucket"
s3cmd put $DOC/$FILENAME s3://bucket-name/bucket-directory/

if [ $? -ne 0 ]; then
echo -e "Hi Sysadmin,nnError in Mysql Dump Live Database" | $MAIL -s "Error : Mysql Dump Error. [`echo DB-ERROR | sed 's: :, :g'`]" $MAILTO
exit 1
fi

done;

# This Mail command send you the notification of completion of database backup.

echo -e "Hi Sysadmin,nn Live Database Backups successfully done" | $MAIL -s "Completed : Database Backup Seccessfully Done. [`echo DB-Done | sed 's: :, :g'`]" $MAILTO