Clean or Delete a huge Blacklist

Help
1

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

2

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

To delete all exact blacklist

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

3

thank you very much, that fix it!