[mysql] Drop all tables in database without recreating it



Use the following tip to drop all tables in a database:

mysqldump -uusername -ppassword -hhost \
--add-drop-table --no-data database | grep ^DROP | \
mysql -uusername -ppassword -hhost database

Much easier than have to drop a database, recreate it, and then grant privileges again.