[GUIDE] Merge Multiple Whatsapp Backup File Into One (No Root Required)

[sieger007]

I could manage to merge to an encrypted databases .
just give a brief two liner for my situation.
I had a situation where my db crypt files were not available and all I had wss the internal data msgstore.db located at
/data/data/com.WhatsApp/databases

the original file was 780mb I will just call it 780mb.db
when WhatsApp did a restore from Cloud something wrong happened and and I am missing about six months of data and the current
msgstore .db is just 380mb. call it 380mb
db

so the latest msgstore.db file is about 400 MB short and this maps to more than 6 months of chat history which is missing currently when WhatsApp messages are restored.

I followed the procedure to merge the two database files I have not followed any decrypting procedure because this is the un encrypted file
this included running the update on the New database files ( in sqllite database editor ) so the last message of the old one is in immediate precedence to messages in the new one.
new merged.db fiile was copied
to

/data/data/com.WhatsApp/databases

WhatsApp app was stopped and cache was flushed

on restarting it gave me a message there is a problem with your chat history don't worry we will restore it that is it refused to read the merged.db ( now.msgstore.db ) and it's simply renamed it as
now , msgstore.db. corrupt

now I repeated the same procedure in airplane mode and it it would read that file I could see my messages but WhatsApp would immediately crash
here is the crash information
it says database malformed image but I can open this database easily in my PC sqllite browser

I have tried this several times and I have on able to incorporate the data that is there in 780mb.db file to the current msgstore.db

any moolah on this ?

 

[SEETIW]

I have old.db, new.db and merjapp stored in a folder called Merge on the desktop. However, I get the following response:-

C:\Users\simon>cd desktop

C:\Users\simon\Desktop>cd merge

C:\Users\simon\Desktop\Merge>java.exe -jar merjapp.jar -old old.db -new new.db
-E- Database old.db cannot be found!

Anyone any idea why this is so?

 

[Chester89]

Whatsapp don't found merged db

Hi Guys,
I have finally got my merged db, than I renamed "msgstore.db", then I copied it in "/storage/emulated/0/WhatsApp/Databases/" but when I'm going to reinstall Whatsapp (Ver. 2.19.230) the app don't found any backup.
I think the problem is that my merged db is not encrypted in crypt12.
I read in previous messages to try to use Yowhatsapp, which should be able to restore an unencrypted db and then to create a crypt12 backup from it.
My phone is OnePlus X (not rooted), can anyone help me please?
Thanks.

 

[silver-knight]

Restoring deleted chats

I have a backup of a DB file containing chats I deleted a long time ago, memories I didn't want infront of me at the time, but now I wish to restore.
Apparently nothing really gets deleted as the messages are still included in the DB forever, but are not visible within the WhatsApp app.
I tried exploring the DB file with SQL but couldn't find anything to hint about what makes a message (or chat) visible or not.

