Clean or Delete a huge Blacklist

I was trying something and by mistake added A LOT of domains to my blacklist

I know I can delete them in the GUI but they so many that I really want to know if there is a way to do it without going one by one.

Deleting all the records will be also fine, but I don’t want to screw my setup by breaking something

Which version are you using? You can easily delete multiple or all blacklist entirety via Sql on the command line in version v5.

https://docs.pi-hole.net/database/gravity/

To delete all exact blacklist

sudo sqlite3 /etc/pihole/gravity.db "delete from domainlist where type=1;"

2 Likes

thank you very much, that fix it!

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.