places.sqlite

8 antwoorden
1 heeft dit probleem
13 weergaven
Laatste antwoord van McCoy

5 jaar geleden

29-07-2018 12:11

places.sqlite database have two database moz_bookmarks and moz_favicons. where is information in bookmarks what favicon is?

Answer 1 · 2018-07-29 12:11:20

Shadow110

29-07-2018 12:17

If needing help please provide some details such as what version by going to Help --> About ? What OS are you running ?

bookmarks and history: places.sqlite
bookmark backups: compressed .jsonlz4 JSON backups in the bookmarkbackups folder
cookies.sqlite for the Cookies
formhistory.sqlite for saved autocomplete Form Data
logins.json (passwords) and key4.db (58+) or key3.db (57 and older) (decryption key) for Passwords saved in the Password Manager
if you only have key3.db then make sure to remove an existing key4.db
cert9.db (58+) or cert8.db (57 and older) for (intermediate) certificates stored in the Certificate Manager
if you only have cert8.db then make sure to remove an existing cert9.db
persdict.dat for words you added to the spelling checker dictionary
permissions.sqlite for Permissions and possibly content-prefs.sqlite for other website specific data (Site Preferences)
sessionstore.jsonlz4 for open tabs and pinned tabs (see also the sessionstore-backups folder)

Answer 2 · 2018-07-29 12:11:20

McCoy

29-07-2018 15:33

Also see :

https://developer.mozilla.org/en-US/docs/Mozilla/Tech/Places/Database

Answer 3 · 2018-07-29 12:11:20

the-edmeister

Moderator

29-07-2018 17:12

You didn't provide info as to exactly which version of Firefox your query refers to, so here's a protracted explanation.

https://en.wikipedia.org/wiki/Favicon

moz_favicons - the website image which is associated with each saved bookmark.

But as far as the places.sqlite file goes, the favicons were moved out of places.sqlite a few versions ago; like Firefox 58, 59, or 60 when the favicons.sqlite database went in to use. Although a "reference" may remain in the places.sqlite file to "tie it too" the actual image which was moved to the favicons.sqlite file.

There are also two "auxiliary" or temporary storage files which are only present when Firefox is running; the data gets saved to the "main" favicons.sqlite file as Firefox is "keeping house" during shut down / when exiting. favicons.sqlite-shm & favicons.sqlite-wal

But the moz_favicons items will or may be present for existing data a for number of new versions yet. That allows backwards compatibility for users who may want to revert a version or two after a Firefox version update, and that allows for a "chemspill" patch should an unexpected problem appear after "release", such as a fault which was missed in Nightly testing and in the 12 week Beta development channel run for each new version. Better to leave the no longer used data in place for awhile than clear it out immediately, and then have far greater problems if the change proves to be faulty. IMO.