This site will have limited functionality while we undergo maintenance to improve your experience. If an article doesn't solve your issue and you want to ask a question, we have our support community waiting to help you at @FirefoxSupport on Twitter and/r/firefox on Reddit.

Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

This thread was archived. Please ask a new question if you need help.

Why downloads.sqlite is missing?

  • 4 replies
  • 2 have this problem
  • 5 views
  • Last reply by cor-el

hilaco
hilaco
more options

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 ?

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)

Banban
Banban
more options

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.

hilaco
hilaco Question owner
more options

Do you now which table in places.sqlite saves the download history ?

Banban
Banban
more options

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.

cor-el
cor-el
  • Moderator
  • Top 10 Contributor
more options

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.