yashsingh1/xdaforums huggingface dataset:
[Android Apps and Games] ztedd:
Nokia

No, I haven't tried with Nokia or Blackberry versions. How did you manage to get the .db files from your Nokia phone?
[Android Apps and Games] Xeon:
Great it works, thanks.

Is there any way to convert the sqlite file of iphone to db so i can load it on Android ?
[Android Apps and Games] thesseus01:
ztedd,

I just copied them from the application folder. All you have to do is to kill whatsapp application and use a file browser (different from the one that came by default with symbian).

---------- Post added at 09:20 AM ---------- Previous post was at 08:26 AM ----------

If you want i can send chats.db file to you. I cannot find what type of db file is this. First i thought it is encrypted but when i open it i can see the telephone numbers in plain text but the messages are somehow coded.

I tried to open the db file with sqllite or DBF Viewer 200 but without any success.
[Android Apps and Games] ggclanlord:
This is cool.

Awesome work!
[Android Apps and Games] ztedd:
Technically, that's possible.

For what would you use that for?
[Android Apps and Games] Xeon:
I Have bouth an Xperia S and moving from iPhone, and wish to load the extracted chat history on Android phone.

There are thousands of people looking for something like that on the internet.

If you are willing to continue the application development, I will offer you whatever support you might need.

Regards.
[Android Apps and Games] valek07:
Blackberry Decryption

Hello Ztedd,

I have found on the internet and also confirmed it with your source code that the code to decrypt the database in Android is: 346a23652a46392b4d73257c67317e352e3372482177652c. Is it not the same one from the blackberry file messageStore.db?

If you guys were able to decrypt Android and iPhone databases I'm sure you would be able to decrypt Blackberry ones as well right?

I have a messageStore.db file that I extracted from the microSD while plugging in my blackberry to the PC that I would be willing to share with you to help.

Let me know your thoughts. Thanks! :)
[Android Apps and Games] viralbug:
Firstly I'd like to thank you for making this awesome tool!

So I got the tool to work on an Android database file. It shows all the chats correctly and also a few images. However, it doesn't extract a few other images that I need. :(

Here's what I'm trying to do. I had downloaded a received image on my phone, but I deleted it and now need it again. Whatsapp doesn't allow me to download the image again. So I used your tool to extract from the database. The tools works fine and even manages to extract some older images I received, but it is unable to extract the images I need. :(

I have tried extracting using database file from data/data/com.whatsapp as well as the db file in /sdcard/whatsapp/databases, but I get the same result.

While the script is running, it displays the message "trying to repair android database" before beginning to extract. Is that the reason for the image files not to be visible?

I'm using Whatsapp Xtract v2.1 and Whatsapp 2.7.7532 on Android.
[Android Apps and Games] micarro:
Hello!

I have the next problem:

http: //dl.dropbox.com/u/58890906/Dibujo.jpg

It says that I have to install Business Edition. What can I do?

---------- Post added at 09:33 AM ---------- Previous post was at 08:40 AM ----------

Solved! Just install Python 2.7 x86 even if your computer is 64-bit
[Android Apps and Games] ztedd:
Exactly, like pointed in the HowTo:
[Android Apps and Games] ztedd:
Whatsapp Xtract can only convert what is given - if an image is deleted, it can't be linked and opened as big image. However you might have noticed that the Android version still displays the thumbnail of the image - better than nothing, I guess.

How old is the image? If it's within the last ~ 3 weeks, then you can click on the left link (the one with the thumbnail) and download the image from the whatsapp server. If it's older, this won't work.

If the image is deleted from the Media folder and it was sent by you, then you can try to find it in the DCIM / Camera folder. If it was received, then the only way would be to use forensic data recovery tools to try to recover the deleted file and then copy it in the Media/WhatsApp Images folder again.

No, that isn't linked to your problem. This message appears each time you give a crypted (or corrupted) database file. However the images (not the thumbnails) are stored on the SD card in the Media folder, not inside the database file. So it doesn't matter here.
[Android Apps and Games] ztedd:
Blackberry

In fact, they got the code from us and we got it from https://www.os3.nl/_media/2011-2012/students/ssn_project_report.pdf, but they don't give the credits... ;)

