how to delete cookies (and other data) for un-visited site?

User Help for Seamonkey and Mozilla Suite
Post Reply
Michael REMY
Posts: 323
Joined: December 19th, 2009, 2:27 am

how to delete cookies (and other data) for un-visited site?

Post by Michael REMY »

hi,

i have a 10yo seamonkey profil.
i wish to delete every data from the website i did not visit since 3years. At least, delete only cookies and keep url stats.

when i open the data manager, there is no way to sort the data by date but only by alphabetical order...
Moreover, when i open the datamanager i have a javascript debug message (my database might be too huge for the component who list the domain on the left side of the screen) and the cpu usage and cpu fan is growing up faster and faster before the error box is display (to debug or stop the javascript).

Thank you all for any suggestion and help.

ps : my version SeaMonkey release is 2.53.9.1
Platform: Windows x86 (but i'm running under win7 x64)
Language: English (US) (but i'm using a french OS windows).
Michael REMY
Posts: 323
Joined: December 19th, 2009, 2:27 am

Re: how to delete cookies (and other data) for un-visited si

Post by Michael REMY »

i just check my folder profile, it used 500GB of data since decmeber 2009 (windows fresh install data).
there a lot of big files in there, and each subfolder can have a lot of data too.

Code: Select all

chrome\	1 947	13/12/2009 19:53	----
adblockplus\	<RÉP>	31/08/2012 21:50	----
blocklists\	<RÉP>	09/06/2021 08:19	----
bookmarkbackups\	<RÉP>	17/10/2021 10:09	----
crashes\	<RÉP>	17/10/2021 10:10	----
datareporting\	<RÉP>	10/08/2017 09:38	----
extensions\	<RÉP>	24/04/2021 08:41	----
gmp\	<RÉP>	25/12/2016 07:48	----
minidumps\	<RÉP>	10/04/2021 16:35	----
storage\	<RÉP>	28/09/2015 15:22	----
weave\	<RÉP>	15/02/2013 17:09	----
webapps\	<RÉP>	06/08/2017 23:28	----
places.sqlite	62 914 560	17/10/2021 10:09	-a--
webappsstore.sqlite	48 857 088	17/10/2021 10:09	-a--
favicons.sqlite	42 696 704	17/10/2021 10:09	-a--
history.dat	16 934 201	09/12/2009 22:30	-a--
formhistory.sqlite	3 683 328	17/10/2021 11:16	-a--
cookies.sqlite.bak	3 670 016	09/10/2018 12:38	-a--
kinto.sqlite	2 686 976	06/08/2021 09:41	-a--
cookies.sqlite	1 572 864	17/10/2021 11:16	-a--
cert8.db	1 490 944	16/10/2021 10:17	-a--
content-prefs.sqlite	1 343 488	15/10/2021 19:37	-a--
blocklist-addons.json	1 160 167	29/05/2020 15:38	-a--
blocklist.xml	981 243	16/10/2021 20:39	-a--
cookies.sqlite-wal	590 288	17/10/2021 11:17	-a--
favicons.sqlite-wal	590 288	17/10/2021 11:16	-a--
places.sqlite-wal	556 232	17/10/2021 11:16	-a--
addons.sqlite	524 288	31/10/2013 12:26	-a--
cookies.sqlite.bak-rebuild	524 288	02/01/2015 17:03	-a--
extensions.sqlite	458 752	20/11/2013 08:00	-a--
signons.sqlite	239 616	15/02/2013 17:09	-a--
cert9.db	229 376	03/06/2020 08:32	-a--
key4.db	229 376	03/06/2020 08:32	-a--
compreg.dat	182 733	05/05/2011 12:38	-a--
blocklist-plugins.json	139 100	17/03/2020 08:01	-a--
xpti.dat	121 276	05/05/2011 12:38	-a--
chromeappsstore.sqlite	98 304	22/07/2011 22:40	-a--
storage.sdb	98 304	08/10/2019 20:22	-a--
permissions.sqlite	71 680	27/07/2021 07:52	-a--
revocations.txt	69 515	06/08/2021 09:41	-a--
search.sqlite	65 536	17/06/2012 17:58	-a--
mimeTypes.rdf	57 483	22/04/2020 19:35	-a--
SiteSecurityServiceState.txt	55 159	17/10/2021 11:14	-a--
prefs.js	49 171	17/10/2021 11:16	-a--
7297363.s	41 296	09/12/2009 20:01	-a--
bookmarks.html	41 077	22/07/2011 22:29	-a--
localstore.rdf	39 067	05/12/2014 19:15	-a--
sessionstore-2.json	37 426	07/06/2013 16:47	-a--
signons3.txt	35 752	09/12/2009 22:48	-a--
sessionstore-3.json	35 043	14/07/2013 22:16	-a--
cookies.sqlite-shm	32 768	17/10/2021 10:09	-a--
favicons.sqlite-shm	32 768	17/10/2021 10:09	-a--
places.sqlite-shm	32 768	17/10/2021 10:09	-a--
webappsstore.sqlite-shm	32 768	17/10/2021 10:09	-a--
blocklist-gfx.json	27 953	07/08/2017 09:00	-a--
bookmarks-1.html	22 022	29/01/2010 20:58	-a--
cert_override.txt	17 264	06/05/2019 20:33	-a--
key3.db	16 384	16/10/2021 10:17	-a--
secmod.db	16 384	16/12/2009 00:07	-a--
xulstore.json	15 077	17/10/2021 11:16	-a--
search.json	14 660	25/04/2016 21:53	-a--
urlbarhistory.sqlite	10 240	17/10/2021 09:53	-a--
extensions.json	8 914	16/10/2021 20:43	-a--
sessionstore.json	8 394	17/10/2021 11:24	-a--
handlers.json	6 835	20/09/2021 17:32	-a--
panels.rdf	3 054	03/06/2020 08:32	-a--
search.rdf	2 787	02/08/2007 18:35	-a--
extensions.rdf	2 202	05/05/2011 12:38	-a--
search.json.mozlz4	1 894	02/10/2021 19:54	-a--
abook.mab	1 400	01/02/2010 19:57	-a--
history.mab	1 400	01/02/2010 19:57	-a--
pluginreg.dat	1 326	15/10/2021 07:47	-a--
pkcs11.txt	1 074	03/06/2020 08:32	-a--
addonStartup.json.lz4	733	02/10/2021 19:54	-a--
storage.sqlite	512	03/06/2020 08:32	-a--
mailViews.dat	504	19/04/2021 19:51	-a--
sessionstore-1.json	461	05/12/2011 18:58	-a--
hostperm.1	390	12/11/2009 07:52	-a--
compatibility.ini	190	02/10/2021 19:54	-a--
localstore-safe.rdf	169	28/08/2015 22:38	-a--
sessionstore.bak	154	17/10/2021 10:09	-a--
urlclassifierkey3.txt	154	04/05/2014 12:04	-a--
enumerate_devices.txt	123	07/10/2015 21:03	-a--
sessionCheckpoints.json	90	17/10/2021 10:09	-a--
logins.json	57	01/05/2019 08:31	-a--
search-metadata.json	34	19/07/2012 13:57	-a--
times.json	25	15/11/2015 20:24	-a--
virtualFolders.dat	10	19/04/2021 20:19	-a--
Telemetry.ShutdownTime.txt	5	17/10/2021 10:09	-a--
directoryTree.json	2	10/05/2014 09:37	-a--
Telemetry.FailedProfileLocks.txt	2	25/04/2019 15:54	-a--
AlternateServices.txt	0	17/10/2021 10:09	-a--
contentblock-regex.txt	0	11/06/2016 09:38	-a--
memory-report.json.gz	0	29/08/2017 08:32	-a--
notificationstore.json	0	14/01/2017 08:46	-a--
parent.lock	0	17/10/2021 10:09	-a--
SecurityPreloadState.txt	0	17/10/2021 10:09	-a--
webappsstore.sqlite-wal	0	17/10/2021 10:09	-a--
TPR75
Posts: 1353
Joined: July 25th, 2011, 8:11 am
Location: Poland

Re: how to delete cookies (and other data) for un-visited si

Post by TPR75 »

Michael REMY wrote:i just check my folder profile, it used 500GB of data since decmeber 2009[...]
Cookies, URLs and similar stuff are stored in "places.sqlite" file and it has c.a. 60 MB (not so much).

There must be something much bigger. Probably e-mails. Or some junk. Old cache maybe.

There is some nice "Scanner" soft to search and present size of files/folders under Windows:
http://steffengerlach.de/freeware/
--
v_v
Posts: 157
Joined: September 18th, 2021, 8:57 am

Re: how to delete cookies (and other data) for un-visited si

Post by v_v »

Michael,

In addition to what tpr75 suggested there are a couple of other good free disk analysis programs that you might want to try: TreeSize Free at " https://www.jam-software.com/treesize_free " and WizTree at " https://www.diskanalyzer.com/ ". Both of these will scan whatever drive or directory you choose and give you size results. From there you can delete whatever you wish that might have become too large.

For cookies specifically I use the CookieKeeper 1.9.3.1 extension available at " https://addons.thunderbird.net/en-us/fi ... kiekeeper/ " or " https://addons.thunderbird.net/en-us/fi ... /versions/ ". For this extension I had to download it and then double-click it to install it, because all of the messages said that it would not work in my browser version, but it is definitely working in my SeaMonkey 2.53.9.1.

In CookieKeeper there are three columns with dates---Expire Date, Creation Date, and Last Accessed---and you can sort using any of these columns.

Like tpr75 said 500 GB sounds like way too much for just cookies. There must be other things. If you have never done a cleaning or emptying of cache you might want to try the "Clear Private Data" under Tools. But from what I see this will clear broad categories without giving you a preliminary analysis of what you are deleting. As an alternative you might want to try Ccleaner Free at " https://www.ccleaner.com/ccleaner/download ". This program will do an analysis first and then give you the option of what to clean. On my system I have it set to only clear the cache of various browsers, plus other things like the Recycle Bin, Temporary Files, Memory Dumps, Chkdsk File Fragments, etc. If you install the program be sure to choose the customize route and beware of any offers to install other unneeded programs.

Let us know what you find and how it works out.

v_v
Michael REMY
Posts: 323
Joined: December 19th, 2009, 2:27 am

Re: how to delete cookies (and other data) for un-visited si

Post by Michael REMY »

the two replies before mine are two spam ?
they offer me to make space on my drive by cleaning cookies what is not i asked.

i wanted to delete the old one which are not used since a couple year.
does each cookie avec a reliable date file ? can i selected them by modified date ?
hardys
Posts: 290
Joined: August 7th, 2015, 9:15 am

Re: how to delete cookies (and other data) for un-visited si

Post by hardys »

As far as I'm aware cookies are stored in your profile in db format as cookies.sqlite
In this db table the creation- last visit- and expire date are stored in unix time stamp format.
When I need to look in those db tables I use sqlite manager 0.8.3.1 signed from https://addons.thunderbird.net/EN-uS/se ... er/?src=ss

Maybe you have to use the converter ( http://addonconverter.fotokraina.com/ ) before you can install the extension in SM

Before you make any changes I recommend to make a backup of your cookies.sqlite file
Anonymosity
Posts: 8779
Joined: May 7th, 2007, 12:07 pm

Re: how to delete cookies (and other data) for un-visited si

Post by Anonymosity »

Look at this part of the interface: chrome://communicator/content/permissions/cookieViewer.xul.
That allows you to look at cookies and exceptions to your default cookie permission setting. Since it focuses on cookies and nothing else, it makes it much easier to see what cookies you have and you can remove them selectively.
v_v
Posts: 157
Joined: September 18th, 2021, 8:57 am

Re: how to delete cookies (and other data) for un-visited si

Post by v_v »

Michael,

Did you try the CookieKeeper extension that I suggested in my previous post? As I indicated it has three columns with dates---Expire Date, Creation Date, and Last Accessed---for all of your cookies, and it allows you to sort them using any of these date columns. Once you have sorted your cookies by dates then you could delete whichever ones you choose.

And as hardys said you might want to make a backup of your cookies.sqlite file before making any changes, just for safety's sake.

[Edit 1 - After installing it, when you first open the CookieKeeper extension it will only show three columns and NOT the three date columns; to activate and choose these date columns you will need to go to the very right side of the screen on the same line as the column names/labels and click the little column image/figure; this will give you the choice of which columns to display.]

v_v
Michael REMY
Posts: 323
Joined: December 19th, 2009, 2:27 am

Re: how to delete cookies (and other data) for un-visited si

Post by Michael REMY »

hi,
CookieKeeper 1.9.3.1 is "This add-on is not compatible with your version of SeaMonkey." which mine is 2.53.9.1
v_v
Posts: 157
Joined: September 18th, 2021, 8:57 am

Re: how to delete cookies (and other data) for un-visited si

Post by v_v »

Michael,

The extension does work in 2.53.9.1 but you will have to manually install it. First, you will need to download the file from one of the two locations that I listed in my first post. Once downloaded the file will have the following name "cookiekeeper-1.9.3.1-sm+tb+fx-windows.xpi". Next, go to your menu bar in SeaMonkey and click File -- Open File. When the browse window opens go to and highlight the downloaded file and click Open. An installation window will appear, then click "Install Now". The extension will be installed and it will show up in your add-on or extensions list. On my browser in the Navigation bar the words "CookieKeeper" appear with a very small downward-pointing triangle immediately to the right. Click on that triangle and amongst the choices you will get "Show Cookies" and "Preferences". You might want to explore both, but the "Show Cookies" one is the one that you will actually use to do whatever work it is that you want to do.

As I mentioned in my second post "when you first open the CookieKeeper extension ("Show Cookies") it will only show three columns and NOT the three date columns; to activate and choose these date columns you will need to go to the very right side of the screen on the same line as the column names/labels and click the little column image/figure; this will give you the choice of which columns to display." From there you should be able to do what you wish to do.

v_v
Post Reply