title: Recover bookmarks from places.sqlite file
body: <p>I have a problem exporting my thousands of bookmarks in Firefox into a HTML file using the standard export function in Firefox. I get this error: </p>
  
  <pre><code>*************************
  A coding exception was thrown and uncaught in a Task.
  
  Full message: TypeError: root is undefined
  Full stack: BookmarkExporter@resource://gre/modules/BookmarkHTMLUtils.jsm:980:1
  BHU_exportToFile/&lt;@resource://gre/modules/BookmarkHTMLUtils.jsm:228:22
  TaskImpl_run@resource://gre/modules/Task.jsm:314:40
  Handler.prototype.process@resource://gre/modules/Promise.jsm -&gt; resource://gre/modules/Promise-backend.js:865:23
  this.PromiseWalker.walkerLoop@resource://gre/modules/Promise.jsm -&gt; resource://gre/modules/Promise-backend.js:744:7
  
  ************************* 
  </code></pre>
  
  <p>see <a href="https://gist.github.com/rubo77/12ef9be4060c7935c74c" rel="nofollow">https://gist.github.com/rubo77/12ef9be4060c7935c74c</a></p>
  
  <p>Is there a way to export my bookmarks on the console, so I can import them into a new fresh firefox profile?</p>
  
  <p>UPDATE: I managed to copy and paste all bookmarks from the "manage bookmarks" menu of an instance of firefox with the old profile into another instance with the new profile opened at the same time (using the commandline option <code>-no-remote</code>). But unfortunately this still doesn't copy the tags that were used for my bookmarks, which would be a great loss too.</p>