Skip to main content

How To Delete Skype Conversation For A Single Contact In Windows

There’s no doubting the fact that Skype is the most amazing VoIP services around. Hundreds of millions of people use it everyday, and it’s supported by almost all mobile and desktop platforms. But just like many top notch tech solutions, Skype isn’t without its shortcomings. If you use Skype on Windows, you’d probably be aware that it doesn’t let you remove the chat history of a single contact only and the only (official) way is to delete it is by clearing the entire chat history from Preferences. You’re not completely out of luck though, as there is a way to delete Skype conversation of one user if you want. And in this guide we will show you how. So without any further ado, let’s get straight to it.

Skype basically stores all the text chats with contacts in the SQL database file called “main.db” which is stored inside the Roaming folder of Windows. This database file in fact also carries other information related to settings and options stored by the user. Fortunately, there’s a way to access this information via an open source tool called SQLite. Using this tool you can access the main database file and remove any non-required data entries.
Warning: Make sure to backup the “main.db” file before implementing the steps mentioned below. This file is located under C:\Users\’Windows_username’\AppData\Roaming\Skype\’skype_username’\
 
First off download SQLite Database Browser from sqlitebrowser and extract the contents of the ZIP archive to an easily accessible location. SQLite is a portable tool which means it runs without any installation.
Launch the program and navigate to ‘Open Database’ from ‘File’ menu as demonstrated in the screenshot below.



Now you need to browse to the ‘main.db’ database file that I mentioned earlier. Navigate to the following directory:

C:\Users\’windows_username’\AppData\Roaming\Skype\’skype_username’\
Select ‘main’db’ from the available files and click ‘Open’.

 Within SQLite program, click ‘Browse Data’ tab, and under Table drop down menu click ‘Conversation’.





This will open the conversation data entries stored within the database pertaining to each user ID in your Skype contacts. This allows you to easily find the conversation you need to remove by identifying the user ID.
To delete an entry, all you need to do is click its related row followed by clicking ‘Delete Record’ at the top right. You can highlight and delete multiple records in a similar way. After deleting non-required entries, click Save on the toolbar and close SQLite.


 It may sound like a lot of work but this is the only working way of deleting Skype conversation of a single contact. It should be noted that this method will only delete conversation history from your computer and not from the recipient’s system.

Comments

Popular posts from this blog

How to enable SSH login access to a Cisco router

This guide walks you through how to setup SSH on a Cisco Router. SSH is by far more secure then telnet. Telnet allows your passwords to be sent in plain text that anyone can see and gain access to your network. SSH is all encrypted traffic. NOTE: This should work with any Cisco router provided the Cisco IOS on the router supports ssh. Firstly is ssh enabled? router#sh ip ssh SSH Disabled - version 2.0 %Please create RSA keys to enable SSH. Authentication timeout: 60 secs; Authentication retries: 5 In this case its not, if you got a error saying that sh ip ssh is not recognized then you would know that ssh is not supported or possibly that the command is different for your platform. How to enable SSH on a Cisco 800 series router# config term router(config)#crypto key generate rsa usage-keys label router-key The name for the keys will be: router-key Choose the size of the key modulus in the range of 360 to 2048 for your

INSTALL DOT NET FRAMEWORK ON MULTIPLE SERVERS USING POWERSHELL SCRIPT

Installing .Net 4.5.2 $servers = Array of Servers foreach($server in $servers) { Write-Host “Copying the installation file” copy-item  –path “-SOURCE” –destination “ destination ” Write-Host “Installing .NET 4.5.2” Invoke-Command –Computername $server –Credentials xxxx { C:\Temp\ NET 4.5.2  /passive /norestart }

Connection failed: enforce firewall policy failed (on win 7 / 64bit)

Connection failed: enforce firewall policy failed (on win 7 / 64bit)  error: connection failed: enforce firewall policy failed client: Check point endpoint security r75 build 835002205 on win 7 / 64 bit The solution is to find driver file vsdatant.sys and copy it to system32/drivers Ref :- https://forums.checkpoint.com/forums/thread.jspa?messageID=46927