On 01/27/2016 08:47 PM, J Decker wrote: > I was wondering if the backup api (sqlite3_backup_init, et al. ) will > help to recover a corrupt DB? All the other mechanisms are an export > and re-import into a new DB... > > The database exists in a encrypted database that it's really difficult > to get the keys outside of the program and I don't look forward to > doing something that iterates through sqlite_master to get all the > tables do all the selects and re-insert... so I browsed the API and > found the _backup_ stuff.. but; I'm starting to think that it will > just be a faithful page replication and the result will still be > corrupted.
Most likely, yes. As you have surmised, the backup API does a page-by-page copy. Dan.