[APP][2.1+] WhatCrypt - WhatsApp Database Crypt Tool - Android Apps and Games

** Version 2.4 Updated October 2016 **
WhatCrypt - WhatsApp Crypt Tool
WhatCrypt is a decryption and encryption tool for backed up WhatsApp databases.
Usage Examples:
Decrypt legacy .crypt and .crypt5-12 files to .db files.
Encrypt .db files to legacy .crypt files.
Original encrypted files will not be moved or deleted. If you get any Decryption Failed messages
then it means that either the encrypted database is corrupt or you have supplied the incorrect
account name or key file. Root access will be required to obtain your crypt key (crypt 6>12) or Android 4.0+.
HOW TO GET YOUR CRYPT KEY NON-ROOT
Download Here: http://whatcrypt.com/com.whatcrypt.apk
Version History
Version 1.0 - Initial release.
Version 1.1 - Added disable minions (sounds) option.
Version 1.2 - Added support for empty or null accounts with crypt5.
Version 1.3 - Added support for crypt6.
Version 1.4 - Added root key copier.
Version 1.5 - Added support for crypt7.
Version 1.6 - Removed minions (sounds).
Version 1.7 - Added decrypt / encrypt progress bar.
Version 1.8 - Added support for crypt8.
Version 1.9 - Fixed crypt8 support on latest WhatsApp version.
Version 2.0 - Added support for crypt9-12.
Version 2.1 - Fixed a bug effecting some decrypts of crypt12.
Version 2.2 - Fixed malformed database issue and added support for Android Marshmallow.
Version 2.3 - Added native root methods and dynamic support for crypt10-12 (variation b).
Version 2.4 - Fixed SU issue, added crypt12 variations E/F and support for Android Nougat.
Copyright / Distribution
This application is the proprietary copyright of whatcrypt.com. In the spirit of education, we have no issues with anyone reverse engineering the apk in private. You are however expressly forbidden from posting any links to decompiled sources or distributing the binary itself or any modified binaries. You may of course share the official download link.

does it work/??
Does this really work?
TripCode said:
WhatCrypt - WhatsApp Crypt Tool
WhatCrypt is a decryption and recryption tool for backed up WhatsApp databases.
Usage Examples:
Decrypt .crypt and .crypt5 database files and turn them into SQLite files.
Decrypt or Recrypt.crypt5 database files that have not been linked to any account.
Recrypt .crypt5 database files so they can be used on another device / account.
Recrypt .crypt5 database files to .crypt so they can be used on older WhatsApp versions.
Recrypt .crypt database files to .crypt5 so they can be used on newer WhatsApp versions.
All decrypted and recrypted files will be saved in the same directory as the original encrypted
file. Decrypted files will end in .db. Recrypted files will end in re.crypt or re.crypt5. The
original encrypted files will not be moved or deleted. If you get any Decryption Failed messages
then it means that either the encrypted database is corrupt or you have supplied the incorrect
account name.
Download Here: http://whatsapp.livetrack.mobi/com.whatcrypt.apk
Click to expand...
Click to collapse

This looks like a crap which wont work and is only designed to collect user database...
Sent from my GT-I9082 using XDA Premium 4 mobile app

It works absolutely fine!
->"WhatCrypt Settings" -> locate the .crypt5 file -> type in your gmail account-> Save settings-> Back to Main Menu->Recrypt Whatsapp Database->Put in your gmail address again-> remove the hook from crypt5-> Recrypt Whatsapp Database-> WAIT a minute.
This will create a normal crypt file, which can be used in whatsapp xtract just like before!

"Google recommends you not to install this app."

Pumpernickel1 said:
It works absolutely fine!
->"WhatCrypt Settings" -> locate the .crypt5 file -> type in your gmail account-> Save settings-> Back to Main Menu->Recrypt Whatsapp Database->Put in your gmail address again-> remove the hook from crypt5-> Recrypt Whatsapp Database-> WAIT a minute.
This will create a normal crypt file, which can be used in whatsapp xtract just like before!
Click to expand...
Click to collapse
It doesnt nw..the key might hav changed or the dechipher no longer works..searchin for somethin tht cud break the code..

ursnava said:
It doesnt nw..the key might hav changed or the dechipher no longer works..searchin for somethin tht cud break the code..
Click to expand...
Click to collapse
Decrypt doesn't work for me either but RECRYPT from .crypt5 to .crypt definitly works still fine!
Just tried with newest Whatsapp availabe and newest Backup file.
Recrypting will create "msgstore.db.re.crypt". Of course this has to renamed to "msgstore.db.crypt" before you can use "Whatsap Xtract".

hasta_guy said:
This looks like a crap which wont work and is only designed to collect user database...
Sent from my GT-I9082 using XDA Premium 4 mobile app
Click to expand...
Click to collapse
Yep.. it seems to be so..

Pumpernickel1 said:
Decrypt doesn't work for me either but RECRYPT from .crypt5 to .crypt definitly works still fine!
Just tried with newest Whatsapp availabe and newest Backup file.
Recrypting will create "msgstore.db.re.crypt". Of course this has to renamed to "msgstore.db.crypt" before you can use "Whatsap Xtract".
Click to expand...
Click to collapse
Its a crap. there is a better app which recrypts. https://play.google.com/store/apps/details?id=org.fireblade.whatsappconverter
Can any one recommend any app which can convert my old backup file of db.crypt to the new backup file db.crypt5 so that i can import old data.

