Skip to content

Instantly share code, notes, and snippets.

@slmingol

slmingol/script.sh

Forked from kwilczynski/script.sh
Last active February 6, 2022 22:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save slmingol/605f7ccbd74c9e08ae1c8375106ae9ae to your computer and use it in GitHub Desktop.
Save slmingol/605f7ccbd74c9e08ae1c8375106ae9ae to your computer and use it in GitHub Desktop.
Download ZIP
Dump ad list (ad blocking list), whitelist and blacklist from Sqlite database on Pi Hole
Raw
script.sh
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