Server Migration

See MySQL.

This information is for advanced IT users only. If you don't understand any of these steps, something does not go as expected, or you have errors, please Contact Open Dental.

Before you begin, make a backup of the original data on the old server (A to Z Folder and mysql/data folder).

Customers using eServices or HL7 services should contact Open Dental Support after performing a Server Migration to ensure services are running and confirm access to those features.

You will need to verify what version of MySQL you are running. When migrating, the same MySQL version will need to be on the new server as the old server.

For MySQL version 5.6 users: Our trial installer should be run first to install the proper grant tables, then the MySQL version should be upgraded to 5.6 following the below instructions.

Migrate to a New Server

On the old server:

  1. Verify what version of MySQL is installed. To do this, go to Help > About within Open Dental and check the Service Version. You can also open Windows Services > right click MySQL service and select Properties. Check the folder name in the file path. It will usually have the version number in the folder path. (ex: C:\Program Files (x86)\MySQL\MySQL Server 5.5...).
  2. Stop the MySQL Service. Click Start, Control Panel, Administrative Tools, Services, MySQL. Right-click and select Properties, Stop. Do not click OK.
  3. Disable the MySQL service to make sure workstations no longer point to the older server. Change the Startup Type from Automatic to Disabled then click OK. If, for some reason, you want to use this computer again as a backup server, you can just set it back to Automatic and restart the MySQL service.
  4. Make a copy of the database and save it to a flash drive or removable drive. Databases can also be copied across the network. The database is usually found at c:\mysql\data and in a directory named opendental.
    Note: If your database structure is InnoDB, backup the entire data folder. Also have a backup copy of the my.ini file, usually located in C:\Program Files (x86)\MySQL\MySQL Server 5.5.
  5. Make a copy of the OpenDentImages folder and also save it to your flash drive or removable drive (usually found at c:\OpenDentImages).
  6. After the copy of the OpenDentImages folder is complete, remove sharing on the original folder. This prevents any workstations from accidentally storing images to this folder.

On the new server:

  1. Download the Trial Version.
  2. Install MySQL using the Trial Installer. Right click on the Trial version and Run as administrator. Only check the boxes for:
    • MySQL Server
    • MySQL 5.5 grant tables
    • my.ini
    • OpenDentImages
    Note: Do not check the boxes for Open Dental Program or opendental Database. These will be copied from the old server.
  3. UNCHECK the Launch the MySQL Instance Configuration Wizard checkbox at the end of the MySQL installation.
  4. If your old server had MySQL 5.6, or you wish to upgrade your version of MySQL 5.5, then upgrade to MySQL 5.6 on the new server. Otherwise skip to step 5.
  5. Stop the MySQL Service. Click Start, Control Panel, Administrative Tools, Services, MySQL. Right-click and select Properties, Stop.
  6. Put the copy of the database on the new server into the MySQL folder. The database is usually found at c:\mysql\data.
  7. Start the MySQL Service. Click Start, Control Panel, Administrative Tools, Services, MySQL. Right-click and select Start.
  8. Create, share, and set full access on the newly-created OpenDentImages folder. Usually at c:\OpenDentImages.
  9. Put the copy of the ODI folder you have migrated from the old server into the same directory as newly-created ODI folder, merging the folders. You may continue to step 10 while the merge is being performed
    Note: If you get a warning of more than three duplicate files (typically the claim form images included in an Open Dental installation), cancel and ensure you are copying into the correct folder.
  10. From the OpenDentImages folder, right-click on setup.exe, then Run as administrator to install Open Dental.
  11. Start Open Dental (Run as administrator) and if requested, enter the new Server Name.
  12. If the Data Paths window opens (Paths), make sure the paths point to the new server (e.g. \\NewServer\OpenDentImages). If it does not open, click Setup, Data Paths to ensure the paths point to the new server.
  13. Open Port 3306 in the Windows Firewall (if needed).
  14. Start Open Dental on one workstation (Run as administrator). On the Choose Database window, enter the new server name. You should not have to edit paths.
  15. Repeat step 14 for all workstations.

When using Open Dental eServices: If the eConnector service is installed on the server (typical), disable the service then install the eConnector on the new server.