See Advanced Topics.

Information from Open Dental HQ

On Wednesday, July 14th, 2021, Open Dental released a new trial installer package. The new trial installer package contains the MariaDB application in place of the MySQL application. We are slowly transitioning our users from using MySQL version 5.5 to having them use MariaDB version 10.5. All new Open Dental users use MariaDB.

Existing Open Dental users may upgrade from MySQL to MariaDB if they choose, but it is not a requirement. See Database Management System Upgrade Wizard below for details.

The Open Dental application works with either MySQL or MariaDB. Open Dental remains compatible with MySQL versions 5.5, 5.6, and 5.7, in addition to all versions of MariaDB up through version 10.5.

About MariaDB

MariaDB was created by the original developers of MySQL, so think of MariaDB as an extension of the MySQL application. When MySQL version 5.6 was under development, the company was bought out by Oracle, and Oracle took over the development of MySQL starting at version 5.6. The original MySQL developers had concerns at that time that Oracle might slowly try to kill MySQL since MySQL was in direct competition with Oracle. As a result, the original MySQL developers created a new company called MariaDB, and they took a copy of the MySQL source code for versions 5.5 and 5.6. The MariaDB company then continued developing the MySQL application (but under the new name MariaDB). The MariaDB company has a philosophy that is closely aligned with that of Open Dental, in that software should remain open source as much as possible, and it is unknown if Oracle will continue to allow MySQL to be completely open source into the future. MariaDB currently has the following versions: 5.5, 5.6, 10.0, 10.1, 10.2, 10.3, 10.4, 10.5, and 10.6. Open Dental is using MariaDB version 10.5 for the time being.

General Overview

The Open Dental database runs on MariaDB 10.5 which is a very robust and reliable database. See

MariaDB and MySQL are closely related, some windows in Open Dental continue to use MySQL as the terminology.

Database Management System Upgrade Wizard

Existing Open Dental Users can utilize the Database Management System Upgrade Wizard to upgrade from MySQL to MariaDB 10.5.19:

We recommend contacting Open Dental Support for assistance with the upgrade.

Note: Offices must be on support with an active registration key to run this tool on the selected database

System Requirements:

Upgrade Steps:

  1. Clean up the mysql/data folder. See MySQL Data Directory Management for details.
  2. Ensure Open Dental is closed on all workstations. On the server, log into Open Dental and go to Tools, Misc Tools, Shutdown All Workstations, Shutdown All.
  3. On the Server, open Services from Windows and stop any OpenDentXXXX services (e.g., OpenDentalService, OpenDentalEConnector), as well as any Third-Party services that access the Open Dental database.
  4. Download the following upgrade tool: ODDbmsUpgradeTool
  5. Right-click the ODDbmsUpgradeTool.exe and Run as Administrator.
  6. Ensure MariaDB is selected in the DBMS Type drop down menu and click Next.
  7. Modify the Connection Settings, Backup Location, and Install Location as needed. If a MySQL password is set, enter it into the DBMS Password field. We recommend leaving Install Location at default.
  8. Click Upgrade.
  9. Once the process finishes successfully, close the wizard, and launch Open Dental on the server.
  10. A prompt Tables will now be backed up, optimized, and repaired. This will take a minute or two. Continue? will appear, click OK.
  11. Once the process is complete, the upgrade is finished. Start any services that were stopped in Step 2.

How to Determine if MariaDB is Installed

MariaDB should be installed on the server. To ensure MariaDB is installed:

  1. On the server, go to Services. See if the MySQL service is listed. Right-click and select properties. The Path to Executable should include a MariaDB folder.
  2. On the server, go to Add or Remove programs. See if an existing installation of MariaDB is listed.

How to Determine if MySQL is Running

The MariaDB server runs as a service (named MySQL) on one computer. To easily determine if MySQL is running, open Services and look for MySQL.

How to Determine the current MariaDB Version

  1. On the server, open Services.
  2. Navigate to the MySQL service, then right-click to view properties.
  3. In the Path to Executable, find the path to mysqld.exe. (Typically, C:\Program Files\MariaDB 10.5\bin\mysqld.exe)
  4. Open that path, then right-click on mysqld.exe and select properties.
  5. In the details tab, note the version.

How to Start/Stop the MySQL Service

Reminder: The MariaDB Service is named MySQL.

Option 1:

  1. Run CMD as an administrator.
  2. To start the MySQL service, type net start mysql.
  3. To stop the MySQL service, type net stop mysql.

Option 2:

  1. Open Services.
  2. Find MySQL in the list.
  3. Click Start or Stop.

Option 3:

  1. Open the Service Manager.
  2. Double-click MySQL from the list.
  3. Click Start or Stop.

To access the data in the MySQL database, use the table viewer in User Query.