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. ( I don't know what the corruption is)