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 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.
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.