Dump

From ZENotes
Jump to: navigation, search

from:

http://totalrecall.wordpress.com/2008/09/03/automating-export-of-firefox-3-bookmarks-and-history-from-command-linecron/

you need sqlite3 aka sudo apt-get install 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.

Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox