Dumping unreferenced pages in an sqlite file and re-referencing them.

Question

Hi there!

I got a damaged sqlite3 file with some pages referenced twice and some with zero references. I would like to know and dump these unreferenced pages and, if possible, manually re-reference them. The result of PRAGMA integrity_check; follows:

"*** in database main ***
On tree page 108 cell 0: 2nd reference to page 247
On tree page 108 cell 1: 2nd reference to page 248
On tree page 108 cell 2: Child page depth differs"

The result of PRAGMA freelist_count; is 6. My hope is look for lost data on these 6 pages and try to fix manually. Is there a way to do that?

Thanks in advance!