Drupal

Audio from Drupalcon SF: Advanced Drush

You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialise correctly.

Audio from Drupalcon SF: Aegir Hosting System - one Drupal to rule them all

You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialise correctly.

Audio from Facebook Applications, Powered by Drupal

You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialise correctly.

Apache Solr Search Mastery - Drupalcon SF Session

You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialise correctly.

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)