help with sqlite query to retriev browser history

tiggertie · 05-24-2010, 01:19 PM

This query is giving "Unable to open data base" can anybody suggest what's wrong with this query.

sudo echo "SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id;" | sqlite3 moz_places.sqlite, moz_historyvisits.sqlite

unSpawn · 05-24-2010, 07:05 PM

Running

Code:

echo "SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url FROM moz_places, moz_historyvisits WHERE moz_places.id = moz_historyvisits.place_id;" | sqlite3 $PWD/places.sqlite

works OK for me. Note there's no moz_places.sqlite, moz_historyvisits.sqlite: it's just one DB called "places.sqlite".