No. As you can read in the linked PDF, the encryption method on Blackberry is different. It uses the strong Blackberry encryption. You would need to use some Blackberry-specific tools to get the unencrypted db file providing your Blackberry encryption key. I guess this method should be the same for all kinds of (internal) data in the Blackberry. However it might not be part of the Blackberry concept to be able to access those files. Anyway, I have no idea on how to do this.

It seems that at least for older versions of whatsapp, some guys on the internet were able to get an unencrypted database file. You might google and ask them how...
[Android Apps and Games] ztedd:
conversion between Iphone and Android database

You might be right, but you know, it's a problem of time and money :(

The conversion feature seems interesting, but to me it seems not to be the highest priority. As to explain: I even delete the whole chat history quite regularly, since the database file is always growing bigger and bigger and so filling the internal space. Furthermore, it's just too much hassle to press the "load older messages" button again and again and again... to reach the very old messages. Do you ever do that in fact?

I guess it should be much easier to just watch the older messages on PC or copy the ChatStorage.sqlite.html file on your android.

However if there would be really such a great demand and the money to finance that, it is quite feasible.
[Android Apps and Games] DN41:
Works fine so far, but only after I manually copy python.exe to the .bat's directory.

Usual bug?

DN41
[Android Apps and Games] silentvisitor:
Old database files

Hello,

First of all, Thank You developers for such an useful tool. Could prove very useful to many.

I've a question to which I already know the answer but still trying my luck.

I've several old databases ranging from crypt8 to crypt12 (I take backup, store database file on PC and clear entire WA once a year) but WITHOUT KEY ? Any remotest possibility to even just view them?

Thank you in advance !!!
[Android Apps and Games] PIRATA!:
Hello there!

Is there a way with this app to view individual conversations/groups within all their images and video sent?

I have my full WhatchApp folder backup on my computer, so all media in there as well.

What I need to do is to have an idea of the media content of each chat/group so to identify them and delete media that I'm not interested with.

I have 13 Gb of images and videos in total, and from WhatsApp I see that the media from the 3 or 4 chats/groups I would like to keep media are about 5 Gb, so all the other stuff is rather old from old versions of WhatApp and no more able to be deleted using the built-in WhatApp storage cleaner, or from chats/groups from which I don't care keeping them.

I would like to identify all related linked media in my chats and delete what does not belong to them. Is it possible?

Thank you in advance.
[Android Apps and Games] adambuzz:
Hi

Thanks for this useful tool.

I have a number of whats app backups from 2013, and i am trying to read them due to a death in the family.

They are old files, so they are only .db.crypt.

I can decrypt the files fine with your software, and i end up with all my .crpyt files as .db files. I know the data is in the files as if i open them with note pad, i can see all the messages, although a little hard to read this way.

I then try to use your tool to export my .db files as a nice readable HTML, but this will only work on my small 500KB .db file. My other .db files which have far more messages and are around 8,000KB, the export process times out during the upload process and i end up with ''

Gateway Timeout

The gateway did not receive a timely response from the upstream server or application.

Additionally, a 504 Gateway Timeout error was encountered while trying to use an ErrorDocument to handle the request.''

Is there anyway to avoid this? Is there a file size issue? I don't mind doing this process offline, but the only app i can find in your downloads is android apk, and this doesnt have the option to export the chats.

Thanks in advance
[Android Apps and Games] depii:
my condolences.

I am not sure what exactly you are doing. The timeout looks like you are using a web server. You have to run the Python script locally. I had never problems with very big files. So on a console like this:

python whatsapp_xtract.py -w wa.db msgstore.db

for best results, copy the entire whatsapp folder unchanged onto the hard drive. place the DB files and the extract file inside the main folder. In this way the photos and voice messages are found and linked in the HTML output.

WhatsApp/
├── msgstore.db
├── wa.db
├── whatsapp_xtract.py
├── Media/
│ ├── WhatsApp Audio/
│ ├── WhatsApp Images/
│ ├── WhatsApp Video/
│ └── WhatsApp Voice Notes/
└── Backups/
└── Databases/
[Android Apps and Games] adambuzz:
Thanks for your reply. I am using the web versions found at https://whatcrypt.com/

Maybe this is a different tool all together, but when it works it is good.

I am not familiar with python scripts, are you able to talk me through it?

As i say, i already have my .db.crypt files decrypted to .db files, i just need to export them to a suitable format to read them
[Android Apps and Games] depii:
i would never send my chats to an online service. using python on a linux machine such as ubuntu would be relatively easy. I have no experience with windows. try point 4 in first posting.
[Android Apps and Games] dadnammit:
Sounds like you already have access to the decrypted msgstore.db file?

If so, you should be able to view the contents with the process below.

----------

If not, or for those who need to get the unencrypted files off their device for viewing, you can do that if you have root using adb. The following files are useful to extract and backup:

unencrypted database:

/data/data/com.whatsapp/databases/msgstore.db

contacts database:

/data/data/com.whatsapp/databases/wa.db

key for .crypt12 db backups:

/data/data/com.whatsapp/files/key

WhatsApp profile:

/data/data/com.whatsapp/shared_prefs/com.whatsapp_preferences.xml

Connect with adb and use commands such as the following to copy the above files:

adb shell
mkdir /sdcard/data/adb
su
cp /data/data/com.whatsapp/databases/msgstore.db /sdcard/data/adb/
cp /data/data/com.whatsapp/databases/wa.db /sdcard/data/adb/
cp /data/data/com.whatsapp/files/key /sdcard/data/adb
exit
exit
mkdir C:\whatsapp-backup
adb pull /sdcard/data/adb/msgstore.db C:\whatsapp-backup
adb pull /sdcard/data/adb/wa.db C:\whatsapp-backup
adb pull /sdcard/data/adb/key C:\whatsapp-backup

----------

The contents of these files are explained in more detail here:

Blog Group-IB

The Official Blog from Group-IB

www.group-ib.com

Once you have the files available locally, the following windows application lets you view the messages in a friendly UI format:

WhatsApp Viewer

andreas-mausch.de
[Android Apps and Games] adambuzz:
Hi dadnammit, thanks for your reply.

Yes, i have all my files decrypted already, but the whatsapp viewer tool doesn't want to show them. I get an error

'‘could not load the chat list; SQLite error1; no such column: chat_list.subject’'

I have emailed andreas to see why this error is coming up. I know the data is there and the .db files can be exported, as when the whatcrypt tool works and doesn't time out, it works fine and i can get a full html whats app chat from these .db files.
[Android Apps and Games] LayerEight:
Its a bit off topic, but is there a way to import my extracted WhatsApp DB to Signal or Whatsapp ( including picture and video attachements ) ?
[Android Apps and Games] sieger007:
I am in a situation where the source msgstore.db ( nick : m_db ) contains overlapping info wrt target m_db and there is a good 2+ yr difference between src and target. Running the update gives me unique key violation message . How to handle a merge given this situation.

Src m_db : common_info c1 | missing info | commoninfo c2

taarget m_db : c1 common_info | c2 commoninfo | extra info

Desired m_db :

Src m_db : c1 common_info | missing info | c2 commoninfo | extra info
[Android Apps and Games] elytron01:
Hey there, i have root on my phone and did all the steps mentioned in the thread. But when i run whatsapp_xtract_android.bat a command prompt opens and tells me to press a key and then closes without doing anything. When i open the db with whatsapp-viewer from andreas mausch, i can view all messages but then again, when i want to export to html it gives me a error: "could not open chat export file".

Any solution for this?
[Android Apps and Games] stephriokruse:
Hello, I find my old Xperia arc with a SD card (phone is clean all files are on the SD ) ,I find my old back up file name msgstore-2012-12-29_1_db-1.crypt how can I open have windows 10 tanks for help

Steph
[Android Apps and Games] alecxs:
you can't. see post #1387 key for .crypt12 db backups (which is the main purpose of this whole thread)
[Android Apps and Games] stephriokruse:
Hi tanks but I have just the backup file and it's a crypt with no number not a crypt 12
[Android Apps and Games] nioBee:
if it's an old unencrypted backup then you just need a reader.. this one should work.

