up vote 2 down vote favorite
1
share [g+] share [fb]

I lost a load of open tabs in Firefox that I want to recover. The details are in the browsing history but it is not the most friendly area of Firefox to wade through. The Export option there actually exports bookmarks. I want to export my browsing history as a text file so I can search, dedup, etc in a text editor. I can not work out a way of exporting the browsing history so any suggestions much appreciated.

Firefox 3.5.5 Windows XP Pro

link|improve this question
40% accept rate
As for me, this addon addons.mozilla.org/ru/firefox/addon/sqlite-manager works. But this SQLite Browser, recommended by John T was unable to open my 20 Mb file – Anton Kovalenko May 13 '11 at 9:02
feedback

2 Answers

up vote 4 down vote accepted

Browsing history is stored in a file called places.sqlite in your profile folder. On Windows XP it is located under:

C:\Documents and Settings\USER\Application Data\Mozilla\Firefox\Profiles\##.default

replace USER with your Windows XP user name and ### is a set of random characters (you will see it in explorer if you navigate there). This file format is not easily edited in a text file, but you can use SQLite Database Browser (free and open source) to view the file.

link|improve this answer
1  
That's a start at least (an impressive one, at that.) I had to play around to see for myself. It looks like select * from moz_places order by id desc; would give you an in-app list of your recorded browsing history sorted from newest to oldest. But, if you want to extract the data for manipulation you'll have to do File | Export | Table as CSV File and then open it in OpenOffice Calc or Excel and twiddle from there. – JMD Dec 11 '09 at 16:34
+1 JMD and thanks for extra help. I was not 100% sure on what do do with the DB!! – ianfuture Jan 7 '10 at 11:34
feedback
up vote 0 down vote

An alternative to what's listed here is the add-on "Enhanced History Manager", which essentially allows you to do what you're talking about.

link|improve this answer
Mind adding a link to the extension you mention? – slhck Jun 6 '11 at 20:10
feedback

Your Answer

 
or
required, but never shown

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