This thread was archived. Please ask a new question if you need help.
Why can SQLite Manager see my history but Firefox 4.0.1 cannot?
Just upgraded to FireFox 4.0.1 from I forget which 3.. and have all the bookmarks (or so it seems) but the places.sqlite file (which says it was made back in 2006!) is not being consulted for the history, just the bookmarks. History shows today's work but no prior days.
All Replies (4)
If the file is that old then it is possible that the database structure is not compatible with the currently used structure or that the index is corrupted and in that case it is better to trash the file and let Firefox create a new places.sqlite.
Thanks but the rest of the file's content is working and I really use history, a lot! Things that did not seem on point at the time jump out later and I need to dig back... Any body know of a fixing/importing exporting utility or some guidance on how to work SQLite to do that job?
- SQLite Manager: https://addons.mozilla.org/firefox/addon/sqlite-manager/
- Open places.sqlite
- Hit the Execute SQL tab
- Use a Select like this:
SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url, moz_places.title FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id
- Click the Action button to Save the results to a CSV file
You can also select some records and use the right-click context menu to copy the selected records as CSV to the clipboard.
You can also create a Temporary view:
- View > Create View : [X ]Temporary Name: Enter a Name for the view
- Use the same Select as above
- View > Export View : Database > Temp
Modified by cor-el
ohhhhh me like! I'll give it a go. thanks! (and I'll come back and add to those impressive solved stats!)
Modified by paulbostwick