let me know if you can suggest any improvement in my code. I think i have too many ECHO.
#! /bin/bash
DATABASE=$1
DATE=$2
MYLOGIN=/home/dbadmin/login_dev.ini
BKUP_FILE=/home/dbadmin/delete
DB_NAME=$DATABASE.sql.gz
DBEXISTS=$(mysql --defaults-extra-file=$MYLOGIN --batch --skip-column-names -e "SHOW DATABASES LIKE '"$DATABASE"';" | grep "$DATABASE" > /dev/null; echo "$?")
if [ $DBEXISTS -eq 0 ];then
clear
echo ".........................................................................."
echo "$DATABASE already exists. Back up and drop $DATABASE before running restore_full_db.sh. Exiting..."
echo ".........................................................................."
echo ""
echo ""
exit
else
if [ -f $BKUP_FILE/$DATE/$DB_NAME ]
then
clear
echo "$DB_NAME decompressed"
echo ".........................................................................."
gzip -d $BKUP_FILE/$DATE/$DB_NAME
echo ""
echo ""
echo ""
echo "$DATABASE created"
echo ".........................................................................."
mysql --defaults-extra-file=$MYLOGIN <<< "create database $DATABASE"
echo ""
echo ""
echo ""
echo "Data restoring in $DATABASE"
echo ".........................................................................."
mysql --defaults-extra-file=$MYLOGIN "$DATABASE" < "$BKUP_FILE/$DATE/$DATABASE.sql"
echo ""
echo ""
echo ""
echo "Data restored. Exit..."
echo ""
echo ""
echo ""
else
echo ".........................................................................."
echo "$DB_NAME file not found. Exiting..."
echo ".........................................................................."
echo ""
echo ""
exit
fi
fi