Regarding:
"I NEED HELP! I have SQLite3 DB (contacts from iPhone), it
contains 1 record, but when I open it with NOTEPAD.EXE, I see more than 1
record.
I need to repair all records from it"
С уважением,
I received your db (via private email) and the good news is that the
PRAGMA INTEGRITY_CHECK
reports that it is a healthy database.
The *bad* news is that I suspect the data you are looking for was deleted
From the database point of view, at bottom are the tables and the number of
rows in each table. I can provide you a full dump of these records and schema,
but I suspect that's not what you are seeking.
I know of no utility to help you seek out data from deleted records whose data
may nonetheless be still present in the database file. Using something like
NOTEPAD may actually be your best bet -- see what cyrilic strings you can find.
Also, John's suggestion to contact the application's support dept (Apple?)
may help.
There's some great-looking documention on the sqlite file structure here:
http://www.sqlite.org/fileformat.html
but it's not for the faint-of-heart (i.e., not so easily digested).
I'm reminded of my old "databank" wristwatch. When it's battery died, I joked
that I had to go get a whole new set of friends. :-(
0 ABGroup
0 ABGroupChanges
0 ABGroupMembers
3 ABMultiValue
0 ABMultiValueEntry
8 ABMultiValueEntryKey
7 ABMultiValueLabel
3 ABPerson
0 ABPersonChanges
2 ABPersonMultiValueDeletes
3 ABPersonSearchKey
0 ABPhoneLastFour
0 ABRecent
3 ABStore
26 FirstSortSectionCount
29 LastSortSectionCount
16 _SqliteDatabaseProperties
2 sqlite_sequence
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
