Adding many lists via Shell

[jfb]

@e-renner

This script imports my blocklists, exakt blocking and whitelisting entries and the regEXes.

Have you considered using the teleporter function, which exports all your existing Pi-hole settings for later import into the new installation?

@e-renner

What did you change at the database-structure?

Yes.

https://github.com/pi-hole/FTL/pull/1255

Delete queries error

With the latest version the database schema has changed. The actual data is stored in the new table query_storage. The queries is a view only from which you can't delete queries anymore. Furthermore, the client information is not stored in query_storage as IP but rather an ID linked to the new client_by_id table. You need to do two things now: sqlite3 /etc/pihole/pihole-FTL.db "DELETE FROM query_storage WHERE client='192.168.10.51';" To delete the remaining queries for 192.168.10.51 before th…