#!/bin/bash# Shell script to backup MySql database# Author: Henry he# Last updated: 2014-08-25# crontab -e# 0 8 * * 1 /home/elkan/H_Docs/PortMasterListPortal/backup.sh >> /opt/mysql_backup/logecho $(date +"%Y-%m-%d %H:%M:%S")username="root"     # USERNAMEpassword="123456"       # PASSWORD Hostname="localhost"          # HostnameDBName="PortMasterList" #DB name#DBName="testMavenWeb"programProt="8080"#max save backup file numbermaxBackUpFileCount=5# Linux bin paths, change this if it can not be autodetected via which commandMYSQL="$(which mysql)"MYSQLDUMP="$(which mysqldump)"CHOWN="$(which chown)"CHMOD="$(which chmod)"GZIP="$(which gzip)"# Main directory where backup will be storedbackupDir="/opt/mysql_backup/"$DBName# if not exsis then mkdir[ ! -d $backupDir ] && mkdir -p $backupDir || :# Get data in dd-mm-yyyy formatNOW="$(date +"%Y-%m-%d-%H-%M-%S")"FILE="$backupDir/$DBName.$NOW.bak"# Only root can access it!#$CHOWN 0.0 -R $backupDir#$CHMOD 0600 $backupDir# connect to mysql using mysqldump for select mysql database# and pipe it out to file in backup direcho ‘usenrame:‘$username ‘password:‘$password ‘DBName:‘$DBName$MYSQLDUMP -u $username -h $Hostname -p$password $DBName > $FILE# check the backup is successsuccess="true"if [ ! -s "$FILE" ]; then     success="false"    rm -f $FILE    echo ‘backup fail‘else    # delete the redundant backup files    i=0    for file in $(ls -t $backupDir)    do        i=`expr $i + 1`        #echo $file        if [ "$i" -gt "$maxBackUpFileCount" ]        then            $(rm -f "$backupDir/$file")            echo ‘rm file‘:"$backupDir/$file"        fi    done    echo ‘backup success file path:‘$FILEfi#curl calling java to send emailcurl ‘http://‘$Hostname‘:‘$programProt‘/PortMasterListPortal/ajax/sendBackup.html?success=‘$success‘&secureKey=xxx‘echo ‘‘