Drop all tables from mysql database

dropAllTables.sh

#!/bin/bash
#Default settings
username="root"
dbname="db"
host="localhost"

while getopts ":u:d:h:" opt; do
	case "$opt" in
		u) username=$OPTARG;;
		d) dbname=$OPTARG;;
		h) host=$OPTARG;;
		\?) echo "Invalid option: -$OPTARG" >&2
            exit 2;;
	esac
done


echo "SET foreign_key_checks = 0;" > drop.sql
mysqldump -u $username -p --no-data $dbname -h $host | grep ^DROP >> drop.sql
echo "SET foreign_key_checks = 1;" >> drop.sql
mysql -u $username -p $dbname -h $host < drop.sql
rm drop.sql

Usage:

./dropAllTables.sh -u username -d databaseName -h hostname

Without additional parameters it will use default values

Varible	Value
username	root
dbname	db
host	localhost