Chaz Meyers on 3 Jun 2009 20:07:15 -0700

[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PLUG] OT:Recovery of firefox bookmarks from places.sqlite

Judging by the schema here:

You should be able to run sqlite3 on the file and convert it into any
sort of format you would like. A query such as this should get most of
the information you'd be interested in:

sqlite> select * from moz_bookmarks, moz_places WHERE =;

If you're just moving it to a new Firefox installation, you might even
be able to drop the database in his profile directory when Firefox
isn't running. Haven't tried that, so I can't say for sure.

- Chaz Meyers

On Wed, Jun 3, 2009 at 9:05 PM, Michael Lazin <> wrote:
> Hi, I have a friend with a windoze computer that the motherboard died on.
> He bought a new computer.  He wants me to retrieve the files and firefox
> bookmarks from the hard drive of the old machine.  I plugged the hard drive
> into my linux box and mounted it and copied his "My Documents" and his
> places.sqlite files to an external hard drive.  How can I recover his
> bookmarks from the places.sqlite file?
> --
> Michael Lazin
> ASCII ribbon campaign ( )
> against HTML e-mail    X
>                                  / \
> ___________________________________________________________________________
> Philadelphia Linux Users Group         --
> Announcements -
> General Discussion  --
Philadelphia Linux Users Group         --
Announcements -
General Discussion  --