Geoff Hankerson

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)

To listen to his voice one more time, follow these links:

• 90 memories at 90 (part I)
• 90 memories at 90 (part II) (Video)
• the Christmas story
• Marshall Reminiscing Part I, Part II, Part III
• Photo Gallery Page I , Page II , Page III

What do the Obama Administration, Duke University, Rutgers University, The Economist Magazine, the United Nations, Sony and Warner Brothers have in common? They are all using the Drupal Content Management System

Benjamin Doherty at Drupalcamp Chicago 12/29/2009