Open Dental Backup and Restore Guide

If you are attempting to run a backup or restore and receive an error message like "Access Denied," "File in use," or if the process simply hangs and never completes, you are likely encountering a permissions or file-locking issue. These symptoms often occur when the software does not have the necessary administrative rights to access the database folders or when another program is actively using the files during the backup attempt.

Quick Fix

1. Run as Administrator: Close Open Dental on all workstations. On the server, right-click the Open Dental icon on your desktop and select "Run as Administrator." Attempt the backup or restore again.
2. Check for Locked Files: Ensure no other users are logged into Open Dental. If you are using third-party backup software (like Carbonite or IDrive), ensure it is not configured to perform a live backup of the C:\mysql\data folder at the same time you are running the Open Dental tool.

Step-by-Step Troubleshooting

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

1. Verify Server Location: Backups must be performed from the server that hosts the MySQL or MariaDB database. If you are trying to run the backup tool from a workstation, you will likely receive an error. Go to Help > About to confirm you are physically on the server machine.
2. Check Folder Paths: In the Manage Module, click Backup. Verify that the "Backup database FROM this folder" path matches your actual database location (typically C:\mysql\data\). If you are unsure of your path, check the my.ini file located in C:\Program Files\MySQL\MySQL Server 5.5\ (or your specific version folder).
3. Check Disk Space: Ensure the destination drive (the "Backup TO" path) has sufficient free space. If the drive is full, the backup will stop abruptly.
4. Test the Restore: If you are trying to restore a database, never restore directly over your live data. Always restore to a separate, non-networked computer first to verify the backup file is not corrupted.
5. Check Security Permissions: Ensure the Windows user account running Open Dental has full Read/Write permissions for both the source database folder and the destination backup folder.

Why This Happens

Open Dental stores your patient data in a database folder (usually C:\mysql\data\). Because this database is constantly being accessed by the software, the files are often "locked" by the operating system. If you try to copy these files while they are in use, or if your user account lacks administrative privileges to override these locks, the backup will fail.

How to Prevent This

1. Automate and Test: Use a reliable, automated backup solution that is designed to handle "locked" database files. Regardless of the tool, perform a test restore at least once a month to ensure your files are actually usable.
2. Rotate Drives: Use at least three external hard drives and rotate them daily. Keep one drive off-site at all times to protect against fire, theft, or flood.

When to Contact Open Dental Support

If you have followed these steps and still cannot complete a backup or restore, or if you receive a "Database Corrupt" error, stop immediately. Do not attempt to modify the database files manually, as this can lead to permanent data loss. Call the official support team at 503-363-5432. They have specialized tools to repair database tables and can assist with complex recovery scenarios.

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.