Server Migration

See MySQL.

This information is for advanced IT users only. If you need assistance with any of these steps, something does not go as expected, or you have errors, please Contact Open Dental support. Follow these steps to migrate Open Dental to a new server.

Required Steps Before You Begin

MySQL

  1. 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. See the How to Determine your Current MySQL Version section on MySQL.
  2. If your MySQL Version is 5.6, you will first install 5.5 using the Open Dental Trial installer, then continue with the MySQL Upgrade to 5.6.

eServices
eService users will need to disable the eConnector and OpenDentalService on the old server, and reinstall them to the new server.

HL7
HL7 users should contact Open Dental support to schedule a server migration.

Backup
Make a backup of your original OpenDentImages folder and the mysql/data folder (database).

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.

Migrate to a New Server

On the Old Server

  1. Stop the MySQL Service.
  2. 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.
  3. 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.
  4. Make a copy of the OpenDentImages folder and also save it to your flash drive or removable drive.
    • The OpenDentImages folder is usually found at c:\OpenDentImages.
  5. 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.
  6. Disable Port 3306 in Windows Firewall.

On the New Server

  1. Download the Trial Version.
    • 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.
  2. 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 the next step.
  3. Stop the MySQL Service.
  4. Put the copy of the database on the new server into the MySQL folder.
    • The database is usually found at c:\mysql\data.
  5. Start the MySQL Service.
  6. Create, share, and set full access on the newly-created OpenDentImages folder.
    • Usually at c:\OpenDentImages.
  7. Put the copy of the OpenDentImages folder you have migrated from the old server into the same directory as newly-created OpenDentImages folder, merging the folders.
    • You may continue to the next step 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.
  8. From within the OpenDentImages folder, right-click on setup.exe, then Run as administrator to install Open Dental.
  9. Once the installation is complete, open Open Dental (Run as administrator) and enter the new Server Name.
  10. Update the path to the OpenDentImage Folder.
    • If the Data Paths window opens (Paths), make sure the paths point to the new server
    • If it does not open, in Open Dental, click Setup, Data Paths to ensure the paths point to the new server.
  11. Open Port 3306 in Windows Firewall.
  12. Install the Open Dental Service. Many features in Open Dental utilize this service.

On Each Workstation

  1. Start Open Dental on (Run as administrator).
  2. On the Choose Database window, enter the new server name.