=?utf-8?Q?Olaf_Beckman_Lapr=C3=A9?= <[EMAIL PROTECTED]> wrote: > Hi, > > Is there a way to do this programmatically? I would like to recover from a > damaged database upon program startup. >
If your program crashes, or your computer loses power in the middle of a database change, and thus leaves the database in an inconsistent state, recovery is automatic. You do not need to do anything. The database automatically reverts to its prior state. If, however, you set "PRAGMA synchronous=OFF" or if you delete a hot journal file, or if you write random garbage into the middle of a database file, then there isn't much you can do to recover. How exactly is your database being damaged and why do you think you need some kind of automatic recovery mechanism over and above what is already implemented? -- D. Richard Hipp <[EMAIL PROTECTED]>
