#!/bin/bash

# Shell script to backup MySql database

# Author: Henry he

# Last updated: --

# crontab -e

#   * *  /home/elkan/H_Docs/PortMasterListPortal/backup.sh >> /opt/mysql_backup/log

echo $(date +"%Y-%m-%d %H:%M:%S")

username="root"     # USERNAME

password=""       # PASSWORD

Hostname="localhost"          # Hostname

DBName="PortMasterList" #DB name

#DBName="testMavenWeb"

programProt=""

#max save backup file number

maxBackUpFileCount=

# Linux bin paths, change this if it can not be autodetected via which command

MYSQL="$(which mysql)"

MYSQLDUMP="$(which mysqldump)"

CHOWN="$(which chown)"

CHMOD="$(which chmod)"

GZIP="$(which gzip)"

# Main directory where backup will be stored

backupDir="/opt/mysql_backup/"$DBName

# if not exsis then mkdir

[ ! -d $backupDir ] && mkdir -p $backupDir || :

# Get data in dd-mm-yyyy format

NOW="$(date +"%Y-%m-%d-%H-%M-%S")"

FILE="$backupDir/$DBName.$NOW.bak"

# Only root can access it!

#$CHOWN 0.0 -R $backupDir

#$CHMOD  $backupDir

# connect to mysql using mysqldump for select mysql database

# and pipe it out to file in backup dir

echo 'usenrame:'$username 'password:'$password 'DBName:'$DBName

$MYSQLDUMP -u $username -h $Hostname -p$password $DBName > $FILE

# check the backup is success

success="true"

if [ ! -s "$FILE" ]; then

    success="false"

    rm -f $FILE

    echo 'backup fail'

else

    # delete the redundant backup files

    i=

    for file in $(ls -t $backupDir)

    do

        i=`expr $i + `

        #echo $file

        if [ "$i" -gt "$maxBackUpFileCount" ]

        then

            $(rm -f "$backupDir/$file")

            echo 'rm file':"$backupDir/$file"

        fi

    done

    echo 'backup success file path:'$FILE

fi

#curl calling java to send email

curl 'http://'$Hostname':'$programProt'/PortMasterListPortal/ajax/sendBackup.html?success='$success'&secureKey=xxx'

echo ''