To my embarrassment, I had not known that 4.0 had been released.

In preparation for incorporating an OpenID module into Xoops, which runs this site, I was trying to bring everything up to date. As I watched the output scroll by while running an automatic upgrade with aptitude, I suddenly thought:

“Ah! MySQL has become 5.0…”

What a shock.

Everything other than MySQL upgraded smoothly, but MySQL failed, perhaps because settings for debian-sys-maint and similar items were not properly configured. The database had been inherited from RedHat…

In the end, I had to do everything manually… although all I actually did was run mysql_upgrade and Repair Table. Still, it took some effort.

I should seriously set up a development machine first… How many months has it been since the development machine died…?

Related posts

Still Wrestling with MySQL 5…

But after upgrading to MySQL 5, character sets and collations are difficult. ALTER TABLE hoge CONVERT TO charset utf8 I thought that would work, but it…

2007-05-06

JanRain PHP OpenID Library Upgrade

I upgraded JanRain's OpenID Library from 1.2.3 to the release issued on 2007-11-16, Version 2.0.0-rc5. Various things have changed, but I fixed most of them. One…

OpenID · 2007-11-24