Mysql - dropping all tables without dropping the database
This snippet is real handy if you don't have CREATE TABLE and GRANT permissions.
mysql --user=YOUR_USERNAME --password=YOUR_PASSWORD -BNe "show tables" YOUR_DBSCHEMA_NAME | tr '\n' ',' | sed -e 's/,$//' | awk '{print "SET FOREIGN_KEY_CHECKS = 0;DROP TABLE IF EXISTS " $1 ";SET FOREIGN_KEY_CHECKS = 1;"}' | mysql --user=YOUR_USERNAME --password=YOUR_PASSWORD YOUR_DBSCHEMA_NAME
via http://knaddison.com/technology/mysql-drop-all-tables-database-using-single-command-line-command (in the comments) Goodreads Bookshelf
Drupal's Building Blocks: Quickly Building Web Sites with CCK, Views, and Panels
Earl Miles
Drupal 6 JavaScript and jQuery
Matt Butcher
Neuromancer
William Gibson
heh, was going to point you
I was going to point you to two resources, my blog and http://www.thingy-ma-jig.co.uk/blog/10-10-2006/mysql-drop-all-tables but it seems you just got this from my blog already.
Would be nice if you actually linked to it instead of just listing the url without making it a link ;)