GitHub - andreas-mausch/whatsapp-viewer: Small tool to display chats from the Android msgstore.db database (crypt12)

Small tool to display chats from the Android msgstore.db database (crypt12) - andreas-mausch/whatsapp-viewer

github.com

https://xdaforums.com/t/tool-whatsapp-viewer-for-pc.2719741/
[Android Apps and Games] stephriokruse:
Tanks I try tomorrow, yes it's a old crypt from 2012 with no number after crypt
[Android Apps and Games] stephriokruse:
Hello so i tray don't working, don't see msgstore.db.crypt in the WhatsApp folder but wenn I change the name in msgstore.deb I see but after I have errors what can I do? tanks
[Android Apps and Games] hansxl:
Till about a week ago this tool worked perfectly for me, but I think Whatsapp has changed something and now (since august 10th) I get this :

Python Version 3.x

Android mode!

trying to repair android database...

trying to decrypt android database...

Traceback (most recent call last):

File "whatsapp_xtract.py", line 1353, in main

c1.execute("SELECT * FROM chat_list")

sqlite3.OperationalError: no such table: chat_list

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "whatsapp_xtract.py", line 1371, in main

c1.execute("SELECT * FROM chat_list")

sqlite3.OperationalError: no such table: chat_list

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "whatsapp_xtract.py", line 2479, in <module>

main(sys.argv[1:])

File "whatsapp_xtract.py", line 1380, in main

from Crypto.Cipher import AES

ModuleNotFoundError: No module named 'Crypto'

Anyone knows what happended:unsure:
[Android Apps and Games] adflyer:
The database in the Whatsapp backup no longer contains the chat_list table. (at least the backup produced by version 2.21.15.20 I have installed doesn't). This tool clearly expects/needs that table to be present and errors out because it's not there.
[Android Apps and Games] MichaelKnight:
Hi everyone,

I am trying to recover my old conversations from my Nokia Symbian S60.

I used the console but I got the following error.

Apparently, the encrytion by default is not the same as the older versions.

Could anyone tell me the right encryption and the way to set it in the extraction tool, please?
[Android Apps and Games] MichaelKnight:
I reply myself. I cannot use this file to get anything from Whatsapp conversations.
[Android Apps and Games] Fixxtr:
How to recover/see deleted messages within a Chatstorage.sqlite file?
[Android Apps and Games] alecxs:
https://www.staff.hs-mittweida.de/~pawlaszc/fqlite
[Android Apps and Games] vamsi209:
so anyone can explain the sqlite structure of msgstore.db? how can i know the numbers of participants in a group from the database? is it even stored in msgstore.db?

thanks
[Android Apps and Games] borisvp:
Hi,

I hope somebody can help me here.

I have an old HTC Sense mobile phone with Android 4.0.3. WhatsApp version is 2.6.9458, the msgstore is a crypt8 file (msgstore.db.crypt8). It has a chat which I would very much like to revocer and save on PC. All files are in the folder WhatsApp in the phone's main storage.

Whatsapp Xtract returns "No module named Crypto.Cipher". Same happens with the console.bat and "python whatsapp_xtract.py msgstore.db". I have copied the crypt8 file to the Whatsapp_Xtract folder and renamed it to msgstore.db.crypt.

I have installed Python27 and PyCrypto 2.6.1 (but no idea if set up correctly).

I have also tried WhatsAPP-Key_DB-Extractor, which connects to the phone and does a backup but downloads nothing (all 0 in the download message line). I followed the instructions in this thread: https://xdaforums.com/t/tool-whatsa...pt6-12-non-root-updated-october-2016.2770982/

Java is version 1.8.0_371.

Regards

Boris
[Android Apps and Games] alecxs:
WhatsAPP-Key_DB-Extractor is the most important thing. without the key you cannot decrypt. as it seems you're running ancient android version, there exist methods to achieve root access without factory reset. so find any method to extract the key first.
[Android Apps and Games] borisvp:
I thought so, but I don't know how to. Thing is, this Android version doesn't do anything useful internet wise anymore. I cannot log in to any accounts or install any apps via the web.

Any hints as to where to look?
[Android Apps and Games] alecxs:
Not in this thread. start reading here (#525) and stop reading here (#699) the solution is somewhere in that last 10 pages of the other thread (not my posts, can't tell you unfortunately)

for rooting without factory reset you need to run dirtyc0w exploit, search for or ask here.

https://xdaforums.com/t/ask-any-question-newbie-friendly.2259645

the third and maybe easiest option is to read flash storage "offline" in emergency download mode. best is open new thread and provide more information about phone model.
[Android Apps and Games] c3lly:
Not works? Update pls! Love!
[Android Apps and Games] ztedd:
It seems that on some windows computers, ActivePython doesn't install correctly (i.e. making the "python" command global).

I don't know why this happens. Maybe you can provide some more information like which windows you use and so on.

Maybe you need to install ActivePython with Administrator rights, or you need to reboot, or you need to check more options during install process.

You might try around a bit and tell me the results.
[Android Apps and Games] viralbug:
Thank you for your reply.

Yes I understand that the tool won't extract the actual image since it is stored on the SD card. What I meant to say was that in place of the media, it shows "N/A" in message content without any link or thumbnail. It does show media type as 1 and also shows the media size correctly. It's not even been a day since I received these images. I can even view a few older images from a few days ago, but I can't see these ones. :( For the older images I get a thumbnail as well as a link for the image on the Whatsapp server.

I'll also add that the contact name column shows the number and not the name and the status, #msg, #unread msgs columns also show N/A for all chats.
[Android Apps and Games] ztedd:
Okay, thanks, this looks somehow like the android whatsapp database structure changed. Maybe you could send me a screenshot of the newer message entries in the database using SQLite Database Browser. You may blacken parts of private data.
[Android Apps and Games] ztedd:
In the new update, it's fixed.

As well as this one:

If someone gets the error that "python" is not found, download the current archive, after install of Activepython run install pyCrypto.bat at first, then Whatsapp Xtract scripts should work.

Download links of the new update as always in the first post.
[Android Apps and Games] matchung:
latest one (05-10) has problem, not working, which 05-07 works fine.

Traceback (most recent call last):
File "Whatsapp_Xtract\whatsapp_xtract.py", line 2058, i
n <module>
main(sys.argv[1:])
File "Whatsapp_Xtract\whatsapp_xtract.py", line 1210, i
n main
curr_message = Message(msgs["_id"],msgs["key_from_me"],msgs["timestamp"],msg
s["data"],contactfrom,msgs["status"],msgs["media_name"],msgs["media_url"],msgs["
raw_data"],None,msgs["media_wa_type"],msgs["media_size"],msgs["latitude"],msgs["
longitude"],None,None)
IndexError: No item with that key
[Android Apps and Games] DN41:
Windows 7 Home Premium x64 SP1.

Installed as Admin and clicked as much as I could :DD

DN41
[Android Apps and Games] ztedd:
fixed.
[Android Apps and Games] kondorkondor:
unrecognized arguments: -i

Thanks!!!
[Android Apps and Games] matchung:
thx, it works again.

maybe you should update the instruction in whatsapp_xtract.py. there is no '-i' argument available ^-^

whatsapp_xtract.py: error: unrecognized arguments: -i

im running on win7x64, no sure it is OS related or not.
[Android Apps and Games] viralbug:
Thanks! It works perfectly now! You're a workhorse! :D
[Android Apps and Games] mko87:
Hi, i have a error

What is it?

cu
[Android Apps and Games] ztedd:
Can you please try to repair the decrypted database (it should exist a file called msgstore.plain.db or somehow like this) like explained in the post Some Additional Information:

Does that work?
[Android Apps and Games] mko87:
- echo .quit | sqlite3.exe -init Temp.sql msgstore_new.db

This comand will generate the msgstore_new.db with 0KB.

python whatsapp_xtract.py msgstore_new.db

has a error called

"Could not open database file. Guess it's not a valid Android or Iphone database file."

I will backup again the database and Copy it to my pc to try it again. Maybe i have an CRC error at the Copy.

But thanks for your help!
[Android Apps and Games] ztedd:
What is the size of the msgstore.plain.db and of Temp.sql?

Okay.