How should I see the skype chat history from the file main.db located at ~/.Skype/SKYPEUSERNAME/?

Question

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.

Answer 1

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";