To encrypt the file back, we will need to run openssl with the same key. Now, the output file can be read using the sqlite3 program or any other SQLite ~] $ sqlite3 msgstore.dbĮnter SQL statements terminated with a ' 'ĬREATE TABLE chat_list (_id INTEGER PRIMARY KEY AUTOINCREMENT, key_remote_jid TEXT UNIQUE, message_table_id INTEGER, subject TEXT, creation INTEGER) ĬREATE TABLE messages (_id INTEGER PRIMARY KEY AUTOINCREMENT, key_remote_jid TEXT NOT NULL, key_from_me INTEGER, key_id TEXT NOT NULL, status INTEGER, needs_push INTEGER, data TEXT, timestamp INTEGER, media_url TEXT, media_mime_type TEXT, media_wa_type TEXT, media_size INTEGER, media_name TEXT, latitude REAL, longitude REAL, thumb_image TEXT, remote_resource TEXT, received_timestamp INTEGER, send_timestamp INTEGER, receipt_server_timestamp INTEGER, receipt_device_timestamp INTEGER, raw_data BLOB, media_hash TEXT, recipient_count INTEGER, media_duration INTEGER, origin INTEGER) ĬREATE UNIQUE INDEX messages_key_index on messages (key_remote_jid, key_from_me, key_id) The command will take the msgstore.db.crypt file as an input (specified with the -in option), perform AES decryption and write the output file to msgstore.db (specified with the -out option). Open a shell or command prompt window and run openssl as shown. sdcard/WhatsApp/Databases/msgstore.db.crypt On Android, pull the encrypted file from your phone at the below location: There are several tools available to decrypt the WhatsApp chats, but what we need is just the openssl utility.

If you want to read the messages on a computer, you will need to decrypt the file.

On Android, this backup is an encrypted copy of the SQLite database containing all of the WhatsApp messages.

WhatsApp does a backup of the messages at 4am (local time) every day to the SD card.

Open whatsapp msgstore.db.crypt