What's new

AdGuardHome Open AdGuard Home stats file

Markfree

Regular Contributor
AdGuard Home has a stats.db file located at:
Bash:
# ls -lah /opt/etc/AdGuardHome/data/stats.db
-rw-r--r--    1 root   root        4.0M Mar 10 21:00 /opt/etc/AdGuardHome/data/stats.db

Initially I thought it was SQLite file, but when I tried to open it, SQLite says the file is not a database.
Bash:
# sqlite3 /opt/etc/AdGuardHome/data/stats.db
SQLite version 3.40.0 2022-11-16 12:10:08
Enter ".help" for usage hints.
sqlite> .dbinfo
SQL:
sqlite> .databases
main: /tmp/mnt/entware/entware/etc/AdGuardHome/data/stats.db r/w
SQL:
sqlite> .dbinfo
error: file is not a database

The same happens for the sessions.db file.

How can I open these .db files?
 

Similar threads

Support SNBForums w/ Amazon

If you'd like to support SNBForums, just use this link and buy anything on Amazon. Thanks!

Sign Up For SNBForums Daily Digest

Get an update of what's new every day delivered to your mailbox. Sign up here!
Back
Top