Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 1 down vote accepted

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.)

share|improve this answer

Just figured it out.

sqlite3 places.sqlite .dump |grep moz_places
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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