WhatsApp Data Extractor

whatsapp_data_extractor.sh

rm -r /storage/emulated/0/whatsapp_exports
mkdir -v /storage/emulated/0/whatsapp_exports
cp -r /data/data/com.whatsapp/files/Stickers /storage/emulated/0/whatsapp_exports
mkdir /storage/emulated/0/whatsapp_exports/Avatars
mkdir /storage/emulated/0/whatsapp_exports/AvatarsThumbnail
cp /data/data/com.whatsapp/files/Avatars/* /storage/emulated/0/whatsapp_exports/AvatarsThumbnail
cp /data/data/com.whatsapp/cache/Profile\ Pictures/* /storage/emulated/0/whatsapp_exports/Avatars
cp /data/data/com.whatsapp/files/me.jpg /storage/emulated/0/whatsapp_exports/Avatars
cp /data/data/com.whatsapp/files/status /storage/emulated/0/whatsapp_exports/status.txt
cp /data/data/com.whatsapp/files/statistics.json /storage/emulated/0/whatsapp_exports
mkdir /storage/emulated/0/whatsapp_exports/databases
cp /data/data/com.whatsapp/databases/msgstore.db /storage/emulated/0/whatsapp_exports/databases
cp /data/data/com.whatsapp/databases/wa.db /storage/emulated/0/whatsapp_exports/databases
cp /data/data/com.whatsapp/databases/chatsettings.db /storage/emulated/0/whatsapp_exports/databases
cp /data/data/com.whatsapp/databases/web_sessions.db /storage/emulated/0/whatsapp_exports/databases
cp /data/data/com.whatsapp/databases/stickers.db /storage/emulated/0/whatsapp_exports/databases
cp -r /data/data/com.whatsapp/files/Wallpapers /storage/emulated/0/whatsapp_exports

for file in /storage/emulated/0/whatsapp_exports/AvatarsThumbnail/*.j; do mv "$file" "$file.jpg"; done
for file in /storage/emulated/0/whatsapp_exports/Wallpapers/*; do mv "$file" "$file.jpg"; done

WhatsApp Data Extractor

A script to automatically extract Profile Pictures, databases, stickers, wallpapers and more from WhatsApp's files.

Story

After I created my script to automatically extract photos and videos from Snapchat,
I thought I could do the same for WhatsApp.

So with the root access I have, I searched through the files of WhatsApp and created a script to collect all the interesting stuff.

How to use

The script is written in a way, such that one can just copy the entire script and paste it into their phones shell.

You need superuser / root privileges for this to work!

1. Enable Android USB Debugging
2. Connect the device to your computer
3. Open a terminal
4. Run adb shell
5. Run su to elevate to root privileges
6. Copy the entire script
7. Paste it into the terminal, you might need to press enter once after pasting
8. The script now copies and processes WhatsApp's data
9. When it finishes, you will find the result on your phone in a folder named whatsapp_exports.

To download the extracted data:

1. Open a terminal in the folder where the results folder should be copied to
2. Run adb pull /storage/emulated/0/whatsapp_exports
3. When it finishes, you will find the resulting data in the folder whatsapp_exports

Description of extracted data

Folder	What the folder contains	Additional information
Avatars	Full-resolution profile pictures	For a picture to be saved here, you must have opened the profile picture on your phone lately.
AvatarsThumbnail	Small profile picture thumbnails
databases	The most interesting databases	Read more on how to open these files below.
Wallpapers	The currently used chat background wallpaper
Stickers	Stickers	I guess this contains all of your stickers and stickers you received lately.

The files statistics.json and status.txt are just text files and should be opened as such. status.txt might need advanced text editors, as it's charset is kinda non-standard.

The databases are sqlite3 databases.
They can be queried with sqlite3 <file.db> <SQL-query>,
but they can be more easily examined using a db browser.

Database name	What it contains
msgstore.db	All written and received messages
wa.db	Metadata about contacts and profiles
chatsettings.db
stickers.db	Metadata about sticker packs
web_sessions.db	Metadata about connected WhatsApp Web sessions