Reference for exporting bookmarks and history in Firefox

 

Exporting bookmarks into html format

1. Click the Bookmarks button and select Show All Bookmarks to open the Library window.
2. From the toolbar on the Library window, click Import and Backup and choose Export Bookmarks to HTML....

 

how do I save my browsing history to a separate file, before cleaning my cache

 

If you wish to preserve the history save your Firefox profile , or specifically the database file places.sqlite

 

Use SQLite plugin for firefox and mount the places.sqlite file.   The file is located in:

C: \ Users \ \ App Data \ Roaming \ Mozilla \ Firefox \ Profiles \ \ places.sqlite

 

Once SQLite is installed in Firefox, go to the Tools menu and select the application.  Once opened, use: Database / Connect Database / C:/temp/places.sqlite  (location you copied the users places.sqlite file)

 

 

Get the bookmarks into a readable format[1]

You can easily get dates in a readable format by converting the Unix Epoch format to a date/time format:

SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/1000000,'unixepoch') AS DateAdded

FROM moz_bookmarks AS a JOIN moz_places AS b ON a.fk = b.id

I don't think that it matters which table is open when you paste the code in the "Execute SQL" text area to run the code.

 

 

 

 

In Firefox, need help pulling up history on specific date [2]

You need to scroll down through the history until you arrive there or try to formulate a query to select that date.

• https://developer.mozilla.org/en/Places_query_URIs

---

You can also use the SQLite Manager extension to create list

• SQLite Manager: https://addons.mozilla.org/firefox/addon/sqlite-manager/

1. Open Profile Directory -> places.sqlite -> Go
2. Hit the Execute SQL tab
3. 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 AND visit_date BETWEEN strftime('%s','2011-04-01')*1000000 AND strftime('%s','2011-04-30')*1000000

That query shows all history entries from April
The date and time is saved in 64 bit EPOCH format in micro seconds.

• http://en.wikipedia.org/wiki/Unix_time

..........

---

[1] https://support.mozilla.org/en-US/questions/996638

[2] https://support.mozilla.org/en-US/questions/835204