Backup files · Firefox for iOS

2e57c396a35b0d1bcbc624725002d98bd61d142bis browser.db

In an iPhone backup, the file 2e57c396a35b0d1bcbc624725002d98bd61d142b is browser.db. Firefox for iOS's older history database: sites visited and when.

Real namebrowser.db
DomainAppDomainGroup-group.org.mozilla.ios.Firefox
Pathprofile.profile/browser.db
In the backup folder2e/2e57c396a35b0d1bcbc624725002d98bd61d142b
Its name is the SHA-1 ofAppDomainGroup-group.org.mozilla.ios.Firefox-profile.profile/browser.db
AppFirefox for iOS
Seen iniOS 15.3.1, 16.1.2 and 17.3. Not in the iOS 13.3.1, 13.4.1 and 16.0 backups we checked.
Needs an encrypted backupNo. Apple's encrypted-only rule for website history is about Safari. Firefox history can be in an unencrypted backup.
OpenExtract reads itYes, on the Web history screen. Guide: Export Safari and Firefox history

What it holds

browser.db is the history database of older Firefox for iOS versions. history has one row per web address and visits one row per visit.

Newer versions keep history in places.db, next to it. A backup can have both.

Key columns

Tables by iOS version

The same 29 tables in every backup we opened (iOS 15.3.1, 16.1.2 and 17.3):

activity_stream_blocklist, bookmarksBuffer, bookmarksBufferStructure, bookmarksLocal, bookmarksLocalStructure, bookmarksMirror, bookmarksMirrorStructure, cached_top_sites, clients, commands, domains, favicon_site_urls, favicon_sites, favicons, highlights, history, history_fts, history_fts_docsize, history_fts_segdir, history_fts_segments, history_fts_stat, matview_awesomebar_bookmarks_with_favicons, page_metadata, pending_deletions, pinned_top_sites, queue, remote_devices, tabs, visits

How to open it

Free, in OpenExtract. Open the backup in OpenExtract and choose Web history. Timeline uses it too. OpenExtract reads both Firefox files and lists their visits with Safari's. Step by step: Export Safari and Firefox history.

By hand. In a backup that isn't encrypted, 2e/2e57c396a35b0d1bcbc624725002d98bd61d142b is an ordinary SQLite database with no extension. Copy it out of the backup folder and open the copy with any SQLite browser, such as DB Browser for SQLite. Work on a copy: changing anything inside a backup can stop it from restoring.

In an encrypted backup, the file in the backup folder is encrypted with a key of its own, which only the backup password unlocks, so nothing can open it until it's decrypted. OpenExtract does that when you open the backup and type its password.

Checked against public test backups from iOS 13.3.1, 13.4.1, 15.3.1, 16.1.2 and 17.3, and the file list of an iOS 16.0 backup, reading only file, table and column names. How we checked · All backup files

Read the backup, not the hashes.
OpenExtract opens iPhone backups for you. Free, open source, nothing uploaded. Mac · Windows · Linux.
Download OpenExtract →