On Thu, Apr 7, 2011 at 9:48 AM, Jonathan Allin <jonat...@jonathanallin.com> wrote: > >> After some more diagnosis I discovered that the free list is not >> corrupted afterall. It's just that the showdb tool fails to work >> properly with databases larger than 4Gb and since the free list trunk >> pages are located beyond the 4Gb barrier it caused problems. >> > > What is showdb? I could only find > http://www.koders.com/c/fid038880E49A3473D4D58E9755F1A3105D8F5C2D21.aspx?s=s > ubstr > > Thanks, > > ¬Jonathan
What you found seems to be very old version of the same utility. Current version is available in the sqlite3 source distribution (the full one, not the amalgamation) or at http://www.sqlite.org/src/dir?name=tool There are three tools to dump various information from the SQLite3 database files: - showdb for dumping information from the main database file. It supports decoding of the header fields, free list, btree pages and raw dumps of database pages in readable hexadecimal format. - showwal for dumping contents of the WAL file - showjournal for dumping contents of the journal file The tools are very useful when dealing with corrupted databases or when trying to understand the SQLite3 file format. Best regards, Filip Navara _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
