Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
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

2 Answers 2

up vote 0 down vote accepted

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.

share|improve this answer
    
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

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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