Post Reply
Lightbulb

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

31st May 2012, 01:34 PM   |  #1  
OP Senior Member
Thanks Meter: 33
 
213 posts
Join Date:Joined: May 2012
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 )

Quote:

cd c:\yaffs-mmssmsdb-calls-extractor

extract -s Message1\mmssms.db

Message1.xml

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: [ View ]
1st September 2012, 04:28 PM   |  #2  
Member
Thanks Meter: 3
 
36 posts
Join Date:Joined: Aug 2012
Perfect
This has been a real life-saver for me. Works perfectly. Many many thanks for sharing.
15th October 2012, 10:16 PM   |  #3  
Senior Member
Thanks Meter: 54
 
155 posts
Join Date:Joined: 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
23rd May 2013, 08:39 AM   |  #4  
Junior Member
Thanks Meter: 0
 
1 posts
Join Date:Joined: Aug 2009
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!
17th June 2013, 11:52 AM   |  #5  
Junior Member
Thanks Meter: 3
 
3 posts
Join Date:Joined: 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?
30th November 2013, 09:40 AM   |  #6  
Junior Member
Thanks Meter: 6
 
21 posts
Join Date:Joined: Jul 2012
thank you for this tutorial, very helpful
2nd March 2014, 02:14 AM   |  #7  
Senior Member
Thanks Meter: 36
 
201 posts
Join Date:Joined: 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.
Last edited by uscpsycho; 2nd March 2014 at 02:18 AM.

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

Advanced Search
Display Modes


Top Threads in Android General by ThreadRank