Gravity list messup

My first attempt an anything rasberry pi is a PiHole. I royally screwed up the gravity list by by downloading a block list and pasting all the actual URLs to be blocked into the add blocklist section.
Is there an easy way to delete 27000 entries? feeling like a bit of a loser hear, but I'm learning... Maybe via SSH, or something easier than clicking the trash can 27000 times.

This command will delete all your adlists. Then insert the one(s) you want to use, and rebuild gravity.

sudo sqlite3 /etc/pihole/gravity.db "DELETE FROM adlist"

Thanks for the help... That worked great.

1 Like

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