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)
  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

Reply via email to