Converting a Mini to a Server, Part 6: WordPress

I downloaded the latest version of WordPress, 2.0.2, and copied it over the old version. It started up fine, but couldn’t connect to the database server. No surprise. I haven’t imported my old database tables yet.

After setting up the database and importing the old database data, the site seemed to work. However, on further investigation all the links went to the old site (cafe.elharo.com) and not to the new site (minicafe.elharo.com). That’s weird. On top of that, the equivalent URLs at the new site were 404. Hmm, there’s probably something in the database that points to the old URL. Yep, that’s it all right. Seems I have to edit the SQL directly before importing it in the new server. Bleah.

OK. Now the URLs on the home page are correct, but none of the links work. It’s probably a .htaccess issue. Yep. It’s deifnitely a permalink issue. I can get to the posts using the actual query string URLs like http://minicafe.elharo.com/?p=123. I’ve set up the .htaccess file. Maybe the server hasn’t turned on mod_rewrite?

Ah. Found it. The problem is I was turning on mod_rewrite in the .htaccess but the virtual host didn’t set OverrideAll like so:

    <Directory /var/www/cafe>
      Options INCLUDES
      AllowOverride All
    </Directory>

This is now done and the links seem to work. Good. Let’s try posting a test article and comment and see if that works. Yep. It works. Good.

OK. The final step is going to be moving this very site (Mokka mit Schlag) over to the new system. I’m not going to blog that experience in real time. It may be trickier because I’ll also need to upgrade the WordPress database from 1.5 to 2.0 in the process. I think I’m now going to lock this site so it’s read-only until the transition is done. See you on the other side!

Leave a Reply