Shell script to restore a supplied compressed mySQL backup. Note: update username and password before using.

sql_restore.sh

#!/bin/sh

doContinue=n
echo -n "Do you really want to continue? [y/n] "
read doContinue

if [ "$doContinue" != "y" ]; then
  echo "Quitting..."
	exit
fi

if [ ! -r $1 ]; then #file not found or readable
	echo "File $1 does not exist or is not readable."
	exit
fi

gunzip < $1 | mysql --user=[username] --password=[password]
echo "Databases restored from $1."