Upgrade to MySQL 5.5

 

Upgrade to MySQL 5.5

It is time to move to MySQL 5.5.14.

Why Upgrade?


It is not uncommon for newer versions of EZ2000 Plus Dental to have 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 which can be annoying.  Since the errors are coming from MySQL rather than EZ2000 Plus Dental, the only way to get the bug fix is to upgrade MySQL. Remember this is an issue with MySQL and not EZ2000 Plus Dental.  

Start with MySQL 5.0
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 EZ2000 Plus Dental 15.1 or later BEFORE upgrading to MySQL 5.5

Follow the standard procedure for Updating EZ2000 Plus Dental to version 15.1 or later.

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)mysqlmysql 5.0) was not deleted, make sure to delete it manually.

3. Run the EZ 2000 Dental Plus Installer. Then, right click on it and then Run as Administrator.  Be patient; it takes about 20 seconds to start.

Click the Update MySQL button.  Verify that ALL paths are correct, especially if your data path is not the standard C:mysqldata

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 the Install button.  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 EZ2000 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.

 

  EZ2000 Plus Dental Software 800-273-5033