• Resolved jamieschmid

    (@jamieschmid)


    In trying to export our database, we’ve discovered the wfconfig Wordfence table is 2.2gb in size! What could be causing this, and how do we get it to a more manageable size?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support WFAdam

    (@wfadam)

    Hello @jamieschmid and thanks for reaching out to us!

    Can you send a diagnostic report to wftest @ wordfence . com? You can find the link to do so at the top of the Wordfence Tools > Diagnostics page. Then click on “Send Report by Email”. Please add your forum username where indicated and respond here after you have sent it.

    I want to check your tables and PHP version. I have seen this happen in the past but I want to find what might be the cause for you.

    Thanks!

    Thread Starter jamieschmid

    (@jamieschmid)

    Done! Thank you for looking into this 🙂

    Plugin Support WFAdam

    (@wfadam)

    It looks like it could be the PHP version you are running. It’s known for creating duplicate entries within the data tables, causing the size to expand at a rapid rate.

    You can either do the bandaid fix or the long-term fix.

    Bandaid fix:
    Backup your Wordfence settings via the Export option. Navigate to Wordfence > Tools > Import/Export Options and click Export. You can also take note of the current Whitelisted URLs you have in Wordfence > Firewall > All Firewall Options > Whitelisted URLs as these are NOT included in the Import/Export, and will be lost during the re-install.
    Here is what is exported: https://www.wordfence.com/help/tools/import-export/
    During the export, you will be given a long string of text. Keep this safe, you’ll need it in a few minutes.

    After that, enable the option to Delete Wordfence tables and data on deactivation in All Options > General Wordfence Options. You will want to remember to disable this after you reinstall Wordfence again.

    After you enable that option, you can deactivate Wordfence from the Plugins area of your site, then delete it. Next, from the plugins area, search for and re-install Wordfence like normal.

    It will be like setting Wordfence up for the first time. You will need to enter an email address, and then go into Tools > Import/Export Options and paste that string of text into the Import Wordfence Options field and click the button there.

    The firewall will be in Learning Mode by default for 7 days. I would recommend switching this to Enabled and Protected as soon as possible.`

    Long Term Fix:
    Upgrade your PHP to 7.4.x. This will resolve the tables duplicating. Once you upgrade you will have to reinstall with the instructions above as well.

    Let me know if this helps!

    Thanks!

    Thread Starter jamieschmid

    (@jamieschmid)

    I just wanted to update that the above instructions worked for us. Thank you for your help @WFAdam

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘2.2gb wfconfig table ?’ is closed to new replies.