Dump
From ZENotes
(Difference between revisions)
(Created page with "from: http://totalrecall.wordpress.com/2008/09/03/automating-export-of-firefox-3-bookmarks-and-history-from-command-linecron/ you need sqlite3 script: cd /where/the/firefox...") |
|||
Line 7: | Line 7: | ||
script: | script: | ||
− | + | cp /where/the/firefox/history/is/located/'''places.sqlite''' ./firedump.sqlite | |
− | + | sqlite3 'firedump.sqlite' <<! | |
− | sqlite3 ' | + | |
.dump html | .dump html | ||
.output firedump.html | .output firedump.html | ||
Line 19: | Line 18: | ||
find ./ -name places.sqlite | find ./ -name places.sqlite | ||
+ | |||
+ | |||
+ | Original script from a mac: | ||
+ | |||
+ | |||
+ | cd /Users/john/Library/Application\ Support/Firefox/Profiles/8j7l8qg8.default | ||
+ | cp places.sqlite places1.sqlite | ||
+ | sqlite3 'places1.sqlite' <<! | ||
+ | .dump html | ||
+ | .output moz_places.html | ||
+ | select url,title from moz_places; | ||
+ | ! | ||
+ | |||
+ | But I prefer to have the dump in my ./~ folder. |
Revision as of 10:57, 2 November 2011
from:
you need sqlite3
script:
cp /where/the/firefox/history/is/located/places.sqlite ./firedump.sqlite sqlite3 'firedump.sqlite' <<! .dump html .output firedump.html select url,title from firedump; !
find where it is on your system with
find ./ -name places.sqlite
Original script from a mac:
cd /Users/john/Library/Application\ Support/Firefox/Profiles/8j7l8qg8.default cp places.sqlite places1.sqlite sqlite3 'places1.sqlite' <<! .dump html .output moz_places.html select url,title from moz_places; !
But I prefer to have the dump in my ./~ folder.