7

I'm using Ubuntu 12.04 LTS and Skype 4.3 on my machine. I've taken a file named main.db from the location on my machine ~/.Skype/SKYPEUSERNAME/

Now I want to see the chat history from that file with each of the contact. For it I installed Sqliteman but I'm still not able to see the chatr history. Can someone please provide me the easiest though effective solution for this issue? Thanks in advance.

5

Messages are stored as XML in messages table. You may use a simple SQL command to extract need dialog:

sqlite3 .Skype/yourusername/main.db "select timestamp,body_xml from messages where dialog_partner=\"partnerusername\";"

As you may use Sqliteman to run same command:

select timestamp,body_xml from messages where dialog_partner="partnerusername";
  • 3
    instead of timestamp use datetime(timestamp, 'unixepoch') as date, otherwise +1 as it fixes the bug in the skype client which shows empty history for all contacts – Gabor Apr 9 '15 at 12:41
  • 1
    Also I'd include the author field to get a log with proper sender per message – Treviño Dec 4 '15 at 16:58
  • What about chat groups? How can you correctly indentify them? – tigerjack89 Dec 7 '15 at 11:01
  • 1
    At least on my main.db, the table is Messages (with a capital), not messages (all lower case). I use: sqlite3 -csv main.db "select datetime(timestamp,'unixepoch'),dialog_partner,body_xml from Messages where dialog_partner != \"\";" > Skype_messages.csv – qwa Mar 26 '17 at 20:48

Not the answer you're looking for? Browse other questions tagged or ask your own question.