#!/bin/bash
mkdir /mnt/usb
mount /dev/sdb1 /mnt/usb

    echo >> /mnt/usb/backupDB.txt
    echo "=================================================" >>/mnt/usb/backupDB.txt
    echo "$(date +'%d-%b-%Y %R')" >>/mnt/usb/backupDB.txt
    echo "Import DataBase started" >> /mnt/usb/backupDB.txt

gunzip /mnt/usb/*.sql.gz

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

    echo "-d3srv stoped" >>/mnt/usb/backupDB.txt
    echo "-3esrv stoped" >>/mnt/usb/backupDB.txt
    echo "-d-sh stoped" >>/mnt/usb/backupDB.txt

mysql --defaults-extra-file=/home/backup_scripts/root.cfg < /mnt/usb/*.sql

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

    echo "-d3srv started" >>/mnt/usb/backupDB.txt
    echo "-3esrv started" >>/mnt/usb/backupDB.txt
    echo "-d-sh started" >>/mnt/usb/backupDB.txt
    echo "All operation completed successfully!" >>/mnt/usb/backupDB.txt

rm -r /mnt/usb/*.sql
umount /dev/sdb1