I downloaded SQLite Database Browser to preview cookies of Google Chrome and Firefox.

I could successfully preview Chrome's cookies, however cannot manage to preview Firefox cookies. I'm trying open this file C:\Users\T3\AppData\Roaming\Mozilla\Firefox\Profiles\mn0g2w2t.default\cookies.sqlite but as a result get no error, just after opening it, SQLite Database Browser shows an empty database – but the file size is 1MB.

Does anyone have an idea what may be wrong?

| |
  • I guess the same applies to bookmarks file places.sqlite? Read this SO answer: FF uses exclusive lock. Try to copy the file somewhere else and see if this help (I can't test this and I'm cautious) – nixda Aug 22 '13 at 14:48

The problem is that Firefox keeps their database locked using EXCLUSIVE locking model so SQLite Database Browser cannot manage to open it, to preview data, one option is to copy DB file and open it from that place. Or even better option: open it programmicaly using SQLite library, this works always; copying just sometimes.

| |
  • I have to regret myself. The newest SQliteSpy 1.9.3 is able to view places.sqlite and cookies.sqlite. I assume "SQLite Database Browser" should be able to this too, somehow. – nixda Aug 24 '13 at 15:26
  • newest version of SQLite Database Browser also works sqlitebrowser.org – Cel May 22 '15 at 8:37

SQLite Manager is a Firefox extension but works with any sqlite db.

| |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.