the just installed state. This would include DROP TABLEs, caches, cookies, etc. I don't have root access and am left with files owned by apache so
I use a simple one-liner for deleting the Drupal database: mysql drupal -e "SHOW TABLES" | awk '{print "DROP TABLE "$1";"}' | tail +2 | mysql drupal That prints out every table in the "drupal" database, adds a "DROP TABLE" prefix, and then pipes it back into MySQL. After that, it's just a simple matter of "mysql drupal < database/database.mysql", and I'm back to square one, WITHOUT having to reset MySQL authentication (or the settings.php). It's worked well enough in everyday usage. -- Morbus Iff ( united we're bland ) Technical: http://www.oreillynet.com/pub/au/779 Culture: http://www.disobey.com/ and http://www.gamegrene.com/ icq: 2927491 / aim: akaMorbus / yahoo: morbus_iff / jabber.org: morbus