In an iPhone backup, the file cd6702cea29fe89cf280a76794405adb17f9a0ee is AddressBookImages.sqlitedb. Contact photos: the small and full-size pictures shown for people in Contacts.
| Real name | AddressBookImages.sqlitedb |
| Domain | HomeDomain |
| Path | Library/AddressBook/AddressBookImages.sqlitedb |
| In the backup folder | cd/cd6702cea29fe89cf280a76794405adb17f9a0ee |
| Its name is the SHA-1 of | HomeDomain-Library/AddressBook/AddressBookImages.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 | Not yet. |
AddressBookImages.sqlitedb holds the pictures set for contacts. ABThumbnailImage has the small versions and ABFullSizeImage the full-size ones, each stored as image data in its data column.
record_id says whose picture it is: it's the contact's ROWID in ABPerson, in AddressBook.sqlitedb.
ABThumbnailImage.record_id: The contact's ROWID in ABPerson.ABThumbnailImage.data: The small picture, as image data.ABFullSizeImage.record_id: The contact's ROWID in ABPerson.ABFullSizeImage.data: The full-size picture, as image data.The same 3 tables in every backup we opened (iOS 13.3.1, 13.4.1, 15.3.1, 16.1.2 and 17.3):
ABFullSizeImage, ABThumbnailImage, _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.
OpenExtract doesn't read it yet. OpenExtract's Address book screen shows names, numbers and addresses from AddressBook.sqlitedb, but not these photos yet.
By hand. In a backup that isn't encrypted, cd/cd6702cea29fe89cf280a76794405adb17f9a0ee 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. Tools such as iphone_backup_decrypt, the open-source library OpenExtract uses, can decrypt a single file; then open the decrypted copy with any SQLite browser, such as DB Browser for SQLite.
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