[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 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%"

6. You should have list of all vistied by you pages from my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *