SystemJargon SystemJargon
kwilczynski
/ script.sh
Created
March 23, 2021 10:35
Dump ad list (ad blocking list), whitelist and blacklist from Sqlite database on Pi Hole
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |