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?

2 Answers 2


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


Just figured it out.

sqlite3 places.sqlite .dump |grep moz_places

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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