The update cannot be installed because WordPress 2.9 requires MySQL version 4.1.2 or higher. You are running version 4.0.27.
Above is the error message received when I tried to upgrade to 2009 on one of my sites.
Sent ‘Support’ a message and will update with their reply and solution when I receive it.
Update: So it turns out you have to backup your database, create a new one using MySQL 5, then restore the backup to that new database.
Thereafter you get into your wp-config file and change the requisite areas (database name, etc)
Recent Comments