Sometimes, you just want to start with a clean slate

clean-slate.sh

#! /bin/bash
# Drop the existing content of a database and replace it with a backup

DBUSER="root"
DBPASS="root"
DBNAME="INSERT-DB-NAME"
IMPORTFILE="$DBNAME.sql"

echo ".........................................."
echo -e " Enter the name of the DB backup (with extension): \c"
read IMPORTFILE

if [ -z "$IMPORTFILE" ]
then
	IMPORTFILE="$DBNAME.sql"
	echo ".........................................."
	echo " *** No DB file entered, defaulting to $IMPORTFILE"
fi

echo ".........................................."
echo " Dropping the $DBNAME database"

CMD="DROP DATABASE $DBNAME;"
mysql -u "$DBUSER" -p"$DBPASS" -e "$CMD"

echo ".........................................."
echo " Creating empty $DBNAME database  "

CMD="CREATE DATABASE $DBNAME;"
mysql -u "$DBUSER" -p"$DBPASS" -e "$CMD"

echo ".........................................."
echo " Importing $IMPORTFILE into $DBNAME "

mysql -u "$DBUSER" -p"$DBPASS" "$DBNAME" < "$IMPORTFILE"

echo ".........................................."
echo " $DBNAME is now a clean slate "
echo ".........................................."

dump-db.sh

#! /bin/bash
# Drop the existing content of a database and replace it with a backup

DBUSER="root"
DBPASS="root"
DBNAME="INSERT-DB-NAME"
EXPORTFILE="$DBNAME.sql"

echo ".........................................."
echo -e " Enter the name of the DB backup file (with extension): \c"
read EXPORTFILE

if [ -z "$EXPORTFILE" ]
then
	EXPORTFILE="$DBNAME.sql"
	echo ".........................................."
	echo " *** No DB file entered, defaulting to $EXPORTFILE"
fi

echo ".........................................."
echo " Dumping the $DBNAME database"

mysqldump -u "$DBUSER" -p"$DBPASS" "$DBNAME" > "$EXPORTFILE" 

echo ".........................................."
echo " $DBNAME has been dumped to $EXPORTFILE "
echo ".........................................."