Delete Skype Chat History for Only One Contact

Google Ad:

Deleting chat historyBy default Skype stores chat history on both your computer and the computer of the person you chat with (update: and now even on the Skype servers as well).

If we want, we can remove the history with all contacts from our computer, but sometimes it is useful to delete the history with only one contact.

There is no such option in the settings, but we can still do it with the method below. It is for Windows based systems.

Backup Skype application files (strongly recommended)

This step will save us if something goes wrong.

  1. Quit Skype.
  2. Open a folder or Windows Explorer.
  3. In the address bar at the top input %appdata% and hit Enter.
  4. Copy the folder named Skype and paste it somewhere safe (for example on the desktop).

Deleting the history with one contact

  1. Quit Skype.
  2. Open a folder or Windows Explorer.
  3. In the address bar at the top input %appdata%\skype and hit Enter.
  4. Open the folder with your Skype Name.
  5. Delete every file and folder in there except the files config.xml and main.db (depending on your Windows settings you may see them only as config and main).
  6. Download the program SQLite Database Browser (Download from Chat4o or from SourceForge.net).
  7. Extract it by right clicking on the file and then clicking Extract here.
  8. A folder appears. Open it and in there start the file SQLite Database Browser 2.0 b1.exe
  9. In the program click the button with an opened folder (or from the menu File -> Open Database).
  10. In the address bar of the newly opened window input %appdata%\skype and hit Enter.
  11. Opening a file with Skype chat history with SQLite Database Browser

  12. Open the folder with your Skype name.
  13. Select the file main.db and click Open.
  14. Click on the tab Execute SQL.
  15. In the text field SQL string paste the text with the commands from the gray box below (choose option 1 or 2). Don’t forget to replace everywhere the word HERE with the Skype name of the contact you are deleting history with.
    To replace the word automatically just enter his Skype name here:
    Option 1
    - Deletes all records, but after you sign in, the ones for the last 30 days may be restored. More on this see comment #19 under this article.

    DELETE FROM Chats WHERE name LIKE '%#HERE/%' OR name LIKE '%$HERE;%' OR dialog_partner='HERE';
    DELETE FROM Messages WHERE chatname LIKE '%#HERE/%' OR chatname LIKE '%$HERE;%' OR author='HERE' OR dialog_partner='HERE';
    DELETE FROM Conversations WHERE identity='HERE';
    Option 2
    - Leaves the records, but deletes the words in them. It will be visible that there was a conversation, but all the words will be gone. This way the history will not be restored after you sign in.

    UPDATE Chats SET friendlyname='', split_friendlyname='' WHERE name LIKE '%#HERE/%' OR name LIKE '%$HERE;%' OR dialog_partner='HERE';
    UPDATE Messages SET guid='', body_xml='' WHERE chatname LIKE '%#HERE/%' OR chatname LIKE '%$HERE;%' OR author='HERE' OR dialog_partner='HERE';
  16. After you paste the text in the program, click Execute query. Below you will see a message saying No error.
  17. Click the Save icon (or from the menu File -> Save Database).
  18. Removing history with one Skype contact via SQL commands in SQLite Database Browser

  19. Close the program and sign-in with Skype. If everything is working properly, all you contacts are there, the history of the other contacts is also there and so on, you can delete the backup of the application files we made in the beginning (or not, but keep in mind that the history you deleted is there as well, so technically it is possible to be read by someone).

FAQFrequently Asked Questions

1. Is the information deleted only from my computer?

  • Yes. It will continue to be stored on the computer of the person you have chatted with.

2. The method above caused a problem in Skype. What to do?

  • In the beginning I recommended you to make a backup of some files. If there are any problems, quit Skype, go to the same place from where you took the files, remove the folder and restore the one from the backup. This will undo the changes you made (it will also restore the history you deleted).

Google Ad:

Реклама:

Category: Skype Tricks

