blocks|key|1783823|text|我四年前就做过这件事了，今天我又需要它了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1783824|因此，在使用main.db浏览器打开SQLite文件之后，您需要：|1783825|确定对话的id+(一个人可能在多个对话中)：|1783826|select+conv_dbid,+*+from+Chats+where+friendlyname+like+'%25Friendly+Name%25';|code-block|syntax|javascript|1783827|或者您可以使用|1783828|select+*+from+Conversations+where+identity+like+'%25accountname%25';|1783829|最后，查询从所需会话中获取所有消息：|offset|length|style|BOLD|1783830|select+body_xml,+datetime(timestamp,+'unixepoch'),+edited_by,+edited_timestamp+
from+Messages+where+convo_id=YOUR_CONVERSATION_ID;|1783831|不幸的是，我发现main.db字段body_xml、edited_by和edited_timestamp每次用户编辑/删除消息时都会发生更改，而在main.db中没有body_xml的备份。|1783832|但是不用担心！在skype帐户文件夹/AppData/漫游/Skype/_Name_中，main.db数据库附近有一个文件夹main.db+chatsync。|1783833|chatsync中的所有消息都是Skype二进制格式，要读取它们，可以使用轻量级免费实用程序view.html。|1783834|下面是SkypeLogView的“开始”对话框，它会自动选择skype目录(最好关闭skype应用程序，但这是不必要的)。选择日期以加快搜索过程。|1783835|​|1783836|📷|atomic|1783837|瞧！|1783838|entityMap|0|LINK|mutability|MUTABLE|url|http://www.nirsoft.net/utils/skype_log_view.html|1|IMAGE|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/133e0ba2f9f637713a268a3a4e04c0e9.png|imageAlt^0|0|0|0|0|0|0|3|F|0|0|8|7|20|8|0|10|6|0|0|8|1A|9|0|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|1P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1R|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|1S|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|1T|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|1U|8|@]|9|@]|A|$I|J]]|$1|O|3|P|5|6|7|1V|8|@$Q|1W|R|1X|S|T]]|9|@]|A|$]]|$1|U|3|V|5|H|7|1Y|8|@]|9|@]|A|$I|J]]|$1|W|3|X|5|6|7|1Z|8|@$Q|20|R|21|S|T]|$Q|22|R|23|S|T]]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|24|8|@$Q|25|R|26|S|T]]|9|@]|A|$]]|$1|10|3|11|5|6|7|27|8|@$Q|28|R|29|S|T]]|9|@$Q|2A|R|2B|1|2C]]|A|$]]|$1|12|3|13|5|6|7|2D|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|2E|8|@]|9|@]|A|$]]|$1|16|3|17|5|18|7|2F|8|@]|9|@$Q|2G|R|2H|1|2I]]|A|$]]|$1|19|3|1A|5|6|7|2J|8|@]|9|@]|A|$]]|$1|1B|3|-4|5|6|7|2K|8|@]|9|@]|A|$]]]|1C|$1D|$5|1E|1F|1G|A|$1H|1I]]|1J|$5|1K|1F|1L|A|$1M|1N|1O|-4]]]]

I've done this 4 years ago and today I need that again.

So after opening main.db file using SQLite Browser you need to:

Determine id of conversation (one person could be in multiple conversations):

<pre><code>select conv_dbid, * from Chats where friendlyname like '%Friendly Name%';
</code></pre>

OR you can find desired conversation id using 

<pre><code>select * from Conversations where identity like '%accountname%';
</code></pre>

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

<pre><code>select body_xml, datetime(timestamp, 'unixepoch'), edited_by, edited_timestamp 
from Messages where convo_id=YOUR_CONVERSATION_ID;
</code></pre>

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. 

<hr>

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

All messages in chatsync is in Skype binary format, to read them you can use lightweight free utility <a href="http://www.nirsoft.net/utils/skype_log_view.html" rel="noreferrer">http://www.nirsoft.net/utils/skype_log_view.html</a>

Here is the start dialog of SkypeLogView, it automatically selects your skype directory (better close your skype application, but it is not necessary). Choose dates to faster up search process.

<a href="https://i.stack.imgur.com/gKlYg.png" rel="noreferrer"><img src="https://i.stack.imgur.com/gKlYg.png" alt="SkypeLogView start dialog"></a>
Voila!

blocks|key|1783859|text|请注意，截至2017年4月和新的Skype+for+Windows+10+(Skype+UWP+-通用Windows平台)，main.db文件已移至|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1783860|%25localappdata%25\Packages\Microsoft.SkypeApp_kzf8qxf38zg5c\LocalState\<SkypeUsername>\main.db|1783861|%25localappdata%25是C:\Users\<username>\AppData\Local|1783862|entityMap^0|1Q|7|0|0|2J|0|0|E|F|X|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|R|8|@$9|S|A|T|B|C]|$9|U|A|V|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|K|$]]

Note that as of April 2017 and the new Skype for Windows 10 (Skype UWP - Universal Windows Platform), the <code>main.db</code> file has moved to 

<code>%localappdata%\Packages\Microsoft.SkypeApp_kzf8qxf38zg5c\LocalState\&lt;SkypeUsername&gt;\main.db</code>

with <code>%localappdata%</code> being <code>C:\Users\&lt;username&gt;\AppData\Local</code>

blocks|key|1737559|text|浏览并导出您的Skype历史记录在线|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1737560|我最近使用了以下平台：http://www.skypebrowser.com/|1737561|步骤|1737562|点击上传你的Skype数据库(最多30+MB)。从本地磁盘查找main.db|ordered-list-item|1737563|查找main.db文件:+C:\Users\AppData\Roaming\Skype\main.db|1737564|等几分钟上传文件：上传main.db文件|1737565|打开文件后，可以使用导出按钮将html压缩文件导出到本地磁盘。导出为压缩的html文件|1737566|保存为文件。保存为zip文件|1737567|在zip文件中，存在与不同html文件中的人或组的所有对话。|1737568|entityMap|0|LINK|mutability|MUTABLE|url|http://www.skypebrowser.com/|1|https://i.stack.imgur.com/zgD0c.png|2|https://i.stack.imgur.com/EQqLm.png|3|https://i.stack.imgur.com/mOsjN.png|4|https://i.stack.imgur.com/kMTTO.png^0|0|I|0|B|S|0|0|0|2|0|O|E|1|0|0|9|B|2|0|V|C|3|0|6|8|4|0|0^^$0|@$1|2|3|4|5|6|7|1C|8|@$9|1D|A|1E|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1F|8|@]|D|@$9|1G|A|1H|1|1I]]|E|$]]|$1|H|3|I|5|6|7|1J|8|@$9|1K|A|1L|B|C]]|D|@]|E|$]]|$1|J|3|K|5|L|7|1M|8|@]|D|@$9|1N|A|1O|1|1P]]|E|$]]|$1|M|3|N|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|1R|8|@]|D|@$9|1S|A|1T|1|1U]]|E|$]]|$1|Q|3|R|5|L|7|1V|8|@]|D|@$9|1W|A|1X|1|1Y]]|E|$]]|$1|S|3|T|5|L|7|1Z|8|@]|D|@$9|20|A|21|1|22]]|E|$]]|$1|U|3|V|5|6|7|23|8|@]|D|@]|E|$]]|$1|W|3|-4|5|6|7|24|8|@]|D|@]|E|$]]]|X|$Y|$5|Z|10|11|E|$12|13]]|14|$5|Z|10|11|E|$12|15]]|16|$5|Z|10|11|E|$12|17]]|18|$5|Z|10|11|E|$12|19]]|1A|$5|Z|10|11|E|$12|1B]]]]

Browse and export your Skype history online

I recently used the following platform :
<a href="http://www.skypebrowser.com/" rel="nofollow noreferrer">http://www.skypebrowser.com/</a>

Steps

<ol>
<li>Click to upload your Skype database (Max 30 MB). 
<a href="https://i.stack.imgur.com/zgD0c.png" rel="nofollow noreferrer">find main.db from local disk</a></li>
</ol>

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

wait a couple minutes to upload the file:
<a href="https://i.stack.imgur.com/EQqLm.png" rel="nofollow noreferrer">Uploaded main.db file</a>

<ol start="2">
<li>After open file, you can export as html zip file to your local disk, with export button. <a href="https://i.stack.imgur.com/mOsjN.png" rel="nofollow noreferrer">Export as zipped html file</a></li>
<li>Save as the file. 
<a href="https://i.stack.imgur.com/kMTTO.png" rel="nofollow noreferrer">Save as the zip file</a></li>
</ol>

Inside zip file, exist all conversations with people or groups in different html files.

I have tried upto a level but after that I am stuck. Let share steps I followed:

<ol>
<li>I can see <code>main.db</code> file at this location <code>C:\Users\Admin\AppData\Roaming\Skype\paul.lowry198</code>. </li>
<li>To open this <code>main.db</code> file I have installed <a href="http://sqlitebrowser.org/" rel="noreferrer">SQL Lite BB Browser</a> application. </li>
<li>This application can show all existing tables in DB. There is one table <code>chats</code>. On this table I am firing a query <code>select * from Chats where friendlyname = 'Jimmy Trevor';</code> It resulted 69 results.</li>
<li>Now after this how to read the message that he wrote but deleted(or any message) before I could read it.</li>
</ol>

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

skype: how to read chat message using main.db

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我试着达到一个水平，但在那之后，我被困住了。让我们分享我遵循的步骤：我可以在这个位置看到main.db文件，C:\Users\Admin\AppData\Roaming\Skype\paul.lowry198。要打开这个main.db文件，我已经安装了应用程序。此应用程序可以显示DB中的所有现有表。有一张桌子chats...

问skype:如何使用main.db读取聊天消息
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问skype:如何使用main.db读取聊天消息EN