opendentalsupport.com is an independent community resource. We are NOT affiliated with, endorsed by, or sponsored by Open Dental Software, Inc. Open Dental® is a registered trademark of Open Dental Software, Inc.

Troubleshooting MySQL to MariaDB Upgrade

Troubleshooting4 min read3/30/2026

After attempting an open dental upgrade mysql mariadb, you may find that Open Dental fails to launch, or you receive an "Unable to connect to database" error when trying to open the program on your workstations. This typically happens because the database service failed to start, the configuration file is pointing to the wrong location, or the service is not properly registered in Windows.

Quick Fix

If you are stuck immediately after the upgrade, try these two steps first:

  1. Restart the Database Service: On your server, open the Windows Services window (press Windows Key + R, type services.msc, and hit Enter). Locate the service named MariaDB (or MySQL if the name didn't change). Right-click it and select Restart.
  2. Verify Workstation Connection: Ensure that the server's firewall is not blocking the new MariaDB port (default is 3306). If you can connect on the server but not on workstations, temporarily disable the Windows Firewall on the server to see if the connection succeeds.

Step-by-Step Troubleshooting

If the quick fix does not resolve your issue, follow these diagnostic steps in order:

  1. Check Service Status:

    • Path: Open Services on your server.
    • What to see: The MariaDB service should have a status of "Running."
    • Fix: If it is stopped, try to start it. If it fails to start, check the Windows Event Viewer (Application Log) for specific error codes. This often indicates a configuration error in the my.ini file.

  2. Verify the my.ini Configuration:

    • Path: Typically located in C:\Program Files\MariaDB 10.5\my.ini.
    • What to see: Open this file in Notepad. Ensure the datadir path points to the correct folder where your database files are stored (e.g., C:\mysql\data).
    • Fix: If the path is incorrect, update it to match your actual data location, save the file, and restart the MariaDB service.

  3. Confirm Database Files are Present:

    • Path: Navigate to your data directory (usually C:\mysql\data).
    • What to see: You should see a folder named opendental (or your specific database name) containing many .frm, .MYD, and .MYI files.
    • Fix: If this folder is missing or empty, your database was not correctly moved or the my.ini is pointing to a blank directory. You must restore your backup.

  4. Check for Port Conflicts:

    • What to see: If you have other database software installed on the server, it might be trying to use port 3306.
    • Fix: You may need to change the port in my.ini to something else (like 3307) and update your Open Dental connection settings accordingly.

Why This Happens

The open dental upgrade mysql mariadb process involves moving your data from an older 32-bit architecture to a more modern 64-bit environment. The most common point of failure is the my.ini file. This file acts as the "instruction manual" for the database. If the file paths, memory settings, or port configurations do not perfectly match your server's new environment, the database service will refuse to start, preventing Open Dental from accessing your patient records.

How to Prevent This

  1. Always Backup: Before starting any database migration, perform a full backup of your C:\mysql\data folder and your OpenDentImages folder.
  2. Use the Official Tool: Only use the ODDbmsUpgradeTool provided by Open Dental. Do not attempt to manually install MariaDB and move files unless you are an experienced IT professional.
  3. Test in Off-Hours: Perform the upgrade when the office is closed to ensure you have adequate time to troubleshoot without impacting patient care.

When to Contact Open Dental Support

If you have followed these steps and the service still will not start, or if you receive "Access Denied" errors, contact Open Dental support at 503-363-5432. Database corruption is rare but possible during an upgrade, and the official support team has specialized tools to repair tables and restore connectivity that are not available to the public.

Need better visibility into your Open Dental data? DentalCanvas gives you a visual dashboard — no SQL required.

This article is provided by opendentalsupport.com, an independent community resource. We are not affiliated with Open Dental Software, Inc.

Monitor Your Practice Health.

DentalCanvas tracks your Open Dental metrics in real time so you catch problems before they cost you money.

Try DentalCanvas

Was this article helpful?

Related Articles

Troubleshooting Dental Canvas Display Issues
opendentalsupport.com is an independent community resource. We are NOT affiliated with, endorsed by, or sponsored by Open Dental Software, Inc. Open Dental® is a registered trademark of Open Dental Software, Inc.