In an iPhone backup, the file 7c7fba66680ef796b916b067077cc246adacf01d is ChatStorage.sqlite. WhatsApp's chats: every message, group and call on the phone, with pointers to its photos, videos and voice messages.
| Real name | ChatStorage.sqlite |
| Domain | AppDomainGroup-group.net.whatsapp.WhatsApp.shared |
| Path | ChatStorage.sqlite |
| In the backup folder | 7c/7c7fba66680ef796b916b067077cc246adacf01d |
| Its name is the SHA-1 of | AppDomainGroup-group.net.whatsapp.WhatsApp.shared-ChatStorage.sqlite |
| App | |
| Seen in | iOS 13.3.1, 13.4.1, 15.3.1, 16.1.2 and 17.3. Not in the iOS 16.0 backup 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 |
ChatStorage.sqlite is WhatsApp's own database, in its shared app group. Each chat is a row in ZWACHATSESSION and each message a row in ZWAMESSAGE. Photos, videos, voice messages and documents are separate files in the same domain, and ZWAMEDIAITEM says where each one is.
Its layout follows WhatsApp's version, not the iOS version. Two things catch people out: put a chat in order by ZSORT, the order messages arrived on the phone, because ZMESSAGEDATE comes from the sender's clock; and reactions aren't rows of their own, they're stored with the message they react to.
ZWACHATSESSION.ZCONTACTJID: Who the chat is with: a WhatsApp ID such as <number>@s.whatsapp.net, or a group's ID.ZWACHATSESSION.ZPARTNERNAME: The chat's name as WhatsApp shows it.ZWAMESSAGE.ZTEXT: The message text.ZWAMESSAGE.ZISFROMME: 1 if the phone's owner sent it.ZWAMESSAGE.ZMESSAGEDATE: When it was sent, by the sender's clock, in seconds since 1 January 2001 (UTC).ZWAMESSAGE.ZSORT: Its place in the chat, in the order it arrived on the phone.ZWAMEDIAITEM.ZMEDIALOCALPATH: Where the photo, video or other file is, relative to WhatsApp's folder.The same 18 tables in every backup we opened (iOS 13.3.1, 13.4.1, 15.3.1, 16.1.2 and 17.3):
ZWABLACKLISTITEM, ZWACHATPROPERTIES, ZWACHATPUSHCONFIG, ZWACHATSESSION, ZWAGROUPINFO, ZWAGROUPMEMBER, ZWAGROUPMEMBERSCHANGE, ZWAMEDIAITEM, ZWAMESSAGE, ZWAMESSAGEDATAITEM, ZWAMESSAGEINFO, ZWAPROFILEPICTUREITEM, ZWAPROFILEPUSHNAME, ZWAVCARDMENTION, ZWAZ1PAYMENTTRANSACTION, Z_METADATA, Z_MODELCACHE, Z_PRIMARYKEY
Free, in OpenExtract. Open the backup in OpenExtract and choose WhatsApp. Timeline uses it too. OpenExtract shows each chat with its photos, voice messages, replies, reactions and calls, and saves chats as a web page, PDF, CSV or text. Step by step: Export WhatsApp chats from an iPhone backup.
By hand. In a backup that isn't encrypted, 7c/7c7fba66680ef796b916b067077cc246adacf01d 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