A few days ago I upgraded the my blog from WordPress 2.8.5 to 2.9. Here are some tips on what I did in case you run into any of the same issues that I did. That blog is hosted by 1and1 and some of the information may be specific to them.
This isn’t meant as a full upgrade guide – just a collection of tips that may help you.
First make sure you backup your data! There are some general wordpress backup tips on a post I did about a previous upgrade.
1. Export the SQL database
In the MySQL admin panel I selected these extra options: ‘Add DROP TABLE’ and ‘Complete inserts’, and then chose to save the file as a .gz (gzip) archive. If you need a free application to read .gz archives then I recommend 7-Zip.
2. Export the XML data
Export the XML post data from the WordPress admin panel (Tools->Export).
3. Zip and downloaded the blog files
Zip up the actual files on the server. On 1and1 the easiest way to do this is to logon to your admin panel, go to the Webspace Explorer, right-click on the directory and select ‘zip’.
You can then right-click on the zip file and choose download to copy it down to your computer.
4. Verify the data
I verified that the exported SQL data, XLM and .zip files were valid. The easiest way to verify the SQL and XLM data is to look at it in a text viewer such as NoteTab Light and make sure that the data at the end of the file is valid. Sometime a download can silently fail and you can end up with truncated data. If you try to restore the data from a truncated file then the restore will fail.
Verify the .gz file by making sure it will open in 7-Zip.
Click on the upgrade button
I finally was ready to click on the upgrade button. I clicked on it and a second or two later I got the message:
‘The update cannot be installed because WordPress 2.9 requires MySQL version 4.1.2 or higher. You are running version 4.0.27’
How I got around it
The partial answer is contained in the post here. However I’ll add a few bits of information on what I did differently.
I created a new MySQL 5.0 database from the MySQL admin panel. On the old 1and1 business hosting package I think you can create two MySQL databases (or up to 10 on the newer business hosting package) so you don’t need to delete the existing one first. Don’t delete it – you may need it if everything goes wrong with the upgrade!
I didn’t import the data by using the XML backup. I imported the data into the new MySQL 5.0 database from the gzipped SQL archive that I’d created in step 1 above.
You can import the SQL data from the MySQL admin panel by going to the tab to execute SQL commands, and then selecting the .gz file. Importing the SQL file through a .gz file gets around the 2MB size limit in the MySQL admin panel.
Importing from the .gz file rather than the .XML will import all your database data, and plugin settings, whereas if you do it from the .XML file you may have to manually re-enter various settings into your blog.
In your wp-config.php you will have to ensure that the DB_NAME, DB_USER, DB_PASSWORD and DB_HOST have been updated with the settings of your new MySQL 5.0 database.
Upload the wp-config.php file and if everything has gone right your blog should still be working and look exactly the same as before. Your blog will be using the old version of WordPress but will be accessing the data from the new MySQL 5.0 database.
You should now be able to click on the upgrade button and the blog should upgrade in less than 5 seconds.
This worked fine for me on 1and1. If you have loads of plugins or a heavily customised theme you may find more problems. If this is the case you can try deactivating plugins, or switch to the default theme.
If you really can’t get things to work you should be able to roll back to your pre-2.9 WordPress blog by restoring the files that you zipped in step 3 above. You MySQL 4.0 database should still be there (as long as you didn’t delete it).
Upgrading WordPress can often be a pain but at least having upgraded the SQL database from 4.0 to 5.0 should avoid more problems in the future. And now with WordPress 2.9 you can look forward to batch updating your plugins rather than doing them one at a time!
Hi Clay,
To import using phpmyadmin you need to go to the SQL tab, click Browse, select your file, and click Go.
If that doesn’t work and you don’t get any kind of error message you’ll have to contact your web hosts support.
Hi! thanks for this tip. I had the same problem. One question: how did you the new MySql 5 db to accept the import. My old db was 12 MB – Gzipped is was about 9 MB, so I Bzipped it and it was 1.4 MB.
Upon import, following your instructions, I was able to upload the file, but it never appeared in the new db and I received no message or upload progress meter.
I can only emphasize to create a new MySQL 5 database first and switch instead of deleting the old database and creating the new one: Deleting a mySQL database on 1and1 seem to take forever… 2h and waiting for me.
Same here Axel, Have 2 databases on 1and1 business. One is my main one for my site and the second was old junk from a site i closed.
Deleted old database this morn to start work on a new forum installation.
9 hours and 2 phone calls later im still waiting
Thx a lot, those SQL Databases are a nightmare when you don’t know anything about them…