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

Search This thread
By:
Advanced…
D

Dwama

Senior Member
May 27, 2012
255
52
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:\ )


tuto1.png



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


tuto9.png


tuto7.png





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.

tuto8.png




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

Message1.xml

Juz put anyname you like as long you put .xml along with the name .
Click to expand...
Click to collapse


tuto3.png


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.

tuto4.png



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

SC20120531-193344.png


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

SC20120531-193357.png


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

SC20120531-193426.png


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

SC20120531-193454.png


SC20120531-195908.png
SC20120531-195908.png



SC20120531-200054.png



And the Results ..

SC20120531-200503-2.png
SC20120531-201734.png


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. ^^
 
  • Like
Reactions: Marucins, farshad7, frankygoes and 20 others
O

oldvices

Member
Aug 26, 2012
36
3
Perfect

This has been a real life-saver for me. Works perfectly. Many many thanks for sharing.
 
M

m0d

Senior Member
Nov 3, 2010
1,096
436
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
 
T

TotallyNuts

New member
Aug 26, 2009
1
0
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!
 
C

cupenk19th

New member
Dec 17, 2012
3
3
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?
 
U

uscpsycho

Senior Member
Mar 25, 2011
258
49
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:
G

georg3003

Member
Jul 6, 2013
37
0
SMS all Data with Delivered Date and Hour Backup/Merge/Restore

Hello,
I have a problem with all these sms backup programs.

I wish to get all SMS Data, like sent Date/Hour Text etc.

But also I wish to save the Delivered Time.

Does somebody know a Program the can list these Data and/or Backup this Data.

I could Backup nearly everything except the Delivery_Date and Delivery_Status.

Can somebody tell me how I can import/transfer/merge the SMS Data from my Note2 and Note4 to my new S7edge

Thanks for your help
George
 
Last edited:
M

moorphix

New member
Apr 22, 2011
4
0
I try do this but i have some error :



extract : The term 'extract' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a p
ath was included, verify that the path is correct and try again.
At line:1 char:1
+ extract -s Message1\mmssms.db
+ ~~~~~~~
+ CategoryInfo : ObjectNotFound: (extract:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException


Suggestion [3,General]: The command extract was not found, but does exist in the current location. Windows PowerShell does not load commands from the current location by default. If you trust this command, instead type: ".\extract". See "get-help about_Command_Precedence" for more details.
PS C:\yaffs-mmssmsdb-calls-extractor>
 
You must log in or register to reply here.

Similar threads

S
[GUIDE] [HOW-TO] Install Adobe Flash Player on Android 4.1 Jelly Bean/ Android 4.4
Replies
1K
Views
3M
dasdsad1
dasdsad1
brandall
[TUT] The Ultimate Noob/Beginners Guide to Tasker
Replies
8K
Views
2M
S
spicediablo
v7
  • Poll
✭[GUIDE][26-07-2016]Extreme Battery Life Thread(Greenify+Amplify+Power Nap)✭
Replies
14K
Views
2M
varunpilankar
varunpilankar
lokeshsaini94
  • Locked
[CLOSED] [GUIDE] [how to] CREATE OWN ROM [FOR ANY ANDROID DEVICE] [FOR N00B] [EASIEST METHODS]
Replies
1K
Views
1M
Oswald Boelcke
Oswald Boelcke
Unjustified Dev
[GUIDE] New Root Method for LG Devices
Replies
1K
Views
1M
Azaze666
Azaze666

Top Liked Posts

24 Hours All time
  • There are no posts matching your filters.
  • 23
    D
    Dwama
    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:\ )


    tuto1.png



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


    tuto9.png


    tuto7.png





    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.

    tuto8.png




    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

    Message1.xml

    Juz put anyname you like as long you put .xml along with the name .
    Click to expand...
    Click to collapse


    tuto3.png


    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.

    tuto4.png



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

    SC20120531-193344.png


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

    SC20120531-193357.png


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

    SC20120531-193426.png


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

    SC20120531-193454.png


    SC20120531-195908.png
    SC20120531-195908.png



    SC20120531-200054.png



    And the Results ..

    SC20120531-200503-2.png
    SC20120531-201734.png


    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. ^^
    View

New posts