How to Access and Read the iPhone SMS Text Message Backup Files
If you want to access and read the iPhone SMS backup file, you’ve come to the right place. We’ll walk you through how to access this file, which contains all of an iPhones text messages, SMS, MMS, and iMessages, and also show you how to read the files contents. This trick works for both Windows OS X and Windows.
iPhone SMS Backup File Location on Mac
First things first, let’s get to the backup file which contains the texts and imessages. Your SMS/text messages are backed up and buried deep within the standard iPhone backup location located at:
You are then looking for a randomly generated filename that is really long and full of hexadecimal, like: 9182749a9879a8798a798e98798798f9879877c98798. There is usually just one directory in here unless you have multiple devices synced to your computer.
Open that directory and look for the following filename:
This file will sometimes have a .mddata or .mdbackup extension, though if you don’t have extensions enabled you may not see it. That doesn’t matter much, just get access to this file.
How to Read the iPhone SMS Backup File
Once you have located this file, make a copy of it to the desktop or some place easier to access. This will also serve as a backup of the imessage/sms database, which is important in case you somehow mess something up, you won’t compromise the original message backup database. You may notice that this file is actually a SQLite database, and the tables can be read and queried like any other database using SQL commands. If you have no SQL experience, it’s not too complicated, but first you will need to download an application that lets you open and read SQLite database files, in the screenshot below I used MesaSQLite for Mac OS X, it’s currently in beta and free to download. There are plenty of SQLite apps for Windows too if you need one.
Once you have downloaded your SQLite management app, launch the program and then open up the aforementioned SMS database file (yes, the 3d0d7e5fb2ce288813306e4d4636395e047a3d28 file) within the SQL app to see all your text messages:
Now the best thing about this being a SQLite database is that it can be queried against easily, so if you’re looking for text messages just from a specific number, specify that in the query. For example, in MesaSQLite you just select this under “Table Content” then Message > Address > Contains > 1888
Replace 1888 with any other number prefix. Once you see the messages you want, just double click on them to be able to read the text message stored within the backup file that is now opened in the SQL manager:
And yes, you can change the content of text messages through these backup files too!
It’s worth mentioning that you can also just drag the database file into a text editor like TextWrangler, but it’ll completely decimate the appearance of the file and it’s very hard to read. If you are looking for a very quick and dirty way of searching for an exact message though and you know the content, it works, but it’s not pretty.
iPhone SMS backup file location in Windows
Since there are multiple versions of Windows, here are the possible locations of the iPhone backup file:
%APPDATA% = C:\Documents and Settings\[your username]\Application Data\
%APPDATA% = C:\Users\[your username]\AppData\Roaming
Windows 7 & Windows 8:
Everything else is the same as above, look for the same file(s), and you’ll need to open them in a SQLite editor.