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)