Having the command line interface of sqlite3 (sqlite3 package on synaptic)
Code:
sqlite3 places.sqlite
Code:
sqlite> .databases
seq name file
----------------------------------------------------------
0 main /home/canxp/places.sqlite
Code:
sqlite> .tables
moz_anno_attributes moz_favicons moz_keywords
moz_annos moz_historyvisits moz_places
moz_bookmarks moz_inputhistory
moz_bookmarks_roots moz_items_annos
sqlite> SELECT * FROM moz_bookmarks
That last one produces a huge output.
Use the sqlite3 module of python, or the one on C, if you need to do something else with this data.
I made a copy of the file on my home folder by the way. Most probably, the error you get is that you're trying to open the database while firefox has a lock on it.
*edit*
Also, there's a little trick with firefox, you can make another account for your testing, open firefox with:
Code:
firefox-3.0 -ProfileManager
That will let you create new profiles (that are stored in the .mozilla folder), with that you can test without screwing with important data.
Bookmarks