Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I currently have MySQL 5.1.35 installed on a Windows 2008 server via the MSI installer. I need to upgrade to the latest 5.1.44 to fix a bug, but docs were not clear on how to do this.

I ran the MSI installer, but it did not give me any upgrade option so I quit it. I am weary because it's a production machine with many PHP websites running on it. Also, my data directory is not the default one, it's kept on another partition.

How can I upgrade it? Thanks for any help.

share|improve this question

2 Answers 2

up vote 1 down vote accepted

If you can't come up with any other options you could

  • backup your config
  • backup your databases
  • uninstall mysql
  • install new version
  • restore configuration
  • restore data

You should do the first two steps even if you find a way to upgrade.

share|improve this answer
    
No need to uninstall. Just install over the previous one. –  John Gardeniers Mar 16 '10 at 9:08
  • Backup the databases first, as there is always a possibility of something going wrong.
  • Stop the MySQL service.
  • Backup the MySQL application folder tree.
  • Install the new version over the top on the old one.
  • Restart the service.

Unless something bad happened, as we all know can happen with software, you'll be up and running with the latest version. If something does go wrong just uninstall the new version and restore your backups.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.