Skype: how to read a chat message using main.db

Question

I tried to level, but after that I got stuck. Let's share the steps that I followed:

1. I see the file main.dbin this main.db C:\Users\Admin\AppData\Roaming\Skype\paul.lowry198.
2. To open this file, main.dbI installed the SQL Lite BB Browser application .
3. This application can show all existing tables in the database. There is one desktop chats. In this table, I run a query. select * from Chats where friendlyname = 'Jimmy Trevor';The result was 69 results.
4. Now, after that, how to read the message that he wrote, but deleted (or any message) before I could read it.

What could be the correct request that the message can show me?

Answer 1

I did it 4 years ago, and today I need it again.

So, after opening the main.db file with SQLite Browser, you need to:

Define a conversation identifier (one person can be in several conversations):

select conv_dbid, * from Chats where friendlyname like '%Friendly Name%';

OR you can find the desired conversation id using

select * from Conversations where identity like '%accountname%';

Finally, SQL Query to get all messages from the desired conversation:

select body_xml, datetime(timestamp, 'unixepoch'), edited_by, edited_timestamp 
from Messages where convo_id=YOUR_CONVERSATION_ID;

Unfortunately, I found that the field main.db body_xml, edit_by and edit_timestamp change every time someone edits / deletes the message, and there is no backup in body_xml main.db .

---

But don’t worry! There is a chatsync folder next to the main.db database (in your skype / AppData / Roaming / Skype / Account_Name_Folder account folder).

chatsync Skype, , http://www.nirsoft.net/utils/skype_log_view.html

SkypeLogView, skype ( skype, ). .

!

Answer 2

, 2017 Skype Windows 10 (Skype UWP - Universal Windows Platform) main.db

%localappdata%\Packages\Microsoft.SkypeApp_kzf8qxf38zg5c\LocalState\<SkypeUsername>\main.db

%localappdata% C:\Users\<username>\AppData\Local

Answer 3

Skype

: http://www.skypebrowser.com/

1. , Skype ( 30 ). main.db

Locate the main.db file: C: \ Users \\ AppData \ Roaming \ Skype \\ main.db

wait a couple of minutes to download the file: the downloaded main.db file

2. After opening the file, you can export it in html zip format to your local disk using the export button. Export as compressed HTML file
3. Save as file. Save as zip file

Inside the zip file there are all conversations with people or groups in different html files.