Welcome to XDA

Search to go directly to your device's forum

Register an account

Unlock full posting privileges

Ask a question

No registration required
Post Reply

Where is MMS saved?

OP OminousPrime

29th November 2008, 09:06 PM   |  #1  
OminousPrime's Avatar
OP Member
MO USA
Thanks Meter: 0
 
59 posts
Join Date:Joined: May 2008
More
I'm sure someone has figured this out.
Where in the file system are the pictures I receive via mms saved?
I'm sure they have to be somewhere, there has to be a way to get them without the fwd to pc email / attach image to new email / email back to phone trick.

Bonus points, I deleted a thread - can I still find those images somewhere in the file system and restore them?
29th November 2008, 09:29 PM   |  #2  
JesusFreke's Avatar
Recognized Developer
Flag Dallas
Thanks Meter: 41
 
736 posts
Join Date:Joined: Oct 2008
I believe they're stored in a sqlite3 database, so it's not as easy as just copying a file.

It looks like this is the database:
/data/data/com.android.providers.telephony/databases/mmssms.db

I don't have any mms/sms messages atm (recently wiped phone), so I don't have any data to look at in the database.

If you want, give me an IM or PM and I'll give you my cell number so you can send me an sms with a pic, so I can figure out how to extract it from the database
30th November 2008, 12:10 AM   |  #3  
Senior Member
Thanks Meter: 0
 
269 posts
Join Date:Joined: May 2008
More
i dont think its in the database: its the same size no matter how many messages there is
30th November 2008, 12:37 AM   |  #4  
JesusFreke's Avatar
Recognized Developer
Flag Dallas
Thanks Meter: 41
 
736 posts
Join Date:Joined: Oct 2008
Found it. The text and attachments are saved in /data/data/com.android.providers.telephony/app_parts

They are stored in files named something like "PART_1228000671287", with no extension.

To see what type of files they are, you can run this command on the phone (assuming you have RC30 v1.2).

sqlite3 -header /data/data/com.android.providers.telephony/databases/mmssms.db "SELECT _data, ct FROM part;"

The first column is the full path to the file, and the 2nd column is the mime type of the file
Last edited by JesusFreke; 30th November 2008 at 12:39 AM.
30th November 2008, 05:48 AM   |  #5  
OminousPrime's Avatar
OP Member
MO USA
Thanks Meter: 0
 
59 posts
Join Date:Joined: May 2008
More
Awesome, good work Android Master JesusFreke.
too bad I have the factory RC30
(why oh why did I hit the update button that night?)*

but that's cool to know that they can be found.
Now we just need someone to apply that knowledge into making a SaveImage option appear in the MMS thread.





* on an unrelated note I need to put in another thread: when RC29 came I noticed the camera worked like 5 times better. I was even able to snap pics of the kids on the swings and they came out clear, when RC30 came it was back to blurriness as usual.
30th November 2008, 08:48 PM   |  #6  
Member
Thanks Meter: 1
 
69 posts
Join Date:Joined: May 2006
More
Quote:
Originally Posted by JesusFreke

Found it. The text and attachments are saved in /data/data/com.android.providers.telephony/app_parts

They are stored in files named something like "PART_1228000671287", with no extension.

To see what type of files they are, you can run this command on the phone (assuming you have RC30 v1.2).

sqlite3 -header /data/data/com.android.providers.telephony/databases/mmssms.db "SELECT _data, ct FROM part;"

The first column is the full path to the file, and the 2nd column is the mime type of the file

Would it be possible to write a program that would automatically extract the imgs/vids from that path and put them on the sd card with the correct file extension?
30th November 2008, 09:11 PM   |  #7  
JesusFreke's Avatar
Recognized Developer
Flag Dallas
Thanks Meter: 41
 
736 posts
Join Date:Joined: Oct 2008
Sure. It would certainly be possible for rooted phones. I'm not sure for non-rooted phones.
Last edited by JesusFreke; 30th November 2008 at 09:14 PM.
30th November 2008, 09:21 PM   |  #8  
Member
Thanks Meter: 1
 
69 posts
Join Date:Joined: May 2006
More
I should have added on rooted phones on my first post.
Guess i should get off my butt and start messing around with some code.
I'm kinda leery about messing with root comands.
1st December 2008, 08:36 AM   |  #9  
Retired Moderator
Thanks Meter: 10
 
1,271 posts
Join Date:Joined: Mar 2008
More
I think it would be possible for rooted as well. Can't applications have message privys so they can read messages? if they can read them can't they save the data?

Post Reply Subscribe to Thread
Previous Thread Next Thread
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes