Backup files · Safari

d1f062e2da26192a6625d968274bfda8d07821e4is Bookmarks.db

In an iPhone backup, the file d1f062e2da26192a6625d968274bfda8d07821e4 is Bookmarks.db. Safari's bookmarks and bookmark folders.

Real nameBookmarks.db
DomainHomeDomain
PathLibrary/Safari/Bookmarks.db
In the backup folderd1/d1f062e2da26192a6625d968274bfda8d07821e4
Its name is the SHA-1 ofHomeDomain-Library/Safari/Bookmarks.db
AppSafari
Seen iniOS 13.3.1, 13.4.1, 15.3.1, 16.0, 16.1.2 and 17.3.
Needs an encrypted backupNo. Unencrypted backups have it too.
OpenExtract reads itNot yet.

What it holds

Bookmarks.db holds Safari's bookmarks. Each bookmark and each folder is a row in the bookmarks table, with its title, its web address in url, and parent, the folder it's in.

Key columns

Tables by iOS version

iOS 13.3.1 has 5 tables:

bookmark_title_words, bookmarks, folder_ancestors, generations, sync_properties

Then, version by version:

The iOS 16.0 backup is encrypted with a password that isn't public, so only its list of files was checked, not its tables.

How to open it

OpenExtract doesn't read it yet. OpenExtract's Web history screen reads Safari's History.db, not its bookmarks.

By hand. In a backup that isn't encrypted, d1/d1f062e2da26192a6625d968274bfda8d07821e4 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. Tools such as iphone_backup_decrypt, the open-source library OpenExtract uses, can decrypt a single file; then open the decrypted copy with any SQLite browser, such as DB Browser for SQLite.

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 →