Skype uses SQLite too! Even if you don’t believe it, but it’s one of the most handy things for getting data structured; But as every database, even sqlite needs some love every now and then.
On a linux box, the databases of Skype are in ~/.Skype/
find . -name ‘*.db’ -print -exec sqlite3 {} VACUUM \;
find . -name ‘*.db’ -print -exec sqlite3 {} REINDEX \;
… and we’re rolling smoothly again. But there’s more fun in those databases like exporting chatlogs:
sqlite3 main.db “SELECT author,timestamp, body_xml FROM messages WHERE dialog_partner = ‘skype-id'” > skype_chat_history.txt
… or clean them out a little:
DELETE FROM Messages where dialog_partner = “skype-id”
But keep in mind: Skype shouldn’t be running while doing so!
Stargazer says:
If you are messing around with the database files, they shouldn’t be accessed while doing so to prevent bad things from happening. Also doing backups is easier that way.