On Mon, Jul 23, 2012 at 3:51 PM, <[email protected]> wrote: > > Is there any way to merge the lost data stored in mmssms.db-wal / > mmssms.db-shm back into mmssms.db? For example, if the DB/WAL stores a > bunch of DELETE FROM statements could they be changed to INSERT INTO? >
The WAL file does not store a bunch of DELETE FROM statements. The WAL file stores 4k pages of the database file as they will appear after the delete occurs. Details at http://www.sqlite.org/fileformat2.html So, no, there is no way to do what you are asking. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
