In an iPhone backup, the file 31bb7ba8914766d4ba40d6dfb6113c8b614be442 is AddressBook.sqlitedb. The Contacts database: each contact's name, company, phone numbers, email addresses and notes.
| Real name | AddressBook.sqlitedb |
| Domain | HomeDomain |
| Path | Library/AddressBook/AddressBook.sqlitedb |
| In the backup folder | 31/31bb7ba8914766d4ba40d6dfb6113c8b614be442 |
| Its name is the SHA-1 of | HomeDomain-Library/AddressBook/AddressBook.sqlitedb |
| App | Contacts |
| Seen in | iOS 13.3.1, 13.4.1, 15.3.1, 16.0, 16.1.2 and 17.3. |
| Needs an encrypted backup | No. Unencrypted backups have it too. |
| OpenExtract reads it | Yes, on the Address book screen. Guide: Export iPhone contacts |
AddressBook.sqlitedb holds the contacts saved on the iPhone. Each person is a row in ABPerson, with their name, company and notes.
Phone numbers, email addresses and anything else a contact can have more than one of are rows in ABMultiValue. Each row's record_id is the person's ROWID in ABPerson, and property says what the value is.
Contact photos aren't in this file. They're in AddressBookImages.sqlitedb, next to it.
ABPerson.First: First name.ABPerson.Last: Last name.ABPerson.Organization: Company.ABMultiValue.record_id: The contact's ROWID in ABPerson.ABMultiValue.property: What the value is: 3 is a phone number, 4 an email address.ABMultiValue.value: The number, address or other value.The same 29 tables in every backup we opened (iOS 13.3.1, 13.4.1, 15.3.1, 16.1.2 and 17.3):
ABAccount, ABGroup, ABGroupChanges, ABGroupMembers, ABMultiValue, ABMultiValueEntry, ABMultiValueEntryKey, ABMultiValueLabel, ABPerson, ABPersonChanges, ABPersonFullTextSearch, ABPersonFullTextSearch_content, ABPersonFullTextSearch_docsize, ABPersonFullTextSearch_segdir, ABPersonFullTextSearch_segments, ABPersonFullTextSearch_stat, ABPersonLink, ABPersonMultiValueDeletes, ABPersonSearchKey, ABPhoneLastFour, ABStore, ClientCursor, ClientCursorConsumed, ClientSequence, FirstSortSectionCount, FirstSortSectionCountTotal, LastSortSectionCount, LastSortSectionCountTotal, _SqliteDatabaseProperties
The iOS 16.0 backup is encrypted with a password that isn't public, so only its list of files was checked, not its tables.
Free, in OpenExtract. Open the backup in OpenExtract and choose Address book. People uses it too. OpenExtract lists every contact and saves them as vCard or CSV. It also uses the address book to put names on messages, calls and voicemails. Step by step: Export iPhone contacts.
By hand. In a backup that isn't encrypted, 31/31bb7ba8914766d4ba40d6dfb6113c8b614be442 is an ordinary SQLite database with no extension. Copy it out of the backup folder and open the copy with any SQLite browser, such as DB Browser for SQLite. Work on a copy: changing anything inside a backup can stop it from restoring.
In an encrypted backup, the file in the backup folder is encrypted with a key of its own, which only the backup password unlocks, so nothing can open it until it's decrypted. OpenExtract does that when you open the backup and type its password.
Checked against public test backups from iOS 13.3.1, 13.4.1, 15.3.1, 16.1.2 and 17.3, and the file list of an iOS 16.0 backup, reading only file, table and column names. How we checked · All backup files