Choose dates to faster up search process. Here is the start dialog of SkypeLogView, it automatically selects your skype directory (better close your skype application, but it is not necessary). Unfortunately I discovered that main.db fields body_xml, edited_by and edited_timestamp changed every time person editing/deleting message and there is no backup of body_xml in main.db.īut don't worry! There is a folder chatsync near main.db database (in your skype account folder /AppData/Roaming/Skype/Account_Name_Folder).Īll messages in chatsync is in Skype binary format, to read them you can use lightweight free utility OR you can find desired conversation id using select * from Conversations where identity like '%accountname%' įinally, SQL Query to get all messages from desired conversation: select body_xml, datetime(timestamp, 'unixepoch'), edited_by, edited_timestampįrom Messages where convo_id=YOUR_CONVERSATION_ID So after opening main.db file using SQLite Browser you need to:ĭetermine id of conversation (one person could be in multiple conversations): select conv_dbid, * from Chats where friendlyname like '%Friendly Name%' I've done this 4 years ago and today I need that again. Skype vs Discord: In-Depth Comparison of Voice and Text Chat Skype and Discord are similar apps that allow users to connect over VoIP, chat, voice calls, video calls, and group meetings.

How to use skype chat