Backup files · WhatsApp

7c7fba66680ef796b916b067077cc246adacf01dis ChatStorage.sqlite

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 nameChatStorage.sqlite
DomainAppDomainGroup-group.net.whatsapp.WhatsApp.shared
PathChatStorage.sqlite
In the backup folder7c/7c7fba66680ef796b916b067077cc246adacf01d
Its name is the SHA-1 ofAppDomainGroup-group.net.whatsapp.WhatsApp.shared-ChatStorage.sqlite
AppWhatsApp
Seen iniOS 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 backupNo. Unencrypted backups have it too.
OpenExtract reads itYes, on the WhatsApp screen. Guide: Export WhatsApp chats from an iPhone backup

What it holds

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.

Key columns

Tables by iOS version

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

How to open it

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

Read the backup, not the hashes.
OpenExtract opens iPhone backups for you. Free, open source, nothing uploaded. Mac · Windows · Linux.
Download OpenExtract →