Thread: Odds and ends
View Single Post
auouymous is offline auouymous
2011-11-02 , 05:48
Posts: 875 | Thanked: 918 times | Joined on Sep 2010
#190
Originally Posted by lma View Post
Never used it, but according to its garage page the db is sqlite3. Can the sqlite3(1) tool open it on the command line? (that doesn't seem to be readily available for Diablo, you'll have to run it on a PC I guess). Try something like "echo .dump | sqlite3 broken.db | sqlite3 recovered.db".

If all else fails you might at least be able to extract most of the text with strings(1)...
As mentioned in my post, sqlite3 is only able to read 2% of the file. I know how to extract the strings but sqlite splits individual memos into multiple blocks and spreads them out over the file. This makes it very difficult to find the entire contents of specific memos.

I was hoping there is a tool that understands sqlite format and could repair the bad section so I can extract more than 2%.