In an iPhone backup, the file 3d0d7e5fb2ce288813306e4d4636395e047a3d28 is sms.db. The Messages database: every text and iMessage, who it was with, when, and which attachments go with it.
| Real name | sms.db |
| Domain | HomeDomain |
| Path | Library/SMS/sms.db |
| In the backup folder | 3d/3d0d7e5fb2ce288813306e4d4636395e047a3d28 |
| Its name is the SHA-1 of | HomeDomain-Library/SMS/sms.db |
| App | Messages |
| 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 Messages screen. Guide: Export iPhone messages |
sms.db is where the Messages app keeps conversations: the text of each message, who it was with, when it was sent or received, whether it was read, and which attachments go with it. Group chats are in it too.
The attachments themselves aren't inside it. Photos, videos and voice messages sent in Messages are separate files in the backup, under Library/SMS/Attachments/ in MediaDomain, and the attachment table names each one.
FaceTime calls started from a Messages conversation also leave a row in sms.db, and OpenExtract's Calls screen adds those to the call history.
iOS 16 gave Messages a Recently Deleted folder, and sms.db gained tables for it: the iOS 16.1.2 and 17.3 backups have recoverable_message_part and chat_recoverable_message_join, which the older ones don't.
message.text: The message text. Some messages keep it only in attributedBody, a binary blob next to it.message.date: When it was sent or received: time since 1 January 2001 (UTC), in nanoseconds on newer iOS versions and seconds on older ones.message.is_from_me: 1 if the phone's owner sent it.message.handle_id: The other person's row in handle.handle.id: The other person's phone number or email address.attachment.filename: Where the attachment was on the phone, under ~/Library/SMS/Attachments/.iOS 13.3.1 has 14 tables:
_SqliteDatabaseProperties, attachment, chat, chat_handle_join, chat_message_join, deleted_messages, handle, kvtable, message, message_attachment_join, message_processing_task, sync_deleted_attachments, sync_deleted_chats, sync_deleted_messages
Then, version by version:
chat_recoverable_message_join, recoverable_message_part, unsynced_removed_recoverable_messages.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 Messages. People and Timeline use it too. OpenExtract shows every conversation with its photos and attachments, and saves them as PDF, HTML, CSV or text. It can also recover deleted messages that are still in the file. Step by step: Export iPhone messages.
By hand. In a backup that isn't encrypted, 3d/3d0d7e5fb2ce288813306e4d4636395e047a3d28 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