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.