Anyone has tips as to how to restore a chat I deleted?
(to clarify I decrypted the DB and have full access to it - so I'm passed that phase)

 

[115irfan]

Hey I'm getting an error in command like -
"'java.exe' is not recognized as an internal or external command,
operable program or batch file."

Please tell me where I'm wrong?

 

[timenewroman]

Hey I'm getting an error in command like -
"'java.exe' is not recognized as an internal or external command,
operable program or batch file."

Please tell me where I'm wrong?

You need to install Java first.

 

[borgqueenx]

Hello. I have restored a iphone backup to android and now see months later that it didnt import the media files.
So how can i import iphone whatsapp media files from the media folder into my current android? (so no replacing or new messages)

Thanks!

 

[Sourabh Gharde]

Can I merge backups from 2 different devices?
I used WhatsApp with the same no when I broke my old android and made a fresh start in a new device with the same number. I have repaired my old device and now I want to merge both backups.

 

[ykkfive]

Can I merge backups from 2 different devices?
I used WhatsApp with the same no when I broke my old android and made a fresh start in a new device with the same number. I have repaired my old device and now I want to merge both backups.

i am facing this problem too since i used to have 2 devices running whatsapp with one single phone number. here's what i am going to do:

##### NOTE for dbs containing different msgs from different devices only (using 2 devices simultaneously with one phone number, eg device a in day time and device b at night at home), not for merging 2 old dbs (eg before 2018 and after 2018) into 1

# let db from device a be a.db, and b.db from device b
since they contains almost same group of people but with different ids , i have to do something to sync them first
aim: to merge 2 db into one with unique people and sort all merged records by date time (i have done a test before , sorted by date but without rewriting the msg id, thus making newer msgs appeared in between the old msgs )

- increment the people id,msg id, attchment id etc say by 30000 from b.db in all tables
- replace people ids from a.db for all tables ib b.db
- import msg records from a.db and b.db to a new c.db, just play it safe
- now i should have a table with all msgs from a.db and b.db in c.db
- sort all records in c.db by date time to rebuild all the records in sequesnce
- reapply a new msg id to all msg records according to the date time, and replace all old msg with these new ids, probably needs to subtract 30000 added above


i believe the above steps will do but worrying about the attachments etc, and there are many unused tables

what do you think?



edit sorry, may be this is not useful for you, i misread your message. what you need is something like a concat

 

[johnnydoughnut]

Quoted texts are wrong?

Managed to merge the 2 databases but noticed the chats where I quoted someone were wrong. The normal texts are okay it's just that the quoted message is like a message from about 2 years ago. Anyone know how to fix this?

 

[ykkfive]

I'm having trouble merging the new and old db. A java error is thrown:

C:\Users\JK\Desktop\merge>java.exe -jar merjapp.jar -old old.db -new new.db
Exception in thread "main" java.lang.SecurityException: Prohibited package name:
 java.sql
        at java.base/java.lang.ClassLoader.preDefineClass(Unknown Source)
        at java.base/java.lang.ClassLoader.defineClass(Unknown Source)
        at java.base/java.security.SecureClassLoader.defineClass(Unknown Source)

        at java.base/java.net.URLClassLoader.defineClass(Unknown Source)
        at java.base/java.net.URLClassLoader.access$100(Unknown Source)
        at java.base/java.net.URLClassLoader$1.run(Unknown Source)
        at java.base/java.net.URLClassLoader$1.run(Unknown Source)
        at java.base/java.security.AccessController.doPrivileged(Native Method)
        at java.base/java.net.URLClassLoader.findClass(Unknown Source)
        at java.base/java.lang.ClassLoader.loadClass(Unknown Source)
        at java.base/java.lang.ClassLoader.loadClass(Unknown Source)
        at java.base/java.lang.Class.forName0(Native Method)
        at java.base/java.lang.Class.forName(Unknown Source)
        at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoa
der.java:56)

C:\Users\JK\Desktop\merge>java -version
java version "10.0.2" 2018-07-17
Java(TM) SE Runtime Environment 18.3 (build 10.0.2+13)
Java HotSpot(TM) 64-Bit Server VM 18.3 (build 10.0.2+13, mixed mode)

any ideas how to solve this problem?

incorrect java version
try 1.8x

---------- Post added at 03:03 ---------- Previous post was at 02:56 ----------

But i have no idea who can I merge two & three whatsapp backup file in my new device
Pls help me
I will pay charges for it
Amit dhanuka
Fatehapur shekawati
Sikar rajasthan
India
Mobile:-9571137171
Mail id:-amitdhanuka1992@gmail.com

I was successfully able to do all the above steps and restore my merge whatsapp backup via YoWhatsApp. But, I noticed an issue with the merged msgstore.db file. After restoring the chats, they were not organized properly. Chats from different people and groups were merged randomly. For instance; replies to messages in group 'A' were showing in chat of person 'B and so on'.

Maybe this can be a sync issue or an indexing issue. I can see media files have been carried forward correctly and time stamps on the older chats (old backup) are correct but then there are no time stamps on new chats (new backup)

I checked the _id in chats and there are no overlapping ID's on anyone.

Is there a way to fix these chats or the backup file by any kind of tool.

Managed to merge the 2 databases but noticed the chats where I quoted someone were wrong. The normal texts are okay it's just that the quoted message is like a message from about 2 years ago. Anyone know how to fix this?

