Why downloads.sqlite is missing?
Hi, I use Firefox for Windows 7 as a browser and I downloaded some files. I can't see the downloads.sqlite file that contains all my downloads history in the location: C:\Users\<username>\AppData\Roaming\Mozilla\Firefox\Profiles\jf9bouo0.default . Why is that ? How can I see it ?
All Replies (4)
Download history is not stored in a downloads.sqlite file but in the places.sqlite file, with bookmarks and browsing history.
Find more information in this Mozilla Support article.
Do you now which table in places.sqlite saves the download history ?
It is the moz.annos table. Each download is saved on 2 lines. But unless you know exactly what you do, I advise you don't modify this file.
The downloads as shown in the Download Manager and in the Downloads folder in the Library are part of the history and thus stored in the places.sqlite just like other history items, but are marked as downloads via a specific annotation. The Downloads folder in the Library is part of the History, so if you clear history or otherwise do not keep history then corresponding items are removed from the Downloads folder and vice versa if you remove entries in the Downloads folder then they will no longer appear in the history.