In an iPhone backup, the file e794f6ffcc3c222535f47684a63d5178da3c4500 is LID.sqlite. WhatsApp's LIDs, the IDs newer WhatsApp versions use instead of phone numbers, matched to numbers and names.
| Real name | LID.sqlite |
| Domain | AppDomainGroup-group.net.whatsapp.WhatsApp.shared |
| Path | LID.sqlite |
| In the backup folder | e7/e794f6ffcc3c222535f47684a63d5178da3c4500 |
| Its name is the SHA-1 of | AppDomainGroup-group.net.whatsapp.WhatsApp.shared-LID.sqlite |
| App | |
| Seen in | iOS 15.3.1, 16.1.2 and 17.3. Not in the iOS 13.3.1, 13.4.1 and 16.0 backups we checked. |
| Needs an encrypted backup | No. Unencrypted backups have it too. |
| OpenExtract reads it | Yes, on the WhatsApp screen. Guide: Export WhatsApp chats from an iPhone backup |
Newer WhatsApp versions can refer to a person by a LID, an ID that isn't their phone number, so a message in ChatStorage.sqlite can carry a LID where you'd expect a number.
LID.sqlite pairs LIDs with phone numbers in ZWAPHONENUMBERLIDPAIR, and with display names in ZWALIDPROPERTIES.
ZWAPHONENUMBERLIDPAIR.ZLID: The LID.ZWAPHONENUMBERLIDPAIR.ZPHONENUMBER: The phone number it stands for.ZWALIDPROPERTIES.ZLID: The LID.ZWALIDPROPERTIES.ZDISPLAYNAME: The name WhatsApp shows for it.iOS 15.3.1 has 6 tables:
ZWALIDPROPERTIES, ZWALIDTHREADPROPERTIES, ZWAPHONENUMBERLIDPAIR, Z_METADATA, Z_MODELCACHE, Z_PRIMARYKEY
Then, version by version:
ZWASINTEROPINTEGRATORPROPERTIES.ZWAZACCOUNT.Free, in OpenExtract. Open the backup in OpenExtract and choose WhatsApp. OpenExtract uses it to show a name or number instead of a LID. Step by step: Export WhatsApp chats from an iPhone backup.
By hand. In a backup that isn't encrypted, e7/e794f6ffcc3c222535f47684a63d5178da3c4500 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