reinstalling drupal, preparing for live & dev sites

Ok, I'm archiving my current dev install of drupal (which is bloated with modules, some of which have altered the mysql database) and starting with new install of 5.1. Once I have just the right constellation of modules locally, I'll copy them over to our live site (parts.mit.edu/igem07). Here are the mysql commands I used to reset the database for my new drupal install:

• mysqldump -u username -p --databases drupal >/tmp/drupal.sql
• drop database drupal;
• create database igem2007;
• GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
  ON igem2007.*
  TO 'drupal'@'localhost' IDENTIFIED BY 'foopass';

Then I grabbed drupal 5.1 and followed the install instructions to unpack the files and move them into my webserver's base directory. So, from the terminal:

• cd /Library/WebServer/Documents
  
• rm -rv *
• curl -LO http://drupal.org/files/projects/drupal-5.1.tar.gz
• tar -xzvf drupal-5.1.tar.gz
• mv drupal-5.1/* drupal-5.1/.htaccess ./
• rmdir drupal-5.1
• chmod 777 ./sites/default/settings.php
  - this part isn't actually mentioned in the install.txt; see my earlier post
• visit the drupal site root via web browser and supply database info
• chmod 644 ./sites/default/settings.php
  
• mkdir files
• sudo chown www:admin files
• sudo chmod 755 files
  

That's it! Drupal 5.1 has been restored to virginal status. I'll post the modules I decided on and the configuration details next.

References:

• MySQL:
• a handy list of MySQL commands (pantz.org)
• MySQL Usernames and Passwords
• MySQL config instructions for drupal
• Downloading files with curl (ONlamp.com)
• Using tar to archive (cs.duke.edu)