Manual Backups

If not using Royal dental Software's built in Backup Tool or an online Online Backups service, you can do manual backups.

Backup Data

  1. Log on to the server hosting the Royal dental Software database.
  2. Connect an external storage device (e.g., USB Flash drive).
  3. Make a copy of the following:
    • The database. This is typically found within C:\mysql\data\ and is typically named royaldental.
    • The RoyalDentImages folder. This is typically found on the C drive (e.g., C:\RoyalDentImages\)
  4. Place the copies on the external storage device.

Note: Manual backups should only be done on myISAM databases; not InnoDb.

Restore Data

To verify the backup is good, restore it to a workstation that is not connected to the network (e.g., Doctor's laptop).

  1. Ensure Royal dental Software and MySQL are already installed and the versions match the version backed up. See One Time Setup below for details.
  2. Stop the MySQL service.
  3. Rename the old database folder. For example, from C:\mysql\data\royaldental\ to C:\mysql\data\royaldentalold02142006\.
  4. Copy the database folder from the backup source to the appropriate location on the main hard drive. For example, from D:\royaldental\ to C:\mysql\data\royaldental\. Make sure you don't end up with too many layers (e.g., C:\mysql\data\royaldental\royaldental\).
  5. (optional) Copy the RoyalDentImages folder (the A to Z folders) to the hard drive. If one already exists, rename the old one or move it to a backups folder.
  6. Start the MySQL service.
  7. Open the program.

One Time Setup

If Royal dental Software is not installed on the workstation you are restoring to, do the following:

  1. Install the Trial version of Royal dental Software.
    • If your live database is using MySQL, install the trial version found at the bottom of the Trial Version page (under Troubleshooting). Install only the MySQL Server, the MySQL 5.5 grant tables, and the my.ini.
    • If your live database is using MariaDB, install the trial version found at the top of the Trial Version page. Install only the MariaDB Server, the MariaDB 10.5 grant tables, and the my.ini.
  2. Install the Royal dental Software program, navigate to the RoyalDentImages folder, and run setup.exe.
    • A backup of the RoyalDentImages folder must already be available on the restore workstation.

If you have trouble opening the program after restoring, you may need to run the setup.exe stored in your backup in the RoyalDentImages folder. If the installed version is newer than the backup version, then you will need to uninstall Royal dental Software from the control panel before running setup.exe.

Also see HIPAA.