> 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?
If sqliteman or other applications don't report any error then most probably data was just deleted from database. You can still see it in the file because it wasn't wiped out and this space wasn't reused for other data yet. > My efforts to modify the .db file haven't yielded any positive results. > I'll try anything, but am running out of places to look for help or > information about file structures of .db files. http://www.sqlite.org/fileformat2.html Pavel On Wed, May 30, 2012 at 3:11 PM, Peter Blair <[email protected]> wrote: > Hi All, > 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? > > My efforts to modify the .db file haven't yielded any positive results. > I'll try anything, but am running out of places to look for help or > information about file structures of .db files. > > Any additional direction or help would be greatly appreciated. I'd be > happy to send the file and more details if anyone would like to take a look. > > Thanks, > Pete > _______________________________________________ > 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
