Faster backup?

[JLM]

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

[jsalmon]

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';