Monday, May 18, 2015

searching all skype messages on Linux

if you ever need to search skype messages:


the query is "SELECT author, datetime(timestamp, 'unixepoch'), body_xml FROM messages ORDER BY timestamp desc;"

the sqlite file is ~/.Skype/your_user_name/main.db

Might need to stop skype before looking at the file.

No comments:

Post a Comment