#!/bin/bash

# Configuration Options
dbUser="USER_NAME"
dbPass="USER_PASSWORD"

echo "Which database should we clear:"
DATABASES=`mysql -u $dbUser --password=${dbPass} -Bse 'show databases;'`
select siteDb in $DATABASES; do test -n "$siteDb" && break; echo ">>> Invalid Selection"; done

echo "Clearing ${siteDb}..."
mysql --user=$dbUser --password=$dbPass $siteDb -e "show tables" | grep -v Tables_in | grep -v "+" | \gawk '{print "drop table " $1 ";"}' | mysql --user=$dbUser --password=$dbPass $siteDb