database_backup.sh

To take a daily backup of daily dumped databases

#!/bin/bash -e
LOG_FILE='/home/pi/databases_backup.log'
DIRECTORY='/home/database_backup/'
SOURCE='/media/pi/databases_backup/'
DESTINATION='/media/pi/5318-1E6A/Databases_backup'
TRD_MACHINE='/media/pi/TRD_machine/home/database_backup'
BROKER='bubuoat.mine.nu'
TOPIC='rsync'
MAX_LOG_SIZE=100000
# check whether the log file size is exceeding the limit defined by MAX_LOG_SIZE above
if [[ -s $LOG_FILE ]]; then
log_size=$(wc -c $LOG_FILE | awk '{print $1}')
	if [ $log_size -gt $MAX_LOG_SIZE ]
		then
		# remove the file
		rm $LOG_FILE
	fi
else
echo "Initializing the Log File" >> $LOG_FILE
fi

date=`/bin/date "+%Y-%m-%d"`
echo "################################################" >> $LOG_FILE
echo "Synchronization started - $date" >> $LOG_FILE
        echo "Synchronizing from $SOURCE to $DESTINATION" >> $LOG_FILE
        rsync -avzh -i --stats  $SOURCE $DESTINATION > /dev/null
        if [ $? -eq 0 ]; then
                echo "Success at synchronizing Database Backup on $SOURCE with Database Backup on $DESTINATION" >> $LOG_FILE
        else
                echo "There was a problem while synchronizing $SOURCE with $DESTINATION" >> $LOG_FILE
                curl -s \
                  --form-string "token=aeuca87bjjuqknkwswm9bpvy1ygngo" \
                  --form-string "user=u6ysovfgq1nhysszxzh91qnwadch2y" \
                  --form-string "title=Sync issue on RaspberryPi"\
                  --form-string "message=Problem with Synchronizing Databases Backup" \
                  https://api.pushover.net/1/messages.json
        fi
        echo "Synchronizing from $SOURCE to $TRD_MACHINE" >> $LOG_FILE
        sudo rsync -avzh -i --stats  $SOURCE $TRD_MACHINE > /dev/null
        if [ $? -eq 0 ]; then
                echo "Success at synchronizing Database Backup on $SOURCE with Database Backup on $TRD_MACHINE" >> $LOG_FILE
        else
                echo "There was a problem while synchronizing $SOURCE with $TRD_MACHINE" >> $LOG_FILE
                curl -s \
                  --form-string "token=aeuca87bjjuqknkwswm9bpvy1ygngo" \
                  --form-string "user=u6ysovfgq1nhysszxzh91qnwadch2y" \
                  --form-string "title=Sync issue on RaspberryPi"\
                  --form-string "message=Problem with Synchronizing Databases Backup" \
                  https://api.pushover.net/1/messages.json
        fi
echo "################################################" >> $LOG_FILE
echo "" >> $LOG_FILE
exit