Upgrade to 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
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 Upgrade to 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 Updating Open Dental.
Upgrade to MySQL 5.5
- Always completely uninstall any older version of MySQL from Windows, Control Panel, Programs and Features. Uninstalling MySQL does not damage any data.
- If the old MySQL folder (such as C:\program files(x86)\mysql\mysql 5.0) was not deleted, make sure to delete it manually.
- Download the Trial Version. Do NOT run, but instead, save. Then, right click on the downloaded file, and Run as Administrator. Be patient; it takes about 20 seconds to start.
- Click Update MySQL. Verify that ALL paths are correct, especially if your data path is not the standard C:\mysql\data\
- If you need to install the MySQL program to D:\ or to any location other than default, not only must you change the install path in the installer above, but 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.
- Click Install. Follow the directions. During the installation of MySQL 5.5, the Typical installation is probably the best choice.
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.