Skype main.db
From Just Solve the File Format Problem
(Difference between revisions)
(Created page with "{{FormatInfo |formattype=electronic |subcat=Telephony |extension={{ext|db}} |released=2008 }} From 2008<ref>O'Connor, T.J. ''Violent Python: A Cookbook For Hackers, Forensic ...") |
m (Test edit to see if changes are possible with problems) |
||
Line 5: | Line 5: | ||
|released=2008 | |released=2008 | ||
}} | }} | ||
+ | <!--Test to see if it's possible to edit --> | ||
From 2008<ref>O'Connor, T.J. ''Violent Python: A Cookbook For Hackers, Forensic Analysts, Penetration Testers And Security Engineers''. Elsevier, 2013. p. 110. [https://archive.org/details/ViolentPythonACookbookForHackersForensicAnalystsPenetrationTestersAndSecurityEngineers/page/n109?q=main.db IA link]</ref><ref>https://web.archive.org/web/20080716022445/http://www.skype.com/intl/en/download/skype/windows/beta/ Note the date.</ref> to 2017<ref name="MS_QA">https://answers.microsoft.com/en-us/skype/forum/all/where-is-the-maindb-file-for-new-skype/b4d3f263-a97e-496e-aa28-e1dbb63e7687</ref>, the [[Telephony|VoIP]] + [[E-Mail,_newsgroups,_and_forums#Chat.2C_Texting_and_Instant_Messaging|chat]] program [[Skype]] stored the most accessible copy of its message and call history in an [[SQLite]] database named '''main.db'''. After version 12 was released in 2017, message history was instead kept in a slightly different database called [[skype.db]], although main.db remains in the filesystem.<ref name="MS_QA" /><ref>https://answers.microsoft.com/en-us/skype/forum/skype_windesk-skype_messms-skype_sms/sqlite-maindb-file/75258f84-4b2d-4284-82b0-958bed9f3b36</ref>. Much of the information stored in main.db, and some that wasn't (namely "deleted" messages), was also stored in [[Pre-2017 Skype chatsync|a directory structure called "chatsync"]]. | From 2008<ref>O'Connor, T.J. ''Violent Python: A Cookbook For Hackers, Forensic Analysts, Penetration Testers And Security Engineers''. Elsevier, 2013. p. 110. [https://archive.org/details/ViolentPythonACookbookForHackersForensicAnalystsPenetrationTestersAndSecurityEngineers/page/n109?q=main.db IA link]</ref><ref>https://web.archive.org/web/20080716022445/http://www.skype.com/intl/en/download/skype/windows/beta/ Note the date.</ref> to 2017<ref name="MS_QA">https://answers.microsoft.com/en-us/skype/forum/all/where-is-the-maindb-file-for-new-skype/b4d3f263-a97e-496e-aa28-e1dbb63e7687</ref>, the [[Telephony|VoIP]] + [[E-Mail,_newsgroups,_and_forums#Chat.2C_Texting_and_Instant_Messaging|chat]] program [[Skype]] stored the most accessible copy of its message and call history in an [[SQLite]] database named '''main.db'''. After version 12 was released in 2017, message history was instead kept in a slightly different database called [[skype.db]], although main.db remains in the filesystem.<ref name="MS_QA" /><ref>https://answers.microsoft.com/en-us/skype/forum/skype_windesk-skype_messms-skype_sms/sqlite-maindb-file/75258f84-4b2d-4284-82b0-958bed9f3b36</ref>. Much of the information stored in main.db, and some that wasn't (namely "deleted" messages), was also stored in [[Pre-2017 Skype chatsync|a directory structure called "chatsync"]]. |
Revision as of 02:01, 15 April 2019
From 2008[1][2] to 2017[3], the VoIP + chat program Skype stored the most accessible copy of its message and call history in an SQLite database named main.db. After version 12 was released in 2017, message history was instead kept in a slightly different database called skype.db, although main.db remains in the filesystem.[3][4]. Much of the information stored in main.db, and some that wasn't (namely "deleted" messages), was also stored in a directory structure called "chatsync".
Software
- [1]: Skyperious, an open-source viewer written in Python
- pip2 name: skyperious
- [2]: NirSoft SkypeLogViewer, a proprietary freeware viewer
- [3] Another proprietary freeware viewer
- [4] Ditto.
Links
- StackOverflow: skype: how to read chat message using main.db
- StackOverflow: skype main.db - difference between Chats and Conversations
- Betrayed Spouses Club: Skype Main.db
- AskUbuntu: How should I see the skype chat history from the file main.db located at ~/.Skype/SKYPEUSERNAME/?
- Yahoo Answers: Why don't I have a main.db file on my Mac for Skype?
References
- ↑ O'Connor, T.J. Violent Python: A Cookbook For Hackers, Forensic Analysts, Penetration Testers And Security Engineers. Elsevier, 2013. p. 110. IA link
- ↑ https://web.archive.org/web/20080716022445/http://www.skype.com/intl/en/download/skype/windows/beta/ Note the date.
- ↑ 3.0 3.1 https://answers.microsoft.com/en-us/skype/forum/all/where-is-the-maindb-file-for-new-skype/b4d3f263-a97e-496e-aa28-e1dbb63e7687
- ↑ https://answers.microsoft.com/en-us/skype/forum/skype_windesk-skype_messms-skype_sms/sqlite-maindb-file/75258f84-4b2d-4284-82b0-958bed9f3b36