Re: [sqlite] Backup API handling of corrupt source DB

2012-03-07 Thread Marcus Grimm
>>> You can do the backup and after that do an integrity check on the >>> backup. Surely you're backing up on a different >>> server, don't you? If the back up pass the integrity check it a real >>> backup, if not, launch a warning. >> >> Yeah, that's a good idea. >> Ohh boy, why I didn't think

Re: [sqlite] Backup API handling of corrupt source DB

2012-03-07 Thread TeDe
Am 07.03.2012 13:21, schrieb Marcus Grimm: > > On 07.03.2012 13:13, Eduardo Morras wrote: >> At 12:22 07/03/2012, you wrote: >>> Dear list, >>> >>> I'm using the backup api to frequently backup >>> a running sqlite database. >>> >>> I'm wondering if the backup API is able to detect a corrupt >>>

Re: [sqlite] Backup API handling of corrupt source DB

2012-03-07 Thread Marcus Grimm
On 07.03.2012 13:13, Eduardo Morras wrote: At 12:22 07/03/2012, you wrote: Dear list, I'm using the backup api to frequently backup a running sqlite database. I'm wondering if the backup API is able to detect a corrupt database or will it simply also backup a corrupt DB ? I evaluating the

Re: [sqlite] Backup API handling of corrupt source DB

2012-03-07 Thread Eduardo Morras
At 12:22 07/03/2012, you wrote: Dear list, I'm using the backup api to frequently backup a running sqlite database. I'm wondering if the backup API is able to detect a corrupt database or will it simply also backup a corrupt DB ? I evaluating the need to issue a (timeconsuming) "pragma

Re: [sqlite] Backup API handling of corrupt source DB

2012-03-07 Thread Marcus Grimm
On 07.03.2012 12:53, Simon Slavin wrote: On 7 Mar 2012, at 11:22am, Marcus Grimm wrote: I evaluating the need to issue a (timeconsuming) "pragma integrity_check" prior running the backup to avoid that a backup will be overwritten with an invalid database. Did you

Re: [sqlite] Backup API handling of corrupt source DB

2012-03-07 Thread Simon Slavin
On 7 Mar 2012, at 11:22am, Marcus Grimm wrote: > I evaluating the need to issue a (timeconsuming) "pragma integrity_check" > prior > running the backup to avoid that a backup will be overwritten > with an invalid database. Did you know about

Re: [sqlite] Backup API handling of corrupt source DB

2012-03-07 Thread Dan Kennedy
On 03/07/2012 06:22 PM, Marcus Grimm wrote: Dear list, I'm using the backup api to frequently backup a running sqlite database. I'm wondering if the backup API is able to detect a corrupt database or will it simply also backup a corrupt DB ? Backup just copies pages. It will not detect

[sqlite] Backup API handling of corrupt source DB

2012-03-07 Thread Marcus Grimm
Dear list, I'm using the backup api to frequently backup a running sqlite database. I'm wondering if the backup API is able to detect a corrupt database or will it simply also backup a corrupt DB ? I evaluating the need to issue a (timeconsuming) "pragma integrity_check" prior running the