mysql dump database with specific database [folder name].

db-backup.sh

#!/bin/bash

# colors
GREEN='\033[0;32m'
NC='\033[0m' # No Color

# dbDump functions
dbDump() {
# backup location
LOCATION=~/dumps/

# create dir if not exists
if [ ! -d $LOCATION ]
then
   mkdir $LOCATION
fi

# for dumping multiple databases
for d in $@
do
   mkdir -p $LOCATION$d;
   FINAL_LOCATION=$LOCATION$d/;
   mysqldump -u root -p$mysql_pswd $d|gzip > $FINAL_LOCATION$(date +%Y%m%d'_'%H:%M).sql.gz
   echo -e "Mysql Database ${GREEN}$d${NC} dumped."
done
}

# get db names for the dump
databaseDumpProcess() {
    read -p "Enter database name{s} for dumping [multiple names with spaces]:" db_names
    dbDump $db_names
}

# checks if mysql password matched
checkMysqlPasswordMatched() {
    until mysql -u root -p$mysql_pswd -e ";" ; do
       read -s -p "Can't connect, please retry: " mysql_pswd
done
}


### Input mysql password as hidden characters ### 
read -s -p "Enter Mysql Password: "  mysql_pswd
checkMysqlPasswordMatched

    printf "%s\n"
    read -p "Do you want to list the databases before dumping [y]?" yn
        case $yn in
        [Yy]* )
        mysql -u root -p$mysql_pswd -e 'show databases';
        databaseDumpProcess
        exit;;
       [Nn]* )
        databaseDumpProcess
        exit;;

       * ) mysql -u root -p$mysql_pswd -e 'show databases';
        databaseDumpProcess
        exit;;
    esac