Restore a MYSQL database using raw .sql or gzipped .sql.gz file

myrestore

MYSQL="$(which mysql)";
GUNZIP="$(which gunzip)";

## Usage
if [ $1 == "help" ];then
	echo "usage myrestore [DBNAME] [filename.sql|filename.sql.gz]"
	echo "myrestore MYDB mydb.12345.sql.gz";
	exit 0;
fi

## MAIN
if [ ! $2 ];then
	read -e -i "" -p "Enter Database Name : " DBN;
	read -e -i "" -p "Enter sql filename : " FN;
else
	DBN="$1";
	FN="$2";
fi

## Check if sql file exists
if [ ! -f "$FN" ];then
	echo "$FN does not exist in this folder."
	exit 1;
fi

## Check if file is gzipped
if [[ "$FN" == *.gz ]];then
	ZIP="1";
fi

## Get password
read -e -i "" -p "Enter mysql root password : " PWD;

## Check if Database Exists.
EXISTS=$($MYSQL -u root -p$PWD -e "SHOW DATABASES LIKE '$DBN';")
if [ "$EXISTS" ];then
	echo "Database $DBN Already Exists.";
	exit 0;
else
	## Restore Database
	echo "Restoring Database $DBN...";
	OK=$($MYSQL -u root -p$PWD -e "CREATE DATABASE $DBN;");
	echo "$OK";
	# exit 0;
	if [ "$ZIP" ];then
		OK=$($GUNZIP < $FN | $MYSQL -u root -p$PWD $DBN);
	else
		OK=$($MYSQL -u root -p$PWD $DBN);
	fi
	
	## Check if All is OK (no output)
	if [ "$OK"];then
    echo "$OK";
    echo "$DBN Restore FAILED.";
  else
    echo "$DBN Successfully Restored.";
  fi
fi