Dump

Revision as of 10:54, 2 November 2011 (view source) Admin (Talk | contribs) (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...")		Latest revision as of 10:58, 2 November 2011 (view source) Admin (Talk | contribs)
(One intermediate revision by one user not shown)
Line 3:		Line 3:
	http://totalrecall.wordpress.com/2008/09/03/automating-export-of-firefox-3-bookmarks-and-history-from-command-linecron/		http://totalrecall.wordpress.com/2008/09/03/automating-export-of-firefox-3-bookmarks-and-history-from-command-linecron/
−	you need sqlite3	+	you need sqlite3 aka ''sudo apt-get install sqlite3''
	script:		script:
−	cd /where/the/firefox/history/is/located	+	cp /where/the/firefox/history/is/located/'''places.sqlite''' ./firedump.sqlite
−	cp places.sqlite places1.sqlite	+	sqlite3 'firedump.sqlite' <<!
−	sqlite3 'places1.sqlite' <<!	+
	.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.

---

Latest revision as of 10:58, 2 November 2011

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.