[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.