To update Open Dental when using Replication, refer to the steps below.
Before updating, make sure required setup is complete.
- All workstations need shared access to an A to Z Folder with the updated contents of the Update Files folder (e.g. use file replication for shared network folders). See Paths
- Pick one replication server to always perform updates from. This is typically the first server in your replication chain. Set this server as your Update Server Name in Miscellaneous Setup to ensure updates are not ran from any other workstation.
- Coordinate a specific time to perform the update with all locations. Users should stay out of Open Dental for up to 60 minutes.
When ready to update Open Dental for all locations, follow the steps below:
- From your Update Server, kick all users out of Open Dental. Go to Tools, Misc Tools, Shutdown All Workstations. This tool reminds users about the update and closes Open Dental on all workstations.
- Ensure all MySQL replication servers are running smoothly.
- From the File Explorer, navigate to the MySQL folder. The default location is
C:\Program Files (x86)\MySQL\MySQL Server 5.5
- Locate the MySQL bin folder. Hold the shift key and right-click the folder.
- Select Open Command Window Here. You will get the following window:
- Run the following command. Replace opendental with the name of the database if different.
-mysql -u root -c opendental
- Run the next command.
show slave status \G;
You will get the following information:
- Repeat step two for each server.
Note: By running the show slave status command on each server it will determine if replication is up and running. Do not continue if any slave status says that the Slave IO or Slave SQL is not running.
- From the Update Server, open Open Dental and go to Help, Update. Install the updated version.
- Launch Open Dental to upgrade the database.
- In Open Dental go to Setup, Advanced Setup, Replication.
- Click Synch in the lower left. This will ensure all replication servers receive the database update queries.
- Once complete, users can log back into Open Dental. They will be prompted to update to the new version. Select OK, then log in as normal.