18 comments

  1. This is a very old program.
    It does not work with new version skype.
    Also it is not necessary.
    Anyway.
    Your site is one of the best. This is my opinion.
    Good work.

    Thumb up 0 Thumb down 0
  2. @Michael Kontos
    Hi. Thank you for your comment.
    It works with the new Skype, at least when I tested it. It gives sometimes an error message, but it still deletes the history. Why do you say it is not necessary? Can you recommend another way to do it? I would be glad to describe it instead, if it is easier or more reliable.
    Thanks.

    Thumb up 2 Thumb down 0
  3. Hello,

    I tried using the program with Skype version 5.10.0.116 but it doesn’t work.

    I get the following error message:

    “Skype 4.x error message: Could not load file or assembly ‘System.Data.SQLite, Version=1.0..60.0, Culter=neutral, PublicKeyToken=xxxxxxxxxxxxxxx’ or one of its dependencies. An attempt was made to load a program with an incorrect format.”

    Any help would be great, thanks!

    Note: The token number I listed above, of course, is just a dummy number.

    Thumb up 2 Thumb down 0
  4. @ersyla
    Hi. Unfortunately there is no way to offer help for this. It is an old fan made program with no support or updates. When I tried it with 5.10 it showed some kind of error but it still deleted the history anyway :).
    I am sorry for the not so good way of deleting history for one user. I am open for suggestions for better solutions :).
    Regards.

    Thumb up 0 Thumb down 0
  5. @Catman
    Hmm… I am writing down in my to do list to try to find another way for this. I will edit the article when this happens.
    Regards.

    Thumb up 1 Thumb down 0
  6. Pretty sure I have the most recent version of skype (as of 12/11/12) and it did give an error message (system data sqlite..) but after logging back into skype the conversation was gone. Anyone having trouble should try and make sure they have QUIT skype, not just logged out. Then try. Thanks for the help Nikolay!

    Thumb up 0 Thumb down 0
  7. A great little program that works seamlessly with Skype 3.8.x but gives the previously mentioned Skype 4.x error message with Skype 6.0.x

    Thumb up 0 Thumb down 0
  8. Dear Nikolay,
    thank you for your effort with this website.
    Only for your information (maybe even for others) – you have written info that
    “Skype keeps records of all your chat messages and stores them on your computer.”
    I do not know whether this info is exact. When you end your chat and erase it (Tools> Options> Chats&SMS> buton “Clear chat history” and confirm it in dialog window the chat is displayed on other computer if Skype is opened on it.
    Best regards
    Jiří

    Thumb up 0 Thumb down 1
  9. @Jiří
    Hi. Thanks for sharing your thought on this. Can you explain a little more what exactly do you think is the correct information? The way I know it, Skype stores the chat history on the computer you are using in the moment of the chatting. This means that part of it may be on one computer and another part on another (if you are using from time to time different computers). So you need to delete the history on all computers. Also you have to do it from the files not the settings, the way it is described here: http://en.chat4o.com/remove-skype-history/

    Thumb up 0 Thumb down 0
  10. Yes still works on the newest version of skype
    Make sure you give admin permission on the program and make sure skype aint running.

    Thumb up 0 Thumb down 0
  11. @Oliver
    Hi. Thanks for the feedback and the idea about running it as administrator. I have added this to the article.
    Regards.

    Thumb up 0 Thumb down 0
  12. Long-benefit for selective cleaning of the history of Skype. But recently switched from XP to Windows 7 64 bit.

    Here SKYPECHATREMOVE complains that it can’t load the System.Data.SQLite.

    Downloaded from you “version for 64 bit Windows”, not working!

    PS
    But working in Windows 7 32 bit.

    Thumb up 0 Thumb down 0
  13. @KEG
    Hi. The program is made long before Win 7, so it is only natural to not work correctly there. But I want to mention that I have found another method for this and I am in the process of translating the article to english. So soon there will be a whole new article on this same page. It is more complicated but it is better.
    Regards.

    Thumb up 0 Thumb down 0
  14. Hi everyone :).
    I have completely remade the article above with a new method that is more complicated but more reliable and should work fine. Let me know if it works for you or not.
    Regards.

    Thumb up 0 Thumb down 0

Comments are closed.