Thank you all for the help! On Wed, May 30, 2012 at 1:22 PM, Simon Slavin <[email protected]> wrote:
> > 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 > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
