Upgrading software can be such a pain in the backside!
I spent the last hour or so upgrading different versions of software on my server, saving the hardest for last.
The “problem child” was the upgrade to MySQL 5.1.35.
Currently there is a bug in the installer for MySQL 5.1.35 which fails.
To resolve the problem, I uninstalled MySQL 5.0 and used 5.1.34 to do the re-install.
The steps:
1. Backup your database (very important!)
2. Download MySQL 5.1.34 before the un-install
3. Un-install MySQL 5.0
4. Stop the MySQL service: goto a command line, type “net stop MySQL”, hit enter
5. Delete the MySQL service: remaining in the command prompt, type “sc delete MySQL”, hit enter
6. Install MySQL 5.1.34
7. Follow the steps for your configuration
8. Restore your database
According to MySQL, I can take the “noinstall” of MySQL 5.1.35 and copy it over my MySQL 5.1.34 installation. Since I have my MySQL install located other than the “program files” location, it shouldn’t be to difficult to do.