Re: [sqlite] backup open database

2005-05-02 Thread Ara.T.Howard
On Sun, 1 May 2005, D. Richard Hipp wrote: On Sun, 2005-05-01 at 00:28 +0800, Damian Slee wrote: i want to make a copy of a sqlite3 database file while it is open. is there anyway that i can tell programatically that any caches/journals are flushed out? or is there any way to get and exclusive

Re: [sqlite] backup open database

2005-05-01 Thread D. Richard Hipp
On Sun, 2005-05-01 at 00:28 +0800, Damian Slee wrote: > i want to make a copy of a sqlite3 database file while it is open. is > there anyway that i can tell programatically that any caches/journals > are flushed out? or is there any way to get and exclusive lock i > guess, before making a backup

RE: [sqlite] backup open database

2005-05-01 Thread Mrs. Brisby
t; > > From: Mrs. Brisby [mailto:[EMAIL PROTECTED] > Sent: Sun 1/05/2005 1:07 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] backup open database > > > > Why is it inappropriate to use: > > sqlite originaldb ".dump&

RE: [sqlite] backup open database

2005-04-30 Thread Damian Slee
From: Mrs. Brisby [mailto:[EMAIL PROTECTED] Sent: Sun 1/05/2005 1:07 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] backup open database Why is it inappropriate to use: sqlite originaldb ".dump" | sqlite backupdb On Sun, 2005-05-01 at 00:28 +0800, Damian

Re: [sqlite] backup open database

2005-04-30 Thread Mrs. Brisby
Why is it inappropriate to use: sqlite originaldb ".dump" | sqlite backupdb On Sun, 2005-05-01 at 00:28 +0800, Damian Slee wrote: > hi all, > i want to make a copy of a sqlite3 database file while it is open. is there > anyway that i can tell programatically that any caches/journals are

[sqlite] backup open database

2005-04-30 Thread Damian Slee
hi all, i want to make a copy of a sqlite3 database file while it is open. is there anyway that i can tell programatically that any caches/journals are flushed out? or is there any way to get and exclusive lock i guess, before making a backup copy? my proposed application would have quite a