Not an oracle topic this time. Sorry 😉

This blog is powered by WordPress, and I performed an upgrade to 2.7. and configured some plugins.
Prepared my upgrade, checked this site for example: http://lorelle.wordpress.com/2008/12/11/wordpress-27-upgrade-tips . So far the theory.

Here’s what I actually did:

1. Upgraded all my plugins to the latest version.
2. As a well trained DBA-monkey: took a backup of my blog: files and database.
3. Copied the 2.7 files over the existing files in the directories: home,wp-admin,wp-includes.
Didn’t touch my wp-content directory and my wp-config.php,.htaccess in my home-directory.
4. Logged in as admin, and wordpress detected that my database needed to be upgraded, and it did. In business again! How simple life can be!

In addition:

5. The site looked a little bit different (heading was smaller), then discovered that my theme, Mandigo, had developed a newer release – 1.39 – for wordpress 2.7.
So also upgraded this one in the plugin-directory (a patch).
6. Checking the plugin’s : wp-supercache complains about the rewrite rules (Rewrite rules cannot be updated!”). Thought I didn’t touch this.. On the other hand, didn’t notice it before..
Because of the home-directory of my site is not the root, but a sub-directory /blog, the .htaccess-file needs to be changed.
Nothing to do with the upgrade mostlikely, but it needs te be done anyway…
Here’s how it looks like after the change:

AddType application/x-httpd-php5 .php .php5
# BEGIN WPSuperCache
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
AddDefaultCharset UTF-8
RewriteCond %{REQUEST_METHOD} !=POST
RewriteCond %{QUERY_STRING} !.*=.*
RewriteCond %{HTTP:Cookie} !^.*(comment_author_|wordpress|wp-postpass_).*$
RewriteCond %{HTTP:Accept-Encoding} gzip
RewriteCond %{DOCUMENT_ROOT}/blog/wp-content/cache/supercache/%{HTTP_HOST}/blog/$1/index.html.gz -f
RewriteRule ^(.*) /blog/wp-content/cache/supercache/%{HTTP_HOST}/blog/$1/index.html.gz [L]

RewriteCond %{REQUEST_METHOD} !=POST
RewriteCond %{QUERY_STRING} !.*=.*
RewriteCond %{HTTP:Cookie} !^.*(comment_author_|wordpress|wp-postpass_).*$
RewriteCond %{DOCUMENT_ROOT}/blog/wp-content/cache/supercache/%{HTTP_HOST}/blog/$1/index.html -f
RewriteRule ^(.*) /blog/wp-content/cache/supercache/%{HTTP_HOST}/blog/$1/index.html [L]
</IfModule>
# END WPSuperCache
# BEGIN WordPress
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /blog/index.php [L]
# END WordPress

7. When I’m at home (provider-network problems), I’m not overwhelmed by the performance of the admin-page. Decided to use the ‘Turbo’-button in the upper right corner of the admin area. This feature installs the files of the admin-areay on you p.c.

Quote: “To enable this new feature, click on the “Turbo” link and follow it to Gears’ site to install it in your browser (if not already installed). Then the browser will have to be restarted and after logging back in WordPress, click the “Turbo” link again to give permission to Gears to work on WordPress.com.
After that Gears will download around 200 files and store them on your PC. It will also update them when needed automatically in the background, no other actions are required.”

Indeed, it helps. Still not very fast, but bearable.