Friday, March 09, 2007

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:

1 comment:

Coralgraph said...

I appreciate it very much, at least I know from it someone is reading the contents I have here
Continuous Ink Systems