How should I see the skype chat history from the file main.db located at ~/.Skype/SKYPEUSERNAME/?
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.
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";