Mysql backup

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
sandi
Posts: 106
Joined: Sun Jun 20, 2010 3:44 pm

Mysql backup

Post by sandi » Fri Jul 16, 2010 1:51 am

Does open dental flush read lock the tables when the inbuilt backup tool is used?
Ive been playing around with mysql administrator and its schedular is only daily at best, is there no better hourly schedular? What is the liklyhood of corruption using something like syncback pro which backs open files long term using shadow copy? I can schedule this hourly.
I dont wish to run mirrored RAID hence my query.

User avatar
jordansparks
Site Admin
Posts: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Mysql backup

Post by jordansparks » Fri Jul 16, 2010 7:08 am

We backup live databases all the time. After years of doing so, I have never run across a corruption. Still, there is a slight chance it could happen.
Jordan Sparks, DMD
http://www.opendental.com

sandi
Posts: 106
Joined: Sun Jun 20, 2010 3:44 pm

Re: Mysql backup

Post by sandi » Fri Jul 16, 2010 11:47 am

Great thanks, i guess the chances if i run hourly backups to seperate folders means that if one is corrupt the one prior should be ok. With the small risk i think il take it, thanks again.

Post Reply