Dawn and I faced a MySQL Upgrade for our Moodle LMS site and delayed as long as we could. Unlike traditional upgrades of Microsoft SQL, we couldn’t simply click a setup file and the upgrade would replace files and services as needed.
Here’s the easiest process we found to upgrade MySQL
- Stop the existing MySQL service in Services
- Make sure you have a backup of you MySQL database
- Open a command prompt (as administrator)
- change to the MySQL directory and type mysqld –remove (to remove the service under services) you can also remove it by using the SC Delete MySQL command.
- In the Service manager you should see that the service is removed.
- Uninstall MySQL under the Programs and Features menu
- Delete all folders under programdata and program files that are related to MySQL
- Make sure the latest .NET Framework is installed
- Download and run the MySQL Community package
View original post 66 more words