Page 1 of 1

Archived OD dbs causing a problem

Posted: Thu Oct 29, 2020 7:13 am
by wjstarck
I have some third party software that imports HL7 messages into the db. It's written for SQL, but they support MySQL. I have run into an issue where their MySQL Schema Engine will get confused if there is more than one OD database in the MySQL data folder, which is where OD places archived dbs when the user does an update of OD. They tell me this is because of the way SQL works as opposed to MySQL. So I will need to watch that folder and move those archived dbs to another folder in the filesystem. I plan on creating a folder and notifying the user via a MessageBox that I have moved those backup dbs to that folder. Anything else I need to be aware of so that I don't create issues for OD support staff?

Re: Archived OD dbs causing a problem

Posted: Thu Oct 29, 2020 12:05 pm
by joes
Open Dental does not access these backups after they are made, so this shouldn't cause any issues under normal circumstances. But, if someone were to somehow select the backup on the Choose Database screen or access the DB outside of OD before it is moved, the move may get blocked if files in the backup are being accessed. This is because the MyISAM storage engine used for most OD databases locks the files for a table when the table is being accessed.

Re: Archived OD dbs causing a problem

Posted: Sat Oct 31, 2020 3:14 pm
by jordansparks
Keeps that folder cleaner, anyway. Darn those buggy 3rd party tools.