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
integrity_check" prior
running the backup to avoid that a backup will be overwritten
with an invalid database.
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.
Sure I could try to simulate that, but probably somebody here
knows the answer.
Thank you.
Marcus
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users