Its not working even after entering correct gmail account
Its not working even after entering correct gmail account. Its not decryting the database.
What should be done now.

Whatsapp introduced .crypt6 files in the latest version from their website and I am not able to convert them to.crypt using the tool. Any insight into crypt6?

ombheembush said:
Whatsapp introduced .crypt6 files in the latest version from their website and I am not able to convert them to.crypt using the tool. Any insight into crypt6?
Click to expand...
Click to collapse
The app has been updated to support crypt6. Root access will be required to obtain your crypt6 key.

crypt6 key
how to get Crypt6 key from android phone.
please tell me brifly.
give the full path so i can find crypt6 key.

TripCode said:
The app has been updated to support crypt6. Root access will be required to obtain your crypt6 key.
Click to expand...
Click to collapse
thanks for the application. i was able to obtain a decrypted file of the database, file extension was .db
i want to use this file with smsbackup+ to backup whatsapp chats in my gmail.
smsbackup+ does not recognive the newly created file. do you know how i can solve this?
smsbackup+ was backing up after i converted the crypt5 file with this app https://play.google.com/store/apps/details?id=org.fireblade.whatsappconverter

resitm said:
thanks for the application. i was able to obtain a decrypted file of the database, file extension was .db
i want to use this file with smsbackup+ to backup whatsapp chats in my gmail.
smsbackup+ does not recognive the newly created file. do you know how i can solve this?
smsbackup+ was backing up after i converted the crypt5 file with this app
Click to expand...
Click to collapse
Crossposting links in multiple threads puts you in danger of becoming a spam whore. I advise you not to do it. If you would like to promote an app then I would advise you to link to it in your signature instead of cluttering up the forums. If the app that you are promoting works for you then I fail to see any constructive purpose of your post. In anycase, sms backup+ is open source so why not just use a fork that contains support for crypt 5? However, it must be noted that the switch to crypt6 is imminent and that crypt5 will soon be yesterdays news.

TripCode said:
Crossposting links in multiple threads puts you in danger of becoming a spam whore. I advise you not to do it. If you would like to promote an app then I would advise you to link to it in your signature instead of cluttering up the forums. If the app that you are promoting works for you then I fail to see any constructive purpose of your post. In anycase, sms backup+ is open source so why not just use a fork that contains support for crypt 5? However, it must be noted that the switch to crypt6 is imminent and that crypt5 will soon be yesterdays news.
Click to expand...
Click to collapse
I like the danger of becoming a spam whore, let me worry about me.
The whatsapp i use has the crypt6 file, i just said that the pther app was working with the crypt5. Not promoting or any other b.s
I posted in 2 locations so more people would see it, seeing how this thread is not moving.

resitm said:
I like the danger of becoming a spam whore, let me worry about me.
The whatsapp i use has the crypt6 file, i just said that the pther app was working with the crypt5. Not promoting or any other b.s
I posted in 2 locations so more people would see it, seeing how this thread is not moving.
Click to expand...
Click to collapse
My appologies if you weren't spamming. Have you verified that you can open the db file in a sqlite browser? Also, I thought sms plus dealt with the old .crypt files so what you may need to do is use the Recrypt option to convert crypt6 to crypt and then rename the recrypted msgstore.db.re.crypt to msgstore.db.crypt so that it can be read by sms plus. Let me know how you get on.

jigneshpatel571985 said:
how to get Crypt6 key from android phone.
please tell me brifly.
give the full path so i can find crypt6 key.
Click to expand...
Click to collapse
The key file is located in "/data/data/com.whatsapp/files/key" You can obtain it with root or possibly with a usb backup solution such as Helium. It should be noted that the beta builds of WhatsApp use a rolling encryption mechanism which means that the cipher key changes periodically. As far as I can tell WhatsApp doesn't even read the cipher key from the key file, but instead calls a remote hashing algorithm on their server which is based on other parameters stored in this file. It's likely that in the next stable release the cipher key may not even be present on the device. In which case the only way to obtain the current cipher will be to patch the WhatsApp apk. I have already developed a patch tool that is called WhatPatch that can achieve this, though I'll be watching this space with everyone else before I decide if it's worth releasing or not.

TripCode said:
The app has been updated to support crypt6. Root access will be required to obtain your crypt6 key.
Click to expand...
Click to collapse
Says Crypt 6 key not found even though it says the Key copied successfully in the settings page; in reality the crypt6.key is not copied to the directory.

ombheembush said:
Says Crypt 6 key not found even though it says the Key copied successfully in the settings page; in reality the crypt6.key is not copied to the directory.
Click to expand...
Click to collapse
Was the app granted root? Failing that if you have root then just copy "/data/data/com.whatsapp/files/key" to "sdcard/WhatsApp/crypt6.key" manually. The copy feature works on several of my own devices, but has not yet been exstensively tested. Please also ensure that the path to the key is correct in settings.
EDIT: The app has been updated. Specifically concerning the root key copying mechanism. It is busybox aware and the event handling of any errors is more precise. I.E. If the user has a version of WhatsApp installed that does not yet support crypt6 it will respond with "Cannot copy a non-existent key!".

Related

Possible to download files on device?

