Firefox bookmarks - Revision history

Dan Tobias at 16:07, 8 February 2020

2020-02-08T16:07:12Z

2020-02-08T13:26:37Z

Category:SQLite based file formats

2018-05-02T17:15:40Z

2017-05-14T03:13:51Z

2017-04-23T16:09:41Z

Category:JSON based file formats

2016-05-04T15:47:30Z

Category:File formats with a distinctive filename

2014-04-27T13:12:39Z

2013-09-07T15:46:42Z

2013-05-25T11:17:21Z

2013-04-13T03:02:24Z

@@ Line 9: / Line 9: @@
 '''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 and 7 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, at least from Vista through 10, 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.
 Other things including site visit history are also stored in the places.sqlite database.

@@ Line 49: / Line 49: @@
 [[Category:Mozilla]]
 [[Category:JSON based file formats]]
 [[Category:File formats with a distinctive filename]]

@@ Line 5: / Line 5: @@
 |extensions={{ext|sqlite}}, {{ext|sqlite-wal}}, {{ext|json}}
 }}
 '''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.

@@ Line 5: / Line 5: @@
 |extensions={{ext|sqlite}}, {{ext|sqlite-wal}}, {{ext|json}}
 }}
-'''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 [[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 and 7 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.

← Older revision		Revision as of 16:09, 23 April 2017
Line 46:		Line 46:

	[[Category:Mozilla]]		[[Category:Mozilla]]
		+	[[Category:JSON based file formats]]
	[[Category:File formats with a distinctive filename]]		[[Category:File formats with a distinctive filename]]

@@ Line 9: / Line 9: @@
 The relevant files are '''places.sqlite''' and '''places.sqlite-wal''' in the user profile directory (system-specific; in Windows Vista and 7 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 [[SQL]] commands:
@@ Line 41: / Line 43: @@
 * [https://support.mozilla.org/en-US/kb/import-bookmarks-html Import bookmarks from an HTML file]
 * [http://kb.mozillazine.org/Backing_up_and_restoring_bookmarks_-_Firefox Backing up and restoring bookmarks]
+* [http://kb.mozillazine.org/Places.sqlite Mozillazine knowledge base: places.sqlite]
 [[Category:Mozilla]]

@@ Line 10: / Line 10: @@
 The relevant files are '''places.sqlite''' and '''places.sqlite-wal''' in the user profile directory (system-specific; in Windows Vista and 7 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 commands:
+The data structure in the SQLite file is given in the embedded [[SQL]] commands:
 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)

← Older revision		Revision as of 11:17, 25 May 2013
Line 37:		Line 37:

	CREATE TABLE moz_hosts ( id INTEGER PRIMARY KEY, host TEXT NOT NULL UNIQUE, frecency INTEGER, typed NOT NULL DEFAULT 0, prefix)		CREATE TABLE moz_hosts ( id INTEGER PRIMARY KEY, host TEXT NOT NULL UNIQUE, frecency INTEGER, typed NOT NULL DEFAULT 0, prefix)
		+
		+	== Links ==
		+	* [https://support.mozilla.org/en-US/kb/import-bookmarks-html Import bookmarks from an HTML file]
		+	* [http://kb.mozillazine.org/Backing_up_and_restoring_bookmarks_-_Firefox Backing up and restoring bookmarks]
		+

	[[Category:Mozilla]]		[[Category:Mozilla]]