Whatsapp databases: Difference between revisions
Created page with "In order to merge databases (msgstore.db.crypt12) you need the key. =Decrypting the message store database= The easiest way to get the key on a rooted device with whatsapp s..." |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 13: | Line 13: | ||
==If your old device doesn't have the key any more== | ==If your old device doesn't have the key any more== | ||
You can still get a new key by backing up your old databases (/sdcard/WhatsApp/Databases) and then putting the old database you want to look at | You can still get a new key by backing up your old databases (/sdcard/WhatsApp/Databases) and then putting the old database you want to look at there, then reinstalling whatsapp. It will restore from the old database. | ||
=Reading the decrypted database= | =Reading the decrypted database= | ||
Use [https://sqlitebrowser.org/dl/ SQLite browser] | Use [https://sqlitebrowser.org/dl/ SQLite browser] | ||
[https://forum.xda-developers.com/showthread.php?t=2719741 Whatsapp viewer] (also exports to txt html json and allows you to search messages - originally from [https://andreas-mausch.de/whatsapp-viewer/] | [https://forum.xda-developers.com/showthread.php?t=2719741 Whatsapp viewer] (also exports to txt html json and allows you to search messages - originally from [https://andreas-mausch.de/whatsapp-viewer/]. [https://github.com/andreas-mausch/whatsapp-viewerGithub instructions]. [https://github.com/andreas-mausch/whatsapp-viewer/releases/tag/v1.12 Downloads, currently 1.12] | ||
=Merging databases= | =Merging databases= | ||
Latest revision as of 08:18, 15 January 2020
In order to merge databases (msgstore.db.crypt12) you need the key.
Decrypting the message store database
The easiest way to get the key on a rooted device with whatsapp still installed. You can find the key in /data/data/com.whatsapp/files/key.
You can then use an app like omnicrypt (no longer on Google play) to decrypt it. See [1] (don't know if this is obsolete)
OR you can try using adb and the Whatsapp key/db extractor
OR you can try extracting the data from Google Drive, but the Whatsapp Google Drive Extratctor doesn't seem to work any more
If your old device doesn't have the key any more
You can still get a new key by backing up your old databases (/sdcard/WhatsApp/Databases) and then putting the old database you want to look at there, then reinstalling whatsapp. It will restore from the old database.
Reading the decrypted database
Use SQLite browser
Whatsapp viewer (also exports to txt html json and allows you to search messages - originally from [3]. instructions. Downloads, currently 1.12
Merging databases
By updating the IDs from a hand decrypted database using SQLite viewer
Using Java apps after having deduped the databases in SQLite viewer