Site Status: MySQL Upgrade: 4.1 to 5.0
I upgraded the MySQL database for this blog from version 4.1 to 5.0 so it matches my others. Nothing surprising or particularly difficult about this; I just exported a copy of the data from the 4.1 database, created the 5.0 database, and then imported the original 4.1 data from the copy I just made.
There was one slight problem however: The export database script I generated during the 4.1 database export had a CREATE DATABASE command in it. That database had already been created when I set up the 5.1 database. So I just commented out this line and the USE line below it, and then the importation completed successfully. I then pointed the web site code to the new database, and everything seems to work well.