5,814,720 Members 52,478 Now Online
XDA Developers Android and Mobile Development Forum

[Guide]How to merge multiple mmssms.db into one file .

Tip us?
Senior Member - OP
Thanks Meter 33
Posts: 213
Join Date: May 2012
Lightbulb [Guide]How to merge multiple mmssms.db into one file .

Hiya there.
Im kinda new here in this forum so greet me well . ^^
Well I juz finished searching and figured out . I would like to share how to combine multiple mmssms.db (Message Data) file into one file where the file located on /data/data/.com.android.providers/databases

So what we gonna need is these 2 file .

*[TOOL] yaffs extractor, mmssms.db & contacts2.db converter
*SMS Backup & Restore

1. Extract yaffs extractor, mmssms.db & contacts2.db converter to you main drive. (Like mine ish C:\ )

So theres the file that you extracted located open it up and see wether all the file extracted is same as in the pic.

2. Next we have to put the *.db file in the yaffs extractor, mmssms.db & contacts2.db converter folder,I have 2 backup *.db so I made 2 folder(Message1 and Message2) which is each mmssms.db file in each folder.

3. So now were gonna convert the *.db file into *.xml .
Run cmd and put this command . (Convert all your backup *.db cause we gonna need it , depends how many you have )

cd c:\yaffs-mmssmsdb-calls-extractor

extract -s Message1\mmssms.db


Juz put anyname you like as long you put .xml along with the name .

And the converted file will be in the same folder yaffs extractor, mmssms.db & contacts2.db converter in the *.xml format . We gonna need those files soon just let it there .Now we're almost done , going to next step.

Next, install SMS Backup & Restore on your phone . Put all converted *.xml file in the /sdcard/SMSBackupRestore/

Now open up SMS Backup&Restore that you have install on your sdcard.

Wait till the Apps pop out and Click on Restore , you will see the *.xml file that you have copied to the /sdcard/SMSBackupRestore/ .

Now, Click on each of *.xml and restore every single of your backup message file.

And the Results ..

The Failed might be due to corrupted or unread message while backup.
Thats it ! You're done, you have merged all of you mmssms.db into one file.
Goodluck on trying , glad to help and share. ^^
The Following 10 Users Say Thank You to Dwama For This Useful Post: [ Click to Expand ]
Thanks Meter 3
Posts: 36
Join Date: Aug 2012
Default Perfect

This has been a real life-saver for me. Works perfectly. Many many thanks for sharing.
Senior Member
Thanks Meter 54
Posts: 155
Join Date: Nov 2010
Thanks a million

This is really a lifesaver,
The screen of my phone died, so all I had access to was adb and through this guide I was able to restore messages.
I did not have to merge, but it worked the same.

Thanks once again
Junior Member
Thanks Meter 0
Posts: 1
Join Date: Aug 2009
Default Fantastic!

Worked like a charm! I've been different methods all week, trying to copy the old mmssms.db to the database directory, and everything failed. But not this!

Tank you!
Junior Member
Thanks Meter 3
Posts: 3
Join Date: Dec 2012
agan TS
so what if we want to merge multiple contacts2.db? is it the same way? i am pretty sure it's not, the command would be different right?
Junior Member
Thanks Meter 6
Posts: 21
Join Date: Jul 2012
thank you for this tutorial, very helpful
(Last edited by uscpsycho; 2nd March 2014 at 02:18 AM.)
Senior Member
Thanks Meter 36
Posts: 201
Join Date: Mar 2011
Does this merge MMS messages as well? Or does it only merge SMS text messages?

I know SMS Backup & Restore typically doesn't restore MMS so I'm thinking this method won't work for MMS.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes