Skip to content

Instantly share code, notes, and snippets.

@pudgereyem

pudgereyem/gist:8070996

Created December 21, 2013 15:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pudgereyem/8070996 to your computer and use it in GitHub Desktop.
Save pudgereyem/8070996 to your computer and use it in GitHub Desktop.
Download ZIP
SHELL: Viewing the Skype chat history
Raw
gistfile1
# Viewing the Skype chat history
# <http://superuser.com/questions/93682/viewing-the-full-skype-chat-history>
# As suggested by [daniel-beck](http://superuser.com/users/22317/daniel-beck)
# 1. Shut down Skype (Otherwise the db will be locked, I think)
# 2. Located your main.db file. It's normally stored under `/Users/username/Library/Application\ Support/Skype/yourskypeusername/main.db`
# 3. Run the following command to output the chat log, but replace "theOtherPersonsUserName".
sqlite3 main.db "SELECT author, from_dispname, datetime(timestamp, 'unixepoch') as date, body_xml FROM Messages where dialog_partner = 'theOtherPersonsUserName' ORDER BY timestamp;" > "theOtherPersonsUserName.log"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment