Cookie backup (cookies.sqlite~) not deleted in Firefox

[mikeXYZ]

Cookie backup not deleted.
After running BleachBit to delete cookies and vacuum the sqlite data base, the cookies were gone BUT the cookie backup file, cookies.sqlite~, was still there and had all the private info in it.
FX 3.5.6 in Kubuntu 9.10.
BleachBit 0.7.2, from the .deb file on the BleachBit website.
=> Failure to delete cookie backup file. Thusly, perhaps: Delete cookies.*, or cookies.sqlite* .

[SpaceCafe (spacecafe)]

Try to run BleachBit with enabled option "Backup files". This should delete all files with a "~" at the end.

[mikeXYZ (qmikeq)]

Thanks for the idea, but a no-go. It deleted some other backup files (bookmarks in Okular and Konqueror), but not the cookies.sqlite~ . (To run the scan, I checked off Firefox cookies and Deep scan > Backup files).

[Andrew Ziem (ahziem1)]

I don't have cookies.sqlite~ on my system (Firefox 3.5, Fedora 11). Is there an option in Firefox to create these backups? Or was the file created with a third-party tool (or add-on)?

[mikeXYZ (qmikeq)]

The backup file cookies.sqlite~ was just there (before and after running BleachBit). Nothing special present: standard Kubuntu 9.10 installation, standard FX 3.5.6 (from 9.10 repos).

[Andrew Ziem (ahziem1)]

If the file is still there, in a terminal please run this command and paste the results here?

ls -la ~/.mozilla/firefox/*/cookies*

I am curious about the size and date. I think the file was not produced by Firefox, so I think the date will be old and the size may be different.

[mikeXYZ (qmikeq)]

Sorry, I did already delete it with kscrubber.
The Kubuntu 9.10 was a fresh install, Firefox the only browser (except Konqueror, which I did not yet use for browsing), a fairly clean system. The cookie file probably contained a dozen web sites (that I ran as a test to build the cookie file). I will try to get some more information, trying to get FX to generate another cookie.sqlite~.

[Andrew Ziem (ahziem1)]

Closing as 'incomplete' until someone can say how cookies.sqlite~ is created. Feel free to update this ticket with new information (or create a new ticket)

[Theatre-X (theatrex)]

It's for backup files in UNIX-based or inspired operating systems.
I see it all the time in GNU/Linux

https://en.wikipedia.org/wiki/~#Backup_filenames

[Theatre-X (theatrex)]

This can easily be fixed by adding a "*" at the end of the cookies cleaner for Firefox.

[Theatre-X (theatrex)]

I would think this file gets created when a user restores Firefox to a factory state.

[Andrew Ziem (ahziem1)]

In Firefox 22 Ubuntu 13.04 I reset Firefox to factory state (using the Firefox help menu), but no ~ files were created. So maybe a third party utility, such as an SQLite database editor, is making this file.

Also, deep scan can delete ~ backup files.

[Launchpad Janitor (janitor)]

[Expired for BleachBit because there has been no activity for 60 days.]