MySQL drop all tables from a database

gistfile1.sh

# The following assumes credentials are saved in .my.cnf (or similar)
# 

# Create a file with a drop table command for each table.
# (Replace "database" with the name of the database.)
#
mysqldump --add-drop-table --no-data database | grep 'DROP TABLE' > ~/little_bobby_tables.sql

# Check.
#
cat ~/little_bobby_tables.sql

# Run the commands.
#
mysql database < ~/little_bobby_tables.sql

# Remove that dangerous file!
#
rm ~/little_bobby_tables.sql