On Thu, Sep 9, 2010 at 4:03 PM, David C. Smith <dcsmit...@gmail.com> wrote:
> All, I am trying to manually parse the freelist to recover deleted data. > Yes, I googled for someone to have created this already :) > > I am getting data that I don't expect and wanted to see if anyone could see > where I have a misunderstanding. I am using > http://www.sqlite.org/fileformat2.html > > () = test data > read the database file > read page size at offset 16 & 17 (1024 0x400) > read first freelist trunk page at offset 32 to 35) (00000000) > Your freelist is empty. There are no unused pages in your database. Probably the two rows you delete were small enough to fit on a single page so no pages were released and no pages were added to the freelist. > Go to that page (1024, page 1) > > **> this is where I start having issues > B-tree Page header format says that offset 0, size 1 should be a 2,5, 10, > 13 or is in error. I have a 0D. > But, offset 1, 2 have 03 E3 (995) and that leads to 2019, the start of my > deleted data . > > I have not built a database with 2 deleted rows, so I am not sure how to > follow the free block list. > > Any help comments? > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
