Running a Drupal site locally under Windows XP

There are many reasons for running a copy of a Drupal website on a local machine among them backup, offline development or more likely a perverse desire to show that it can be done. The perversity is hightened by doing this on a Windows machine, in this case Windows XP. This case study is based on the real world user "varley" and the site "". You may get your case to work with appropriate substitions.

Drupal vs. Dreamweaver

Rather inadequately, I have explained the difference between a CMS website and a conventional website as a matter of who contributes content, a CMS encourages wider participation in the website creation process. But that understates the significance of collaboration and networking. For example one site featured at the recent DrupalCon in DC was OAN. It is just difficult to imagine Dreamweaver in the driver's seat.

Implementing php5-xcache

Of the three "free" php opcode caching schemes APC, eAccelerator and Xcache, the latter had an installable package and appeared simplest to implement. I tried it on my local workstation first (always a good idea) and it came up with little difficulty.

apt-get install php5-xcache

Now generate the password.

echo -n "my_password" | md5sum -

Modify the username and password in /etc/php5/apache2/conf.d/xcache.ini

Hang the web code someplace easy to get at.

Tuning MySQL query_cache

An appropriate amount of "query_cache" is believed to improve MySQL performance at the expense of available memory. "Appropriate" will vary widely with usage and "performance" on a live site can be elusive. On Ubuntu, the defaults are modest but "work".

# * Query Cache Configuration
query_cache_limit       = 1M
query_cache_size        = 16M

Drupal 5.x provides a summary at "admin/logs/status/sql" and 6.x at "admin/reports/status/sql".

Kompozer+Prince+Boom = Book!

People who want a well-reasoned blog should write their own or look elsewhere. Sometimes I stumble across a process or practice that seems to work fairly well yet might not be obvious to the average reader. One such process is producing a book.

CSS - once more with feeling

We all know CSS is a pit. Things which soar in one browser, crash in another. There is a reason for that. provides a neat list of things you probably don't know about CSS and browser developers don't either. I've been in pursuit of a CSS mechanism for printing and one of the things you would want for that purpose is @page. For some reason, "The size of a page box cannot be specified in CSS 2.1.". If anybody discovers the wisdom behind that, please clue me in.

Drupal Meetup: Theming Tutorial

2009-01-06 18:30
America/New York
Jan 6 Tue 6:30 PM

Web Developer 1.1.6

A useful Firefox extension for exploring code generated by a CMS (Content Management System).

Web Developer can be downloaded from and installed by dragging the "xpi" file onto a Firefox window. Once installed, extensions must be enabled, sometimes configured and finally invoked with a restart or two in between. Web Developer is accessed through a Tool bar between the Bookmarks tool bar and "tabs" and the Menu item "Tools".

Independence Drupal Camp Winter 2009

2009-01-02 10:00
2009-01-04 15:00
America/New York

Three day workshop for Drupal website owners. Base camp is at 61 Caprine Ln, Independence, VA 24348. Advanced camp is at 115 1/2 W Grayson St, Galax VA. Attendees will set up a WAMP sandbox on their laptops, install Drupal, FCKEditor, contributed modules, explore content creation and HTML, theme customization and CSS, scripting with PHP, perform version updates, backups and other issues as time permits. Scope is comparable to "Building powerful and robust websites with Drupal 6" by David Mercer.

Syndicate content