Firefox bookmarks

From Just Solve the File Format Problem
(Difference between revisions)
Jump to: navigation, search
(Created page with "{{FormatInfo |formattype=electronic |subcat=Web |subcat2=Web browser files }} '''Firefox bookmarks''' originally used the HTML-based Netscape bookmarks format, as did the...")
 
Line 7: Line 7:
 
'''Firefox bookmarks''' originally used the HTML-based [[Netscape bookmarks]] format, as did the Mozilla/Seamonkey Suite. However, as of Firefox 3.0, a new format was used based on [[DB (SQLite)|SQLite]] with write-ahead logging. The bookmarks are also regularly automatically backed up in the [[JSON]] format.
 
'''Firefox bookmarks''' originally used the HTML-based [[Netscape bookmarks]] format, as did the Mozilla/Seamonkey Suite. However, as of Firefox 3.0, a new format was used based on [[DB (SQLite)|SQLite]] with write-ahead logging. The bookmarks are also regularly automatically backed up in the [[JSON]] format.
  
The relevant files are '''places.sqlite''' and '''places.sqlite-wal''' in the user profile directory (system-specific; in Windows Vista it is '''\Users\''username''\AppData\Roaming\Mozilla\Firefox\Profiles\''cryptic-profile-ID''). This directory structure may be hidden depending on your operating system configuration. A subdirectory of this called '''bookmarkbackups''' has the backups, with filenames like '''bookmarks-2012-10-28.json''' which contain the date of the backup.
+
The relevant files are '''places.sqlite''' and '''places.sqlite-wal''' in the user profile directory (system-specific; in Windows Vista it is '''\Users\''username''\AppData\Roaming\Mozilla\Firefox\Profiles\''cryptic-profile-ID'''''). This directory structure may be hidden depending on your operating system configuration. A subdirectory of this called '''bookmarkbackups''' has the backups, with filenames like '''bookmarks-2012-10-28.json''' which contain the date of the backup.
  
 
The data structure in the SQLite file is given in the embedded command '''CREATE TABLE moz_bookmarks (id INTEGER PRIMARY KEY,type INTEGER, fk INTEGER DEFAULT NULL, parent INTEGER, position INTEGER, title LONGVARCHAR, keyword_id INTEGER, folder_type TEXT, dateAdded INTEGER, lastModified INTEGER, guid TEXT)'''.
 
The data structure in the SQLite file is given in the embedded command '''CREATE TABLE moz_bookmarks (id INTEGER PRIMARY KEY,type INTEGER, fk INTEGER DEFAULT NULL, parent INTEGER, position INTEGER, title LONGVARCHAR, keyword_id INTEGER, folder_type TEXT, dateAdded INTEGER, lastModified INTEGER, guid TEXT)'''.

Revision as of 18:11, 1 December 2012

File Format
Name Firefox bookmarks
Ontology

Firefox bookmarks originally used the HTML-based Netscape bookmarks format, as did the Mozilla/Seamonkey Suite. However, as of Firefox 3.0, a new format was used based on SQLite with write-ahead logging. The bookmarks are also regularly automatically backed up in the JSON format.

The relevant files are places.sqlite and places.sqlite-wal in the user profile directory (system-specific; in Windows Vista it is \Users\username\AppData\Roaming\Mozilla\Firefox\Profiles\cryptic-profile-ID). This directory structure may be hidden depending on your operating system configuration. A subdirectory of this called bookmarkbackups has the backups, with filenames like bookmarks-2012-10-28.json which contain the date of the backup.

The data structure in the SQLite file is given in the embedded command CREATE TABLE moz_bookmarks (id INTEGER PRIMARY KEY,type INTEGER, fk INTEGER DEFAULT NULL, parent INTEGER, position INTEGER, title LONGVARCHAR, keyword_id INTEGER, folder_type TEXT, dateAdded INTEGER, lastModified INTEGER, guid TEXT).

Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox