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?
man sqlite
sqlite
expects a syntax such assqlite [options] filename [SQL]
sqlite [options] filename [SQL] > file_with_results.txt
and the result would be infile_with_results.txt
From what you write, I believe you need: