Save/export Live Traffic

Thanks for reaching out.

There isn’t a way in the plugin functionality but you could do it manually by running a MySQL query. Our documentation online (Check this page in the FAQ section) says you can export a list of blocked IPs this way:

If you want to extract blocked IPs from the database so that you can process them with other software then you can run a MySQL query like this below. Read the additional notes prior to running the query to prevent the query from failing.

SELECT INET6_NTOA(IP) FROM wp_wfBlocks7

If you want to output the results to a file, you can do that with this code:

SELECT INET6_NTOA(IP) FROM wp_wfBlocks7
INTO OUTFILE ‘/writable_directory_by_mysql/blocked_IPs.csv’
LINES TERMINATED BY ‘\n’;

Notes:

1) Please note that MySQL >= 5.6 is required.

2) Don’t forget to update the prefix before running your query if you have changed the default WordPress database table prefix.

3) You will need to change the table name to all lowercase letters if you installed version 7.1.12 or greater when you first installed Wordfence on your site: wfblocks7

4) If you are running a version of Wordfence prior to version 7.3.1 and you first installed Wordfence prior to version 7.1.12 being released then the table name is: wfBlocks

I hope this helps.

Tim

• This reply was modified 2 years, 10 months ago by WFSupport.