MySQL Upgrade in Windows

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

  1. Stop the existing MySQL service in Services
  2. Make sure you have a backup  of you MySQL database
  3. Open a command prompt (as administrator)
  4. 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.
    1. In the Service manager you should see that the service is removed.
  5. Uninstall MySQL under the Programs and Features menu
  6. Delete all folders under programdata and program files that are related to MySQL
  7. Reboot
  8. Make sure the latest .NET Framework is installed
  9. Download and run the MySQL Community package  Link
  10. Perform a new install
  11. Use the Server type:  Server  (Production deployments)
  12. Make sure your data directories are specified during the installation
  13. Use the same root password you had on the old installation
  14. Add  admin users as necessary
  15. Restore your files if necessary (backups) with MySQL Workbench Link
  16. Complete the install
  17. Make sure the service is running

Note: Always make a backup before trying to update the database.



About TCAT Shelbyville IT Department

The Tennessee College of Applied Technology - is one of 46 institutions in the Tennessee Board of Regents System, the seventh largest system of higher education in the nation. This system comprises six universities, fourteen community colleges, and twenty-six Applied Technology Colleges.
This entry was posted in Computers, Education, Industry, Information Technology, Manufacturing, network, Networking, Software, Technology, Windows and tagged , , , , . Bookmark the permalink.

One Response to MySQL Upgrade in Windows

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s