i had problems merging 2 dbs, so i read the sources and performed the steps manually. i found there are a few bugs, and seems that some tables, including chat_list were left untouched or not updated completely/properly (it's still in beta). may be that's why you have chats history/quoted msgs problems

ps i am trying to merge 2 dbs manually but facing some problems but i think i can handle them sooner or later. however my current solution is solely based on my dbs only and thus not a universal solution since there are too many tables involved and most of them are empty, at least for me. what i mean by it's not a universal solution because, eg if you have group charts but i don, then my solution wont work for you since i don have such entries in my db and therfore i have no way to trace them with my own db atm. also, for my dbs the entries are not in sequential order but are separated across the 2 dbs since i was using my phone at day time but my tablet at night . so you can imagine that one conversation may be stored in 2 dbs and i have to deal with that also

 

[d33pxd]

Is it possible to merge an older backup from my previous rooted android phone (key file is available) with a newer backup from my present android phone (key file also available). The phone number is the same.

And just out of interest: is the key file the same on different phones with the same number or depends the key file on the phone (or both?)

 

[selemine]

If i have the current whatsapp folder with a lot of msgstore*db.crypt12 and the MediaFolder and an outdated backup of the /data/data/ folder with the key file in it, would it work if i just copied the msg store. crypt12 and the media folder back to get a working up to date state of the conversations or are the files more interlinked with each other?

 

[sieger007]

I am not sure if I post at the right place but I would like to share this to everyone as I understand how hard it is to find a solution that works. With this guide, you will get to keep the original WhatsApp .....[/SIZE]

Hi Wanted to know if this still works.
I tried it long ago with 2 UN encrypted msgstore.db files but the new file wasn't liked by WhatsApp. It gave me error. Malformed database error and whatsapp crashed.
Q - What makes whatsapp think a certain database is good vs malformed. Some kind of key needed ? and does it change from phone to phone ? Different ROM instance installs on the same phone ?
Any idea

 

[gramouk]

Hello,
Does this program even work on win10? When I run it nothing happens on my phone and the extracted folder stays empty even after the terminal work....
My phone is on LOS.
Might give it a try on ubuntu

 

[secondchild]

The instructions by DLz88 in post 17 are still working, as long as your phone is not running on Android 7 or higher.
Phase 2 can (or actually should be skipped). Enough with phase 1 and 3. merjapp is handling the renumbering of the chats. However, that is if you don't have overlapping dates of your chats between your old and new backup. If dates are overlapping you might need to do some magic in SQlite browser. (For me that was not any issue though).
For phase 1 - decryption: Use a phone with Android 6 or less. 7 or 8 does not seem to work. The problem is when installing the legacy 2.11 which will not be allowed in Android 7 or higher. So look deep into your drawers, or buy an old Z1 compact (which is the phone I found in my drawer)
In phase 3 the correct command line is java.exe -jar merjapp.jar -old old.db -new new.db
(it was missing a space after merjapp.jar)

Afterwards you might need to have a rooted phone and follow the instructions in post 37
Or, if you have an old phone like me, just do a factory reset (do it as clean as you can. I used Xperia Companion on my PC which makes it totally clean installation).

For Media, just copy the two media folders that you have into a new folder. If it asks for replacing files, then just check what files it is (normally it is the .nomedia files).

Oh, and just so you know. The new version of whatsapp does not allow you to backup from a local storage on your phone. You need an older version of whatsapp for that. Here is a link to 2.17.422 that will work.

I saw another post where someone confirmed that this solved their problem. However, WhatsApp 2.17.422 no longer works (it gives the well known "adjust date and time" error that you can't move past). I also tried other WhatsApp versions with release dates prior to your post and had the same issue. So, are there any other options for restoring my merged database on an unrooted phone? It took ages to successfully extract the backup file from one of the phones due to various errors but I got there in the end and had a successful merge (all thanks to this forum). It would be a shame not to be able to use it.

 

[alexbit]

Goodmorning everyone.

I have a problem while using the tutorial

I have a Huawei Nova 5T with android in version 10 that broke the display a few weeks ago.

Now I have replaced the display and so I have back again the access to the smartphone and I would like to transfer and merge the whatsapp db on that phone with the other one on the phone that I'm since I broke the Nova .
Well ... I downloaded and installed WhatsApp-Key (version 4.7) on my laptop with Windows 10 home. I launched it and I've connected the old phone that but the program gave me this error:

Installing legacy WhatsApp 2.11.431
3 KB/s (251 bytes in 0.062s)
Error: Failed to parse APK file: /data/local/tmp/LegacyWhatsApp.apk

Exception occurred while executing:
java.lang.IllegalArgumentException: Error: Failed to parse APK file: /data/local/tmp/LegacyWhatsApp.apk
        at com.android.server.pm.PackageManagerShellCommand.setParamsSize(PackageManagerShellCommand.java:484)
        at com.android.server.pm.PackageManagerShellCommand.runInstall(PackageManagerShellCommand.java:1073)
        at com.android.server.pm.PackageManagerShellCommand.onCommand(PackageManagerShellCommand.java:177)
        at android.os.ShellCommand.exec(ShellCommand.java:104)
        at com.android.server.pm.PackageManagerService.onShellCommand(PackageManagerService.java:23851)
        at android.os.Binder.shellCommand(Binder.java:888)
        at android.os.Binder.onTransact(Binder.java:772)
        at android.content.pm.IPackageManager$Stub.onTransact(IPackageManager.java:4879)
        at com.android.server.pm.PackageManagerService.onTransact(PackageManagerService.java:4538)
        at com.android.server.pm.HwPackageManagerService.onTransact(HwPackageManagerService.java:505)
        at android.os.Binder.execTransactInternal(Binder.java:1028)
        at android.os.Binder.execTransact(Binder.java:1001)
Caused by: android.content.pm.PackageParser$PackageParserException: Failed to parse /data/local/tmp/LegacyWhatsApp.apk
        at android.content.pm.PackageParser.parseApkLiteInner(PackageParser.java:1854)
        at android.content.pm.PackageParser.parseApkLite(PackageParser.java:1839)
        at com.android.server.pm.PackageManagerShellCommand.setParamsSize(PackageManagerShellCommand.java:477)
        ... 11 more
Install complete

Now unlock your device and confirm the backup operation.

Please enter your backup password (leave blank for none) and press Enter:

Exception in thread "main" java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:58)
Caused by: java.lang.RuntimeException: java.lang.NumberFormatException: For input string: ""
        at org.nick.abe.AndroidBackup.extractAsTar(AndroidBackup.java:420)
        at org.nick.abe.Main.main(Main.java:128)
        ... 5 more
Caused by: java.lang.NumberFormatException: For input string: ""
        at java.lang.NumberFormatException.forInputString(Unknown Source)
        at java.lang.Integer.parseInt(Unknown Source)
        at java.lang.Integer.parseInt(Unknown Source)
        at org.nick.abe.AndroidBackup.extractAsTar(AndroidBackup.java:280)
        ... 6 more
bin\tar.exe: Cannot open tmp\whatsapp.tar: No such file or directory
bin\tar.exe: Error is not recoverable: exiting now
bin\tar.exe: Cannot open tmp\whatsapp.tar: No such file or directory
bin\tar.exe: Error is not recoverable: exiting now
bin\tar.exe: Cannot open tmp\whatsapp.tar: No such file or directory
bin\tar.exe: Error is not recoverable: exiting now
bin\tar.exe: Cannot open tmp\whatsapp.tar: No such file or directory
bin\tar.exe: Error is not recoverable: exiting now
bin\tar.exe: Cannot open tmp\whatsapp.tar: No such file or directory
bin\tar.exe: Error is not recoverable: exiting now

Cleaning up temporary files ...

File eliminato - C:\Users\aless\Desktop\WhatsApp-Key-DB-Extractor-master\tmp\whatsapp.ab
File eliminato - C:\Users\aless\Desktop\WhatsApp-Key-DB-Extractor-master\tmp\waplen.txt
File eliminato - C:\Users\aless\Desktop\WhatsApp-Key-DB-Extractor-master\tmp\sdpath.txt
File eliminato - C:\Users\aless\Desktop\WhatsApp-Key-DB-Extractor-master\tmp\wapath.txt
File eliminato - C:\Users\aless\Desktop\WhatsApp-Key-DB-Extractor-master\tmp\wapver.txt
File eliminato - C:\Users\aless\Desktop\WhatsApp-Key-DB-Extractor-master\tmp\sdkver.txt

Done

Restoring WhatsApp 2.20.157

Could someone help me?

 

[Fish_scale]

Could you share your experience with the rest of us?

I am just about thinking of merging two what's up databases.

And it seems like the tutorial from 2016 will not work without a million errors due to version changes.

 

[alexbit]

Could you share your experience with the rest of us?

I am just about thinking of merging two what's up databases.

And it seems like the tutorial from 2016 will not work without a million errors due to version changes.

Hi!
NO experience till now... I've started follow the guide but I immediately got the above error... then all the rest of the process fail.
I've also post my question here: https://xdaforums.com/showthread.php?t=2770982&page=60#post82917051.
Hopeful to get any help. It's really very annoing that it's so hard to merge whatsaspp databases!
Please share any solutions...

 

[Black Swift]

Hello!!
so ,my phone battery died, and i had to wait a couple of monts before i could get a new battery and fix it, meanwhile i started using a new cheaper phone, but unfortunately the backup didnt worked and i lost all my chats.

but today i went back to my old phone and found out all the chats are rigth there, didnt lose anyting, but dont have all the chats i had on my cheaper phone,

is there any way to restore the chats from the cheap phone to the old one whitout losing anyting? like merrging the backups or someting?

or simply by runing a restore of the google backup i get everyting witout losing anyting??