MySQL 5.5

Warning: These steps will revert MySQL to the default settings and will remove any custom users, passwords, ports, or other security settings. If you have customized your MySQL installation, we recommend calling Open Dental for assistance updating MySQL.

Why Upgrade?

You are running a newer version of Open Dental that has issues with older versions of MySQL. A typical error is "Error 17", and it might happen a few times per day, requiring restarting the MySQL service each time. Since the errors are coming from MySQL rather than Open Dental, the only way to get the bug fix is to upgrade MySQL.

You must be on at least MySQL 5.0 before upgrading to 5.5. If you are on an earlier version of MySQL, such as 4.1, then follow the instructions at MySQL 5.0 as an intermediate step.

You MUST Update to Open Dental 7.8 or later BEFORE upgrading to MySQL 5.5

Follow the standard procedure for Update.

Upgrade to MySQL 5.5

  1. Always completely uninstall any older version of MySQL from Windows, Control Panel, Programs and Features. Uninstalling MySQL does not damage any data.
  2. If the old MySQL folder (such as C:\program files(x86)\mysql\mysql 5.0) was not deleted, make sure to delete it manually.
  3. Download the Trial Version 20.5.63. If prompted, select to save the file (not run).
  4. Once the download is complete, right-click on the downloaded file and select Run as Administrator. This may take about 20 seconds to start.
  5. Click Update MySQL. Verify that ALL paths are correct, especially if your data path is not the standard C:\mysql\data\.
  6. If you need to install the MySQL program to D:\ or to any location other than default, change the install path in the installer above.
  7. Click Install. Follow the directions. During the installation of MySQL 5.5, the Typical installation is probably the best choice.
    • If MySQL is not being installed to the default path, you must also choose Custom in the MySQL installer, then change the path to the desired path, and choose not to install the server data.

Performance Schema Errors

After upgrading to MySQL 5.5, harmless errors will start to show up in the event logs that look like "performance_schema...has the wrong structure". Performance schema is not used by Open Dental so these errors can be ignored. The mysql_upgrade.exe tool can be run manually in a command prompt to stop the errors from showing up in the logs. That tool can be found in the bin folder of the MySQL install directory.