Is it possible to download files (RAR) on the device using internet and transfer it later to the PC? I don't think its possible in stock ROM but perhaps an App or something.
My device is Dev+Interop unlocked.
if you find where ie9 stores temporary downloaded file, like pdf, mp4 ecc ecc, i can tell you how to complete the download, and, once completed, tranfer the file to the pc...
It's very possible (download any file that fits to handset's isolated storage file from your homebrew app, and transfer that file to PC using ISETool.exe) but why not use cloud file storage such as SkyDrive, DropBox etc.? If you have no experience with DropBox, click on link in my signature; it's very simple and useful
davide136 said:
if you find where ie9 stores temporary downloaded file, like pdf, mp4 ecc ecc, i can tell you how to complete the download, and, once completed, tranfer the file to the pc...
Click to expand...
Click to collapse
I think I can find it. Will I be able to save files like RAR too?
It's very possible (download any file that fits to handset's isolated storage file from your homebrew app, and transfer that file to PC using ISETool.exe) but why not use cloud file storage such as SkyDrive, DropBox etc.? If you have no experience with DropBox, click on link in my signature; it's very simple and useful
Click to expand...
Click to collapse
I think I would then have to transfer twice.
lamborg said:
Is it possible to download files (RAR) on the device using internet and transfer it later to the PC? I don't think its possible in stock ROM but perhaps an App or something.
My device is Dev+Interop unlocked.
Click to expand...
Click to collapse
Yes it is possible to download files. I do it with ultrashot's Opera Mobile port which allows you to select the location of the downloaded files and transfer it using Gooddaytodie's Webserver
Opera Mobile requires full-unlock, so that's not an option for the OP.
Downloaded files typically go to \Application Data\Volatile\<SUBFOLDER> where <SUBFOLDER> depends on where and how they were downloaded (IE, email attachment, etc.).
If you look at the source for my XapHandler app, you'll see how an app can register a filetype. You'd need to do this, or the phone will simply refuse to download extensions that it doesn't recognize (hmm... I wonder if a .* handler would work?)
GoodDayToDie said:
Opera Mobile requires full-unlock, so that's not an option for the OP.
Downloaded files typically go to \Application Data\Volatile\<SUBFOLDER> where <SUBFOLDER> depends on where and how they were downloaded (IE, email attachment, etc.).
If you look at the source for my XapHandler app, you'll see how an app can register a filetype. You'd need to do this, or the phone will simply refuse to download extensions that it doesn't recognize (hmm... I wonder if a .* handler would work?)
Click to expand...
Click to collapse
If Opera Mobile can do, then perhaps some other browser can do that too? Metro internet explorer doesn't work
All the browsers that are based on the IE engine will be unable to do it until the necessary registry keys in HKCR are created. An app can manually download from a URI and save the resulting file, but in the WebBrowserControl if the user clicks a link to a file the handling for what to do with the file is the same as on IE.
GoodDayToDie said:
All the browsers that are based on the IE engine will be unable to do it until the necessary registry keys in HKCR are created. An app can manually download from a URI and save the resulting file, but in the WebBrowserControl if the user clicks a link to a file the handling for what to do with the file is the same as on IE.
Click to expand...
Click to collapse
yes I can see why it doesn't work. So, does an app like that exists in the MP?
lamborg said:
yes I can see why it doesn't work. So, does an app like that exists in the MP?
Click to expand...
Click to collapse
No. And nobody here not even meant marketplace. Interop-unlock + homebrew only.
BTW, could you share with us your scenario: why do you need to download rar archive to the phone and transfer to the PC? I still can't achieve why do you need things like this.
sensboston said:
No. And nobody here not even meant marketplace. Interop-unlock + homebrew only.
BTW, could you share with us your scenario: why do you need to download rar archive to the phone and transfer to the PC? I still can't achieve why do you need things like this.
Click to expand...
Click to collapse
well the thing is, sometimes I need to download files which may take a while to download completely. So, I can download on the go with the cellular data and then transfer to PC when home. Sometimes the file download is completed in the time same as reaching from work to home.
ok, i'll solve the mistere the only thing u need to do is to add a reg key in hkcr , it will be called .rar for rar files etc...then insisde it u create a string that names Default, the value is rarfile
u go back to hkcr, and create a key that is called rarfile, inside it u will create a dword named EditFlags and with the value of 65536
that's all, now you need to know where ie9 stores data...
davide136 said:
ok, i'll solve the mistere the only thing u need to do is to add a reg key in hkcr , it will be called .rar for rar files etc...then insisde it u create a string that names Default, the value is rarfile
u go back to hkcr, and create a key that is called rarfile, inside it u will create a dword named EditFlags and with the value of 65536
that's all, now you need to know where ie9 stores data...
Click to expand...
Click to collapse
I don't know if it'll work or not but can you guide the how-to. I can edit the reg-edit using MFG. It has following options:
Root Path
Sub Path
Input key and type
Input data
Just confirming as incorrect reg edit can render unstable.
lamborg said:
So, I can download on the go with the cellular data and then transfer to PC when home.
Click to expand...
Click to collapse
Oh, I see... Seems like India still have a "last mile" problem and your cell connection is more reliable and faster than home internet. For countries with fast broadband home internet connection this "feature" just have no sense.
lamborg said:
I don't know if it'll work or not but can you guide the how-to. I can edit the reg-edit using MFG. It has following options:
Root Path
Sub Path
Input key and type
Input data
Just confirming as incorrect reg edit can render unstable.
Click to expand...
Click to collapse
ok, this is what you have to do:
-open mfg, engineer menu, other settings, edit registry
root path: HKEY_CLASSES_ROOT
input sub path: .rar
input key: default (string)
input data: rarfile
SET
-without closing
root path: HKEY_CLASSES_ROOT
input sub path: rarfile
input key: EditFlags (dword)
input data: 65536
SET
pay attention at the caps...sry for bad eng...

