Restoring history items in places.sqlite
I use Piriform CCleaner.
The most recent update ignored the settings to exclude Firefox and cleared my History.
I do have a backup but it isn't recent as I'd like.
I did have a look at the places.sqlite file with an editor - interestingly all the history is still there. So how is it "enabled / disabled" as far as Firefox is concerned?
I did a fair amount of Googling but can't see an explanation.
Your input would be appreciated! Adb
All Replies (2)
Maybe check the places.sqlite in a SQLite manager to see whether you still have at least the URLs in the moz_places table. It is possible that only the moz_historyvisits table got cleared, but that moz_places still has the url and title with a visit count of 0 (zero) and no last_visit_date. So you could possibly get a list of URLs, but no way to get real visit_date although the place 'id' might give some indication.
I'm not very good with SQL, so i tried something simple: Replace LIKE '0' with bookmarkbackups to get a list of visited pages. I used AND url LIKE 'https://support.mozilla.org%' to limit the list only for this forum.
SELECT url, title, id, visit_count, datetime(last_visit_date/1000000,'unixepoch','localtime') FROM moz_places WHERE visit_count LIKE '0' AND url LIKE 'https://support.mozilla.org%' ORDER BY url
Modified by cor-el
Sorry I should have been more specific :
The moz_places table still has the URLs.
Will see if I can execute what you have suggested...