In an iPhone backup, the file 2e57c396a35b0d1bcbc624725002d98bd61d142b is browser.db. Firefox for iOS's older history database: sites visited and when.
| Real name | browser.db |
| Domain | AppDomainGroup-group.org.mozilla.ios.Firefox |
| Path | profile.profile/browser.db |
| In the backup folder | 2e/2e57c396a35b0d1bcbc624725002d98bd61d142b |
| Its name is the SHA-1 of | AppDomainGroup-group.org.mozilla.ios.Firefox-profile.profile/browser.db |
| App | Firefox for iOS |
| Seen in | iOS 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 backup | No. Apple's encrypted-only rule for website history is about Safari. Firefox history can be in an unencrypted backup. |
| OpenExtract reads it | Yes, on the Web history screen. Guide: Export Safari and Firefox history |
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.
history.url: The web address.history.title: The page's title.visits.siteID: Which address was visited: its id in history.visits.date: When, in microseconds since 1 January 1970 (UTC).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
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