Take the 2-minute tour ×
Android Enthusiasts Stack Exchange is a question and answer site for enthusiasts and power users of the Android operating system. It's 100% free, no registration required.

Where in the file system are SMS messages stored?

I'm using ES File Explorer to browse around but can't seem to find this - is it on the phone or the SD, and where?

I have an HTC Wildfire but I would imagine it doesn't vary hugely from vendor to vendor (although I am an iOS developer who knows little about Android).

share|improve this question

3 Answers 3

up vote 21 down vote accepted

See here: http://stackoverflow.com/questions/4809874/how-to-access-the-sms-storage-on-android

The gist is that SMS/MMS are residing in databases on the phone and the answer to the question contains the link to this tutorial.

The location of the database might vary from phone to phone, but you can look it up with this command via adb (you need to be root to find it because it's in the protected storage area):

find / -name "*mmssms*"

On my device (Samsung Galaxy S) these databases turned up:

./dbdata/databases/com.android.providers.telephony/mmssms.db
./data/data/com.jb.gosms/databases/gommssms.db

The first one being the native db and the second one is by the sms app I'm using.

share|improve this answer
    
could you explain how it's stored... it looks like XML? also where is it? - I'm not talking from a coding point of view as I do not know anything about android development. –  Alex Coplan Dec 13 '11 at 23:44
2  
It's an sqlite database. You can look at it with an sqlite viewer - which operating system do you use? –  masterjo Dec 13 '11 at 23:50
    
And you have to be root to access the db - going to add that to the answer above. –  masterjo Dec 13 '11 at 23:50
    
Here's a platform independent sqlite viewer if you want to look at those files: http://sourceforge.net/projects/sqlitebrowser/ –  masterjo Dec 14 '11 at 0:24
1  
@masterjo: SQLite Database Browser hasn't been developed since 2009 and it couldn't show anything from the .db file when I tried it today. Here's another SQLite browser that worked - sqlitestudio.one.pl –  Dan Dascalescu Oct 17 '13 at 7:17

Note that, (at least) as of Kitkat, the default path changed from: /data/data/com.android.providers/telephony/databases/mmssms.db to /data/data/com.android.providers.telephony/databases/mmssms.db

share|improve this answer

Here's a helpful piece of info also.

This is the absolute path to SMS and MMS DB on most android devices:

/data/data/com.android.providers/telephony/databases/mmssms.db

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.