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 Link
- Perform a new install
- Use the Server type: Server (Production deployments)
- Make sure your data directories are specified during the installation
- Use the same root password you had on the old installation
- Add admin users as necessary
- Restore your files if necessary (backups) with MySQL Workbench Link
- Complete the install
- Make sure the service is running
Note: Always make a backup before trying to update the database.