Skip to content

Instantly share code, notes, and snippets.

@slmingol
Forked from kwilczynski/script.sh
Last active Feb 6, 2022
Embed
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