[TOOL] yaffs extractor, mmssms.db & contacts2.db converter

Some time ago I sold my old android phone and forgot to make a backup of SMS messages and call logs, but kept a complete image backup made by clockworkmod recovery (system.img, data.img, etc.). I wanted to import my SMS messages and call logs to a new phone, but without a reasonable backup this seemed to be impossible. Some quick search over the internet showed that a question about extracting/importing SMS messages from mmssms.db is not so uncommon, but there are no tools to do this. So I wrote one, and decided to share
Sources are available at github.com abbot/android-restore-tools.
It requires Python 2.6 and above to run.
I've also made compiled binaries for windows, attached to this post.
[Binaries last updated on 12.04.2011]
Thanks for the tools. Nice work.
Sent from my GT-I8150 using XDA
Hello,
I'm trying to use your tool to extract SMS from a nandroid backup.
I'm using the data.yaffs2.img file from the backup.
When I choose #2 for mmssms.db and then "s" to extract SMS I get the following error:
Failed to extract messages: file is encrypted or is not a database
DatabaseError('file is encrypted or is not a database',)
Warning: failed to remove temporary file...
What does this mean, and is there a solution?
Hi,
This may be caused by two things: either my tool can't properly read/extract the image file, or it can't read the database.
Please try to extract the image (extract -x data.yaffs2.img). If this does not produce any errors, find the mmssms.db file in the extracted data, it will probably be in data/com.android.providers.telephony/databases/mmssms.db. Then try to run extract -s mmssms.db. Please post if you get any errors doing these steps.
There was an error while extracting the image...it got through partway, but then failed at some bluetooth directory with colons in the path.
So I used a different tool to extract it, which went successfully.
Then I ran extract -s mmssms.db which came with the same error.
I'm pretty sure there isn't some weird encryption since I opened it up with Notepad ++ and I could read bits and pieces of conversations.
Anything else to try?
This might be caused by an older sqlite3 version bundled with binaries. I have updated the binaries in the first message to a newer version, could you download it and try again, extract -s mmssms.db?
Different error this time:
Failed to extract messages: no such column: failure_cause
OperationalError('no such column: failure_cause',)
Warning: failed to remove temporary file...
FYI the first thing at the top of the file when I open in Notepad++ is SQLite format 3 and this is from an HTC device running Android 4.x does that help at all?
This is much better and now makes sense: android 4.0 usually has sqlite 3.7.x, previous binary build of this tool had sqlite 3.6.21, and that was the reason for the 'file is encrypted or is not a database' error.
Now it looks like mmssms.db format in Android 4.0 has changed a little bit. I will have a look on these changes and update the app accordingly. Hope it will not take too much time
abbot2 said:
This is much better and now makes sense: android 4.0 usually has sqlite 3.7.x, previous binary build of this tool had sqlite 3.6.21, and that was the reason for the 'file is encrypted or is not a database' error.
Now it looks like mmssms.db format in Android 4.0 has changed a little bit. I will have a look on these changes and update the app accordingly. Hope it will not take too much time
Click to expand...
Click to collapse
That would be awesome, perhaps keep the old version available for other folks too though
If you can get this working I'll be sure to send a couple bucks your way. Thanks!
I have updated the extractor again, did some limited testing with android 4.0.3 on the emulator - seems to work. This database has a number of fields removed on android 4 compared to android 2, however everything required for xml dump is still there - just had to remove some unused stuff. Download the new version and try again.
Regarding the older versions, no reason to keep them - new one works fine with old database formats.
Awesome works perfectly! Send me a PM where to donate.
Sent from my GT-I9000 using xda premium
Thanks! It really works perfectly. Any plans to include MMS?
Sorry for the noobish question but I'm not familiar with Python.
Installed newest version of Python and also got the extracted mmssms.db and contacts2.db (used Nandriod Browser to extract them), which command lines do I need/what do I have to do? :s
€dit: Downloaded the zip from github and got as far as opening mmssms2xml.py which gives me an error when opening the mmssms.db
Exception in Tkinter callback
Traceback (most recent call last):
File "C:\Python27\lib\lib-tk\Tkinter.py", line 1410, in __call__
return self.func(*args)
File "D:\Downloads\abbot-android-restore-tools-bc8584d\abbot-android-restore-t
ools-bc8584d\mmssms2xml.py", line 99, in open_file
self.messages = read_messages(filename)
File "D:\Downloads\abbot-android-restore-tools-bc8584d\abbot-android-restore-t
ools-bc8584d\mmssms2xml.py", line 33, in read_messages
c.execute("SELECT _id, thread_id, address, person, date, protocol, read, pri
ority, status, type, callback_number, reply_path_present, subject, body, service
_center, failure_cause, locked, error_code, stack_type, seen, sort_index FROM sm
s ORDER BY date DESC")
OperationalError: no such column: priority
Click to expand...
Click to collapse
€dit2: No problems with contacts2.db?!
€dit3: Well..this should be the last, found this explanation of rani2001 over here (http://forum.xda-developers.com/showpost.php?p=25173166&postcount=7). That did it for me!
Dude you just made my day
Can you please compile a new windows version with the latest files from github?
Or give us a manual how to use the .py files.
I think this will help many of us.
Thank you very much.
BTW: Your tool worked perfectly with my mmssms.db but failed with contacts2.db. Maybe the new files requested above will help me.
Got all my sms back thanks to you.
Amazing script, Thanks for sharing and explaining and updating.
60% There
I was just wondering if there was anything special I had to do to merge my old SMS list and the ones from the new list. I didn't see an option there for it and I don't want to just paste it in there and load it. Many thanks ahead of time
Hi I want to extract the data.yaffs2.img from my HTC Desire nandroid backup but get the error message:
> extract.exe -s data.yaffs2.img
Failed to extract messages: file is encrypted or is not a database
Any ideas?
I tried this tool yesterday evening and I'm truly grateful for your work!
I was ready to spend the whole night to work with these damn tables when I found your work. Many thanks! :highfive:
Where is the file stored after i run it? This is what I got.
Code:
C:\Users\Damastah>C:\Users\Damastah\Downloads\yaffs-mmssmsdb-calls-extractor\ext
ract.exe -s D:\S3_recovery\mmssms.db
Read 1782 messages
Save as (empty=sms-20130330111807.xml): y

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

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 message information (such as thumbnail, link, emoticon, etc.) and work like it is a restore file that backup from itself.
There will be three main phase you need to perform. You can get all required file in the attachment. Make sure you backup your end result before jump into the next phase.
Phase A: Decrypt and obtain msgstore.db file
This is the easiest method I can find and NO ROOT is required to perform this. All you need is to follow the instruction below.
INSTRUCTIONS:
Extract "WhatsAppKeyExtract.zip" (from attachment) on your computer maintaining the directory structure.
Browse to the extracted folder and click on "WhatsAppKeyExtract.bat".
Enable USB Debugging on your device.
Connect your device via USB**, unlock your screen and wait for "Full backup" to appear.
Leave the password field blank and tap on "Back up my data".
The "extracted" folder will now contain your "whatsapp.key", "msgstore.db" and "wa.db".
**If you have never used USB Debugging before, you may also need to verify the fingerprint.
(Credited to TripCode for providing this application! Here is the link to original thread.)
For my case, I have three backup files that named msgstore.db.crypt, msgstore.db.crypt7 and msgstore.db.crypt8. Although I know there might be other easier method to achieve this, I choose to restore each file (by uninstall and install WhatsApp) and run the above method to get my decrypted file. Hence I can be sure that all decrypted file will come in the same structure (I will show you what this mean later) and prevent any error that may cause by that.
Phase B: Edit and prepare database for merge
This will be a bit tricky. But in general, you MUST make sure that you have no overlapping message history between your files.
INSTRUCTION:
Download SQLite Database Browser and install on your computer.
Open the database you want to edit.
Click on [Browse Data] tab.
In Table drop down menu, click on [messages] (You will see all your WhatsApp message here).
Use it like you are using Excel, select any row that is overlapping (EXCEPT the row with many [-1] value) and click on [Delete Record], then click on [Write Changes] (this means you have save the change to the database).
Keep doing this for your remaining file and close all windows of SQLite Database Browser when you are done.
(Thanks ztedd for posting his own method where I get inspired from. This is the link to his original post.)
For my case, the number of column of all my file when display in "messages" table is different (newer WhatsApp database file have more data type). This is the reason I restore and run backup again to make sure all my file have the same structure. Also, a quick tips to figure out which row is overlapping or duplicate is export the messages table to CSV file and open it with Excel. You will need to copy the first few column of each database and paste them together, then use the feature that come with Excel such as Filter and Remove Duplicate to identify which row number you need to remove from actual database file.
IMPORTANT - Never edit your database on excel and import it back to your original database. This will remove all thumbnail, link, emoticon and etc. and show you some weird message when you restore back to your device.
Phase C: Merge database file
This method only can merge two file at once. You may need to do this several time depending how many database you want to merge. I suggest you start from the oldest to newest.
INSTRUCTION:
Rename the older file to old.db.
Rename the newer file to new.db
Create a new folder called Merge and copy the file old.db, new.db and merjapp.jar into it.
Run Command Prompt on your computer (or click on Start Menu and search for cmd)
In Command Prompt, type each of the following separately and press Enter:
Code:
cd desktop
cd merge
You now should see [C:\Users\<UserName>\Desktop\Merge>] in cmd window.
Now type the following and press Enter:
Code:
java.exe -jar merjapp.jar -old old.db -new new.db
You should see a "Done!" is displayed and a new file named output.db will be created in the Merge folder.
If you have other database to merge, repeat the steps above by rename the output.db to old.db.
Once you are done, rename the output.db to msgstore.db and it is ready to restore into WhatsApp.
(Credited to namnoops for this merge application! This is the link to original thread.)
For my case, I have to run this steps twice to merge 3 databases. I get error the first time I run this because some messages is overlapping and this is the reason for Phase B to edit my database. Once I got my merged database, I renamed it to msgstore.db (without encrypt again) and have no problem restore back to my device. I also copy and paste all my backed up WhatsApp folder to my device (except the file in Database folder) for the picture in WhatsApp to work.
Disclaimer: I do not know any coding behind all these so if you have any questions I will try to answer but the best bet is to go back to the original thread.
Below is some other method that I found online but can't figure out how to do it. You may try it at your own risk.
Additional Method:
sch3m4's wforensic Method
Alternate sch3m4's wforensic Method
Reserve for later use.
Reserve for later use, again.
How could i restore the merged database file ?
Xperia000sola said:
How could i restore the merged database file ?
Click to expand...
Click to collapse
I think you should overwrite new merged DB uninstall whatsapp then reinstall it
Thank you! I' ve tried the method in the thread of the merge tool, but your procedure did the trick for me =)
i cannot use it
help us with video please
big fail after attemped retrieve msgstore.db
when tested edit under sqlitebrowser, save change then exit. copy backup the "msgstore.db" file to my device original place and set permission as before. run whatsapp then all my message on list has been gone. no idea wut happen. even though i copy back my original msgstore.db to same place. so **** and make me down becoz i forgot to backup the list b4 make this test.
i use whatsapp ver 2.12.367. and dun add or del row under sqlitebrowser, only retrieve some text on same row, but why i copy back the original msgstore.db also fail? lost all message
While it might not be a lot of fun, it's quite easy to merge those databases using this method
I have used the Android WhatCrypt-app to decrypt my databases on the smartphone, copied both unencrypted ones to my PC and then trimmed the newer one down.
After merging, the only problem was getting Whatsapp to accept my database - the first attempt resulted in Whatsapp deleting all my messages.
My solution was to "Clear Data" on Whatsapp and simply drop the newly created database in Whatsapp's folder inside /data.
It accepted the new file and created the missing files by itself.
Now I have finally got all those messages in my Whatsapp
Thank you very much!
Hey,
I have a problem : everytime I try to do the last step e.g. merge the old.db and new.db via cmd - i get the error message " -E- Database old.db cannot be found! " . I renamed the old database to "old.db" still it doesnt work? What I am doing wrong?
Is my old.db file corrupted? I can read it with Whatsapp Viewer tool.. So it seems to work.
And there shouldnt be any overlapping messages - I have an old database and a fresh new one without any old backups.
(my old phone broke and i just jused the new one for the incoming messages)
Help
Hi,
I just wanted to ask, I have the msgsstore.db.crypt8 File from my old whatsapp back on older device but I am unable to copy it to the database folder in my new device.
Help Please
Guys I have 2 backups, 1 crypt9 and 1 crypt12. I decrypted and merged both succesfully but when I try to restore my messages through Whatsapp it tells me "Cannor restore your messagges......." . What can be the problem? Whatsappviewer open without problems outout.db, so I think it is not corrupted. There may be some overlapping msgs? How can I notice them? I whatched the table column received_timestamp and I didn't see any equal row. However the column timestamp has multiple equal column, can be this my problem?
Thank in advance
Now I'm on phase B, and with the DB Browser for SQLite, I opened (tab Browse Data) the msgstore file in the "extracted" folder and then selected messages In Table drop down menu.
I didn't not understand what to do next.
DLz88 said:
Now I'm on phase B, and with the DB Browser for SQLite, I opened (tab Browse Data) the msgstore file in the "extracted" folder and then selected messages In Table drop down menu.
I didn't not understand what to do next.
Click to expand...
Click to collapse
You would need to delete the records you do not want and then save the changes. In any case, what is the end result you are trying to achieve? Do you wish to import the merged database back to WhatsApp? Are the databases from separate accounts? If you intend to write back msgstore.db to /data/data/com.whatsapp/databases? How are you going to do that without root? If you do intend to use your merged database with WhatsApp then you may run into difficulties. Things have changed a lot since this guide was written.
I have previous crypted (crypt8) backup files from whatsapp database (same account) and I want to merge those old messages with others whatsapp messages I have on my LG G5. Basically my galaxy s4 died, I managed to rescue the whatsapp database and now I want those messages in my new LG G5 (no backup on whatsapp servers because it was setted off by mistake). The folder is inside the main storage/WhatsApp/Database Also, I want all the records and excel told me that there are not any duplicates values.
Don't work on Nexus 5X, show message like strong AES encryption. :'(
Guys, I have FINALLY found a way to merge two differten WhatsApp backup files. I'll post the guide asap (have to translate it). Is different from the one on the first page for the first two parts.
How to merge two different WhatsApp backup files:
We have two different WhatsApp backup file (doesn't matter if encrypted by different methods, for example, I had a crypt9 file and one crypt8) and we want to combine them into one so we can read them with WhatsApp.
Requirements: OS: Windows Vista, Windows 7 or Windows 8
Programs you need:
1) WhatsApp Xtract: http://forum.xda-developers.com/showthread.php?t=2770982
2) SQLite Database Browser: https://github.com/sqlitebrowser/sql....2.0-win32.exe
3) merjapp (merjapp.jar) https://github.com/namnoops/merjapp/releases
4) JDK http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
5) Java: https://www.java.com/en/download/
6) ADB (Android Debug Bridge) Drivers - If not installed: http://developer.android.com/sdk/index.html
Enable USB Debugg: Settings \ Developer options \ USB debugging (to activate them go to Settings-> About phone-> Software Information-> click many times on the Build number).
Before proceeding further, I suggest to temporarily remove all security protocols such as pin, lock screen with a sequence or other method and scanning fingerprints. In order to avoid the forced backup password.
I also suggest to make the extension of the files, visible (on windows, go to Tools-> Folder Options-> View-> uncheck "Hide extensions for known files").
First phase: decrypt
Extract the "WhatsAppKeyExtract.zip" program in a PC folder, making sure to maintain the folder structure.
a) Start "WhatsAppKeyExtract.bat"
b) Once started, connect your phone via USB, unlock the screen.
c) Wait until the screen that tells you to back up your data appears.
d) Leave the password field blank and click "Back up my data".
e) When finished, inside the "extracted" folder (located inside the WhatsAppKeyExtractor folder) you will find the files "whatsapp.key", "msgstore.db" and "wa.db". (That's if the latest versions of whatsapp).
At this point I recommend to save these files in a folder, calling it "new backup."
Now we must do the same process with the old backup, then:
Uninstall Whatsapp.
Remove all backups from the folder Whatsapp\databases (inside the phone).
Put back in the old backup file ( "msgstore").
Reinstall whatsapp, and let it reopen old messages (restore backup). When done, remove the connection data from the phone (both wifi, and UMTS).
Redo the same procedure as before, from point a) to e).
Save these new files "msgstore.db" and "wa.db" in a folder, this time calling it "old backup."
The first part is finished.
Second phase: organizing the chat
Before you start, create backup copies of previously decrypted file (you never know).
Open SQLiteBrowsers, position yourself in BrowseData tab and select Open Database. Choose the old backup file msgstore.db (that previously we have decrypted).
Click the lower Tab, select "messages".
With the scroll menu, go down to the last message. Here, count the "_id" number of the last message, for example "65422"
Open the new backup file (the new msgstore.db we had decrypted) always with the SQLite Database Browser program. By the same process: open the inferior tab and select messages. Highlight entirely the first line that has the fields, for the most part, containing the value "-1", and delete the line with the Delete Record command.
Make a note now of the number of the first message, under "_id" for example "12"
Now go in the tab "Execute SQL" and write the following string: UPDATE messages Set_id = (65422 + 1 + _id - 12) (put the numbers that you had marked earlier, in this case 65422 and 12). Click ExecuteSQL ( "Play" button)
Close SQLiteBrowers.
End of the second phase.
Third phase: merge
Create a new folder on your desktop called "merge".
Rename the old backup file (the msgstore.db file that is inside the "old backup" folder) that we had decrypted, in old (so we have the file old.db).
Rename the new backup file (the msgstore.db file that is inside the "new backup" folder) that we had decrypted and on which we had executed the SQLiteBrowser string, in new (so we have the file new.db).
Copy and paste the two files in the directory "merge".
Copy merjapp (merjapp.jar) in the "merge" folder.
Now run the command prompt as an administrator.
Enter the following commands:
cd C: \ Users \ [username] (press "ENTER")
cd desktop (press "ENTER")
cd merge (press "ENTER")
java.exe -jar merjapp.jar-old old.db -new new.db (press "ENTER")
It must appear "Done!"
At this point in the "merge" folder there must be a file called output (output.db file)
Copy it in desktop and rename it msgstore (so we have the msgstore.db file).
Open the phone's internal memory, go into WhatsApp \ Database folder, and delete all the files that are in there.
Copy "msgstore" (the msgstore.db file that was named output) in the folder Whatsapp \ Database.
Uninstall and reinstall WhatsApp (obviously choosing to restore backups).
END
DLz88 said:
Guys, I have FINALLY found a way to merge two differten WhatsApp backup files. I'll post the guide asap (have to translate it). Is different from the one on the first page for the first two parts.
Click to expand...
Click to collapse
Many thanks for finding the time to post your updated working method. I'm sure your contribution will come in handy for many users.
Hi. With this tutorial can I merge 2 backups from different numbers? Basically I would like to move the conversations from my second number to the first number I have.
Thanks.
foxmolder1985 said:
Hi. With this tutorial can I merge 2 backups from different numbers? Basically I would like to move the conversations from my second number to the first number I have.
Thanks.
Click to expand...
Click to collapse
I don't know if my guide can works with backups from two different numbers. You can always try it and let us know

Decrypting Whatsapp Database (.crypt9) file

How do I decrypt/read a Whatsapp Database (.crypt9) file ?
I have tried many methods like Whatsapp Xtract with Python,then Whatsapp Viewer and also Whatcrypt.com . And also saw many Youtube videos but all were outdated and usable for previous versions of .crypt( i.e crypt 5/6/7/8)
I need decryption method of .crypt9 for reading out Whatsapp messages directly from db files . Because I am unable to attach and obtain .txt from "email conversation" opt from Whatsapp.
So please someone provide me Method to decrypt ".crypt9" file.
Thanks A lot.
+1
huuur said:
+1
Click to expand...
Click to collapse
I'm interested too
haxxorsid said:
How do I decrypt/read a Whatsapp Database (.crypt9) file ?
I have tried many methods like Whatsapp Xtract with Python,then Whatsapp Viewer and also Whatcrypt.com . And also saw many Youtube videos but all were outdated and usable for previous versions of .crypt( i.e crypt 5/6/7/8)
I need decryption method of .crypt9 for reading out Whatsapp messages directly from db files . Because I am unable to attach and obtain .txt from "email conversation" opt from Whatsapp.
So please someone provide me Method to decrypt ".crypt9" file.
Thanks A lot.
Click to expand...
Click to collapse
+1
try recovermessages.com it worked for me
hackzfreak4 said:
try recovermessages.com it worked for me
Click to expand...
Click to collapse
1 post from user, website doesn't even state the older crypt5,7 or 8 methods (just requests a crypt file, no key file and nothing). to see all data you'll need to pay via paypal.
sounds like a ripoff to me.
if it is not, please proove with a youtube video of your whole computer screen and not cut during waittimes that decryption works.
-acid
Dear all, please be patient.
Any XDA member will surely find the way to decrypt crypt9 files.
Do not spend time or money with fake websites because crypt9 is yet unbreakable.
Instead, put your money over the table and donate it to people that spend their time to help others.
My congratulations to those who reached crypt8 decryption. Hope you will give us a solution to decrypt crypt9 files soon. Cheer up!
Kind regards.
Any update? I too have a crypt9 file I'm trying to decode. Pulled it off my wife's phone when I noticed she was hiding something
crypt9
guys we need to decrypt crypt9 files please help!
Same problem with me!!! Need to decrypt crypt9!!! pls some1 help us out!!!
Crypt9
Would be great to see this one cracked as Crypt9 is using end-end encryption with an unique key for each message sent. This is in contrast with previous Crypt databases where a key is extracted once to decrypt the Whatsapp database continuously.
Any update
Any update
If you have your crypt key you can decrypt crypt9 and crypt10 files at whatcrypt.com.
If you don't have your crypt key you can obtain it by downloading the crypt key extractor on that site.
MalDroid said:
If you have your crypt key you can decrypt crypt9 and crypt10 files at whatcrypt.com.
If you don't have your crypt key you can obtain it by downloading the crypt key extractor on that site.
Click to expand...
Click to collapse
That is correct, whatcrypt.com currently supports crypt formats 5-11. The key file is required for crypt6+
Are technical details available? I'd like to update WhatsApp Viewer which allows offline decryption.
andreasmausch said:
Are technical details available? I'd like to update WhatsApp Viewer which allows offline decryption.
Click to expand...
Click to collapse
I hope someone can chime in on this. I'd much rather rely on an offline tool such as WhatsApp Viewer than to upload my database to some random website.
andreasmausch said:
Are technical details available? I'd like to update WhatsApp Viewer which allows offline decryption.
Click to expand...
Click to collapse
Yep, technical info can be awesome for my soft, if you get any info will be very glad for it.
Thanks, regards.
Error..
Hi All,
Has someone found the method how to decrypt crypt9 file??? I tried all processes from last 2 months but could not get it.
I have a Nokia X mobile,which is not purely android, so i'm facing many problems. Kindly help me out.
incorrect account error
i tried to use whatcrypt.com but always i see "incorrect account". is account gmail which whatsapp account related? does anyone know how i can fix this error? or can be found another way for decrypting crypt9 file?

Help with Currency Converter Small App ( com.sony.smallapp.currency)

Hey all,
This "small app" has recently become broken because the source for the currency file's URL has changed.
When the app is newly installed, it pops an error at first launch:
"Unable to download currency file. Please try again later".
It broke around mid-july 2018.
What I'm looking for is the latest available currency file so that the program can at least work (even if it can't update).
It should be located at:
Android/data/com.sony.smallapp.currency/files/
If someone could kindly .zip and upload the "files" folder here, it would be majorly helpful.
Thanks.
i think is that the data to work again
I think is the data to work..i hope work again
Ps24u said:
Hey all,
This "small app" has recently become broken because the source for the currency file's URL has changed.
When the app is newly installed, it pops an error at first launch:
"Unable to download currency file. Please try again later".
It broke around mid-july 2018.
What I'm looking for is the latest available currency file so that the program can at least work (even if it can't update).
It should be located at:
Android/data/com.sony.smallapp.currency/files/
If someone could kindly .zip and upload the "files" folder here, it would be majorly helpful.
Thanks.
Click to expand...
Click to collapse
Thanks much for your reply stathis, sadly that doesn't fix it.
If your device is rooted, could you copy and upload the following folder as well:
/data/data/com.sony.smallapp.currency/
I believe something in the .xml changes when the soft has successfully downloaded the .csv file by itself.
Thank you.
This is only found ..i hope work
Ps24u said:
Thanks much for your reply stathis, sadly that doesn't fix it.
If your device is rooted, could you copy and upload the following folder as well:
/data/data/com.sony.smallapp.currency/
I believe something in the .xml changes when the soft has successfully downloaded the .csv file by itself.
Thank you.
Click to expand...
Click to collapse
I clear data from the app and delete the .csv file from Android/data/com.sony.smallapp.currency/files/ and the app not work after i put again the file .csv and work again
and i made and one backup with Titanium backup if can help
It worked finally!
Also while the app's internal update mechanism is broken, we can update manually, here is the most recent currency database file :
https://www4.bcb.gov.br/Download/fechamento/20180927.csv
Thank you again for your help!
Here's how to update manually:
1. Download the newest .csv file from: https://ptax.bcb.gov.br/ptax_internet/consultarTodasAsMoedas.do?method=consultaTodasMoedas
2. Delete the old .csv file and copy the new .csv file in:
Android/data/com.sony.smallapp.currency/files/
3. Disable WiFi, then launch Currency Converter app. It'll detect and use the newest .csv
4. Done!

Categories

Resources