Faster backup?

For users or potential users.
Post Reply
JLM
Posts: 128
Joined: Wed Dec 05, 2012 12:52 pm

Faster backup?

Post by JLM » Sat May 26, 2018 3:26 pm

Using the built in backup function of OD takes forever. At least 4 minutes seems like forever when you are trying to get out the door at the end of the day.
I tried a batch file consisting of

Code: Select all

net stop mysql
xcopy /y [source directory] [destination directory]
net start mysql
It takes about 15 seconds. Is there any danger to backing up this way? Assuming all of the other users are offline because I'm the last one to leave every day.

Jim Margarit

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: Faster backup?

Post by jsalmon » Mon May 28, 2018 7:01 am

That script is fine as long as all of your tables are of type MyISAM (which Open Dental prefers). The stopping of the mysql service is important so that you do not run the chance of getting a corrupt table (good job including the stop and start commands).

The following query will show you a list of all InnoDB tables in all of your databases (which do not support this kind of backing up). None should show up with a "table_schema" that matches the name of the Open Dental database that you connect to.

Code: Select all

SELECT table_schema, table_name
FROM INFORMATION_SCHEMA.TABLES
WHERE engine = 'innodb';
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

Post Reply