WordPress.org

Ready to get started?Download WordPress

Forums

Wordfence Security
[resolved] Remove WF from Database (22 posts)

  1. mcgroup
    Member
    Posted 1 year ago #

    I uninstalled and deleted this plugin, however there are tons of WF files still in my database. How do I clean this up? When you delete something - it should delete everything - not just portions of it.

    http://wordpress.org/extend/plugins/wordfence/

  2. LLP
    Member
    Posted 1 year ago #

    I have the exact same issue....WordFence caused a mess on my blog within hours after installing so I immediately deleted the plugin, but there were about 15 tables left behind. I cannot figure out how to get rid of them.

    I use the Garbage Plugin to collect leftovers from plugins that have been uninstalled, and it finds the WordFence tables but when hit delete, they do not get removed.

    Please tell me how to delete everything having to do with WordFence. I am not a techie person so the simplest way possible please.

  3. Marcelo Pedra
    Member
    Posted 1 year ago #

    Hi, just enter your hosting control panel. In a decent hosting service, you should have phpmyadmin installed. Browse the tables in your database and delete the following:

    wp_wfBadLeechers
    wp_wfBlocks
    wp_wfConfig
    wp_wfCrawlers
    wp_wfFileMods
    wp_wfHits
    wp_wfHoover
    wp_wfIssues
    wp_wfLeechers
    wp_wfLockedOut
    wp_wfLocs
    wp_wfLogins
    wp_wfNet404s
    wp_wfReverseCache
    wp_wfScanners
    wp_wfStatus
    wp_wfThrottleLog
    wp_wfVulnScanners
  4. mcgroup
    Member
    Posted 1 year ago #

    Thanks but I figured it out to do just what you recommended back when I had the problem. When you delete a plugin, it should delete everything from the database. I won't be using this plugin again.

  5. Svetlana0777
    Member
    Posted 1 year ago #

    I agree with mcgroup! The tables should be removed after I deactivated the plugin. Looks like back door... :(

    What else should I remove?

  6. Marcelo Pedra
    Member
    Posted 1 year ago #

    Yep, it should. But since WordFence is a security firewall which is logging bad behaviour and suspicious activities, you may want to reinstall o reactivate it and reanalyze the logs. Also, they surely assume that in those scenarios, having the logs in place may ease scanning.

    But wait, did you see the plugin options screen? Please notice that there is an option at the end:

    Delete Wordfence tables and data on deactivation?

    Did it work?

  7. mcgroup
    Member
    Posted 1 year ago #

    @Marcelo Peda, I never saw the line:

    Delete Wordfence tables and data on deactivation?

    When I deactivated and wanted to delete it. I got rid of the plugin because it locked me out of my own website and I had to go in via FTP to remove the plugin.

  8. Peter Luit
    Member
    Posted 1 year ago #

    Don't use this plug in, it makes an overload in SQL tables and size.....

  9. Marcelo Pedra
    Member
    Posted 1 year ago #

    I recognize it's a heavy load but the options to tune it are present. You only need to have patience and configure it. Hint: in shared hosting environments it may obviously overload your database because shared hostings are commonly oversold and crowded, so you are sharing memory and cpu with zillions of websites...

  10. robbiegod
    Member
    Posted 1 year ago #

    What version of the plugin were you using? @LLP, you say it made a mess on your blog. What do you mean by that?

  11. aaronprill
    Member
    Posted 1 year ago #

    Even though I had de-activated WordFence a couple weeks ago, my shared hosting account got suspended because the wp_wfFileMods table had grown to over 2.2 GIGS! Deleting that table (and all other WF tables) fixed my issue (and satisfied my shared host), but what do you think caused such an over growth of that table while the plugin was de-activated? Is it likely the table growth took place before I de-activated it, and it just took 2 weeks for my shared hosting provider noticed?

    Thanks,
    Aaron

  12. Marcelo Pedra
    Member
    Posted 1 year ago #

    @aaronaprill The tables in database cannot grow if the plugin is deactivated. Are you sure that the size wasn't overgrown before you deactivate the plugin?

  13. aaronprill
    Member
    Posted 1 year ago #

    @Marcelo- Yes, that is likely the case and I had updated my comment above to suggest that... Probably just took my host 2 weeks to notice it and shut me down.

    So, to reword my original question, what would cause the wp_wfFileMods table to grow so large (2.2 GIG in my case)?

  14. Marcelo Pedra
    Member
    Posted 1 year ago #

    wp_wfFileMods contains the changelog of files in your server. The plugin check plugins and themes folders and compare those files with the originals in the wordpress official repositories. This is done by keeping a detailed track of all the files in your wordpress installation.

    My tables for this aren't so big, so I assume you probably have a huge WordPress installation, with plenty of plugins, themes and/or lots of images uploaded.

    In the other hand, did you optimize the tables of your database sometimes? Because deleted data in the database generate gaps of garbage that can make grow a database and even make it underperform.

  15. Michael Wiener
    Member
    Posted 1 year ago #

    I have the same problem just as described in this thread. I tried several tools, but still no luck on deleting those leftovers. I haven't tried using the phpMyadmin, though.

    What worked for me was I had to reinstall Wordfence. Once Wordfence was installed, I went to Options and select;

    Delete Wordfence tables and data on deactivation?

    Just as Marcelo Pedra posted.

    Once it the option was selected, I attempted to Deactivate the plugin and check the database with WP-Optimize, which is the one I'm using to optimize my database.

    Guess what??? All those wp_wfxxxxx things are gone. Then, I go ahead and deleted Wordfence completely.

    Checked the database once again with WP-Optimize.... all those unwanted entries are gone completely.

    Hope this will help those who are in trouble getting rid of the Wordfence remnants. A good plugin, though it create plenty of problems in the long run and slows down the website like a turtle.

  16. RobinInTexas
    Member
    Posted 1 year ago #

    You can use http://wordpress.org/plugins/wp-dbmanager/ to delete unwanted tables

  17. Michael Wiener
    Member
    Posted 1 year ago #

    @RobinInTexas

    I've tried that on the other site with Wordfence installed that I want to get rid of, didn't work. I don't know why WP database cleaner/manager won't work with Wordfence leftovers. Other entries can be deleted easily, just Wordfence leftovers are very stubborn.

    So, for those who want to try Wordfence, make sure you select the option;

    Delete Wordfence tables and data on deactivation?

    This way, if you want to get rid of it later on, there will be no leftovers when it is deactivated or deleted.

  18. Marcelo Pedra
    Member
    Posted 1 year ago #

    @RobinInTexas
    @Michael Wiener
    If possible, the BEST option is to get rid of unneeded plugins, which ultimately will add memory usage to your WP installation. So, if you have a control panel for your hosting, try using phpmyadmin, which is able to force delete those leftovers.
    If such a tool is unavailable for any reason and wp-optimize usage is the only way out, remember to deactivate these cleaning plugins after use, to alleviate the performance of your entire WordPress installation. In brief: activate it, use it, deactivate it till next time. :)

  19. arjanbosch
    Member
    Posted 1 year ago #

    Today the same problem happened to me. A Wordfence update went wrong. I immediately got 500 server error messages as I tried to open posts. And I couldn't open Dashboard items anymoree. Constant server error 500. I arranged placing a backup, but this didn't work. I followed the directions as mentioned above: Word tables Fence removed in the DB. Nothing helps. Very stressfull! Who can help me? the site with the problems http://www.kzod.nl.

  20. TheCompGuru
    Member
    Posted 12 months ago #

    This is ridiculous. A coworker installed your plugin after they're blog was hacked. And believe it or not, I've spent more time removing what this plugin left behind, than what the hackers did.

    And if you wondering... No, the plugin didn't find a thing. I did though.

  21. TheCompGuru
    Member
    Posted 12 months ago #

    And it looks like the most recent version has one more table than is mentioned above.

    wp_wfBadLeechers
    wp_wfBlocks
    wp_wfBlocksAdv
    wp_wfConfig
    wp_wfCrawlers
    wp_wfFileMods
    wp_wfHits
    wp_wfHoover
    wp_wfIssues
    wp_wfLeechers
    wp_wfLockedOut
    wp_wfLocs
    wp_wfLogins
    wp_wfNet404s
    wp_wfReverseCache
    wp_wfScanners
    wp_wfStatus
    wp_wfThrottleLog
    wp_wfVulnScanners

    If your database looks like mine, ie. same tables and prefix. Run this query in phpmyadmin.

    drop table wp_wfBadLeechers, wp_wfBlocks, wp_wfBlocksAdv, wp_wfConfig, wp_wfCrawlers, wp_wfFileMods, wp_wfHits, wp_wfHoover, wp_wfIssues, wp_wfLeechers, wp_wfLockedOut, wp_wfLocs, wp_wfLogins, wp_wfNet404s, wp_wfReverseCache, wp_wfScanners, wp_wfStatus, wp_wfThrottleLog, wp_wfVulnScanners

  22. Wordfence
    Member
    Plugin Author

    Posted 11 months ago #

    Folks please please read this before you add to this thread:

    As many posters have mentioned there is an option at the bottom of the Wordfence 'options' page titled:

    Delete Wordfence tables and data on deactivation?

    Check this and then hit save. Then deactivate Wordfence. All the tables we create will be removed including any other data we add.

    If you want to optimize Wordfence for speed, simply disable Live traffic. That will reduce database load on smaller web servers and speed up your site.

    We run Wordfence with full live traffic and all the trimmings on all our own production sites without any performance issues.

    Again: You do not need phpmyadmin to remove Wordfence data. It's already built in. You can also use this technique to reset Wordfence to defaults or simply clean up the tables. Check the box to remove Wordfence data, then disable and reenable the plugin and you have a clean Wordfence database.

    Regards,

    Mark.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.