#!/bin/bash

LOGFILE=/mnt/usb/backupDB.txt

    echo >>$LOGFILE
    echo "=================================================" >>$LOGFILE
    echo "$(date +'%d-%b-%Y %R')" >>$LOGFILE
    echo "BackUp DataBase started" >>$LOGFILE

/etc/init.d/d3srv stop
/etc/init.d/e3srv stop

    echo "-d3srv is stopped" >>$LOGFILE
    echo "-e3srv is stopped" >>$LOGFILE
    echo "-d-sh is stopped" >>$LOGFILE

mysqldump --defaults-extra-file=/home/backup_scripts/root.cfg dozor --ignore-table=dozor.addr --ignore-table=dozor.addr_type | sed '20a\use `dozor`\' | gzip -c > /home/backup-scripts/`date +%y%m%d`.sql.gz

/etc/init.d/d3srv start
/etc/init.d/e3srv start
/etc/init.d/d-sh start

    echo "-d3srv started" >>$LOGFILE
    echo "-3esrv started" >>$LOGFILE
    echo "-d-sh started" >>$LOGFILE

STATUS=$?

    echo "BackUp DataBase saved as `date "+%y%m%d.sql.gz"`" >>$LOGFILE
    echo "Started copying the file to the backup resource" >>$LOGFILE

cp -f /home/backup_scripts/`date +%y%m%d`.sql.gz /mnt/usb/ &>>$LOGFILE

    if [[ $? != 0 ]]; then
        echo "#############################################################" >>$LOGFILE
        echo "### An error occurred while copying to the backup resource###" >>$LOGFILE
        echo "#############################################################" >>$LOGFILE
        else
            echo "The file was successfully copied" >>$LOGFILE
            echo "All operations completed successfully!" >>$LOGFILE

    fi

    echo "Unmounting the file system" >>$LOGFILE
rm -r /home/backup_scripts/*.sql.gz
umount /mnt/usb