Browsed by
Tag: SQL

[Linux] How to execute SQL query on Firefox history

[Linux] How to execute SQL query on Firefox history

1. If you don’t know anything about SQLite, please read: http://en.wikipedia.org/wiki/SQLite 2. Install sqlitebrowser: sudo apt-get install sqlitebrowsersudo apt-get install sqlitebrowser 3. Run sqlitebrowser 4. Open file: /home/your username/.mozilla/firefox/your profile/places.sqlite It’s a SQLite database where firefox stores information about history. 5. Execute following command: SELECT url FROM moz_places WHERE url LIKE "%wojtekrj.net%"SELECT url FROM moz_places WHERE url like "%wojtekrj.net%" 6. You should have list of all vistied by you pages from my blog.