Skip to content

Instantly share code, notes, and snippets.

Forked from kwilczynski/
Last active Feb 6, 2022
What would you like to do?
Dump ad list (ad blocking list), whitelist and blacklist from Sqlite database on Pi Hole
sqlite3 /etc/pihole/gravity.db -header -csv 'select * from adlist' > adlist.csv
sqlite3 /etc/pihole/gravity.db -header -csv 'select * from vw_whitelist' > whitelist.csv
sqlite3 /etc/pihole/gravity.db -header -csv 'select * from vw_blacklist' > blacklist.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment