Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@kwilczynski

kwilczynski/script.sh

Created March 23, 2021 10:35
Show Gist options
  • Star 5 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save kwilczynski/9e92b7a8028ebbcbb6481909a51ad15a to your computer and use it in GitHub Desktop.
Save kwilczynski/9e92b7a8028ebbcbb6481909a51ad15a 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 gravity.db.backup -header -csv 'select * from adlist' > adlist.csv
sqlite3 gravity.db.backup -header -csv 'select * from vw_whitelist' > whitelist.csv
sqlite3 gravity.db.backup -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