On 30 May 2012, at 8:11pm, Peter Blair <[email protected]> wrote:
> I need help finding resources to help me recover data from a .db file. > > The file would be disposable but it contains some memorable and hilarious > quotes from my 3 year old daughter that would break my heart to lose. > > It's a notes.db file from the iPhone Notes application. > > My apologies if this is entirely the wrong forum to ask such a question. > > Opening the file in a text editor, I can see much (maybe all?) of the > fragmented contents of the note, but opening the file in sqliteman (or > other applications), doesn't show any records for the note or associated > data. > > I'm assuming it's perhaps a broken index, missing a record in a relational > table, or something is just slightly off so that it cannot pull a valid > record for the data in the file? The file may be a SQLite database file which contains only rows which have been deleted. The file still contains lots of text, but no SQLite application will be able to read the rows. It might be simplest to simply run strings on the file. If you have a Mac or a Unix computer type strings notes.db or use 'man strings' to find out how the tool works. There's probably a Windows equivalent but I don't know Windows that well. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
