Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
open Skype DB with history and remove some items (Mac OS)
# shutdown Skype
# Skype username - it's a login at Skype
# Mac username - it's a short username of Mac OS X (ex.: dive)
# <...> should be entered without brackets <>
#copy this one, paste to Terminal.app and hit Enter
sqlite3 "$HOME/Library/Application Support/Skype/<your_skype_username>/main.db"
#then copy this one, paste to Terminal.app where sqlite3 running and hit Enter
delete from Messages where dialog_partner = '<delete_history_of_conversation_with_particurarly_username>';
#done
#if you want to remove history with another username, just hit Up arrow and replace username
@arturdryomov

This comment has been minimized.

Copy link

@arturdryomov arturdryomov commented Jan 29, 2012

Может, на седьмой строке Application\ Support? Или у меня просто линукс головного мозга?

@dive

This comment has been minimized.

Copy link
Owner Author

@dive dive commented Jan 29, 2012

не. в двойных кавычках же.

@arturdryomov

This comment has been minimized.

Copy link

@arturdryomov arturdryomov commented Jan 29, 2012

Ах да, я лох.

@nguyenduy020290

This comment has been minimized.

Copy link

@nguyenduy020290 nguyenduy020290 commented Oct 25, 2017

This is my script, firstly close Skype, then all message in a conversation. You can adjust the sql query according to your purpose.

  1. Create a file and paste below content, save it with .sh extension
  2. Edit skype_login_name to yours, adjust the sql query according to your purpose then save the file
  3. Execute the script in terminal
SkypePid=$(pgrep Skype)
kill $SkypePid
sqlite3 "$HOME/Library/Application Support/Skype/<skype_login_name>/main.db" <<EOS
delete from main.messages where chatname = '19:83e9be70b7ec4202ae8c158527374401@thread.skype';

commit;

.exit

EOS
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment