mysql -u $user -p$pass -h $dbhost $db -e “show tables” | grep -v Tables_in | grep -v “+” | awk ‘{print “drop table ” $1 “;”}’ | mysql -u $user -p$pass -h $dbhost $db