Support » Plugin: Wordfence Security - Firewall & Malware Scan » Too many DB tables

  • Resolved mirgcire

    (@mirgcire)


    Why do I have 29 DB table staring with “wf”? Seems a bit excessive any chance you could clean up a bit? Or maybe tell me which ones are not needed

Viewing 3 replies - 1 through 3 (of 3 total)
  • Hi @mirgcire,

    I’m only seeing 19 tables that start with wp_wf for me.

    Can you list out or take a screenshot of all the tables that start with wf for you?

    For example: https://i.imgur.com/q5mLr0s.png

    Dave

    Thread Starter mirgcire

    (@mirgcire)

    Here is a snapshot of the wf tables https://imgur.com/a/HZUp1ZU

    Hi again!

    It looks like you have some old tables from a previous version of Wordfence.

    I wrote a query for you to clean up your database:

    SET foreign_key_checks = 0;
    DROP TABLE IF EXISTS qbc_wfBlocks, qbc_wfBlocksAdv, qbc_wfLockedOut, qbc_wfThrottleLog, qbc_wfNet404s, qbc_wfBlockedCommentLog, qbc_wfVulnScanners, qbc_wfBadLeechers, qbc_wfScanners;
    SET foreign_key_checks = 1;

    If you’d prefer to manually delete these tables, this is the list of tables you can safely delete (Wordfence no longer uses them in the latest version):

    qbc_wfBlocks
    qbc_wfBlocksAdv
    qbc_wfLockedOut
    qbc_wfThrottleLog
    qbc_wfNet404s
    qbc_wfBlockedCommentLog
    qbc_wfVulnScanners
    qbc_wfBadLeechers
    qbc_wfScanners

    Dave

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Too many DB tables’ is closed to new replies.