On 6/9/06, Christian Smith <[EMAIL PROTECTED]> wrote:
On Thu, 8 Jun 2006, [EMAIL PROTECTED] wrote:> I also occasionally back up the database using subversion ("svn > commit"), while the app that uses it is still running. My belief is > that subversion only reads a file to commit it, and doesn't write to it, > but it's possible that is wrong. Subversion only reads the file, but it doesn't do the atomically! This backup strategy has a race condition that could result in the backup of a corrupted file. DON'T use this method.
And even if it did (atomically), it wouldn't commit the journal file also, which will eventually lead to a corrupt database. Best regards, ~Nuno Lucas
