3

For some reason Firefox won't let me see more than 1 month of history, despite I have set to to remember for 90 days.

places.sqlite is 18MB so I would like to dump the content of it, and see if I can find the missing history.

Does anyone know how to dump/export to a flat ascii file?

Sandra
  • 9,973
  • 37
  • 104
  • 160

2 Answers2

7

Just figured it out.

sqlite3 places.sqlite .dump |grep moz_places
Sandra
  • 9,973
  • 37
  • 104
  • 160
1

Instead of using a flat ASCII file, you may also find using a tool such as SQLite Manager useful to browse or edit your SQLite file. (It can run either as a Firefox add-on or as a standalone XUL application.)

Bruno
  • 4,069
  • 1
  • 20
  • 37