How to execute query to a DB from a terminal and store output to a file?

Question

I want to access this DB and I use this to access the SQLite DB: sqlite3 .mozilla/firefox/profile_name/places.sqlite

The query that I want to execute to this DB and store the output in a text file is SELECT moz_places.url FROM moz_places

How do I do that?

score 15 · Accepted Answer · edited Jun 05 '11 at 15:12

15

Try man sqlite
You'll find that sqlite expects a syntax such as sqlite [options] filename [SQL]
Then do this sqlite [options] filename [SQL] > file_with_results.txt and the result would be in file_with_results.txt

From what you write, I believe you need:

sqlite .mozilla/firefox/profile_name/places.sqlite "SELECT moz_places.url FROM moz_places;" > file_with_results.txt

edited Jun 05 '11 at 15:12

Marco Ceppi

answered Jun 05 '11 at 01:09

sqlite3 package is required so the above commands with sqlite3 instead of sqlite works – Nitin Venkatesh Jun 05 '11 at 16:03

1 Answers1