Skip to content

Instantly share code, notes, and snippets.

@slmingol
Forked from kwilczynski/script.sh
Last active February 6, 2022 22:26
Show Gist options
  • Save slmingol/605f7ccbd74c9e08ae1c8375106ae9ae to your computer and use it in GitHub Desktop.
Save slmingol/605f7ccbd74c9e08ae1c8375106ae9ae to your computer and use it in GitHub Desktop.
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