How can I clear wp_wfHits table?

  • Resolved Merkucio

    (@merkucio)


    6 years, 10 months ago

    Hi,

    wp_wfHits table is 133 mb already.

    I know about the ‘Amount of Live Traffic data to store’ option, but I don’t want to modify it, I want to clear this table safely for my DB and website.

    Live traffic is disabled already.

    How is it possible?

Viewing 3 replies - 1 through 3 (of 3 total)

  • Hi merkucio!

    You can simply truncate the table using a tool like phpMyAdmin for example. Some of the statistics in Wordfence may be affected but you should see no other impact on the site than that.

    Best of luck with your site!

    Thread Starter Merkucio

    (@merkucio)

    Thanks for you reply.

    Do you mean to use the SQL command TRUNCATE TABLE 'wp_wfHits'; from phpMyAdmin/tool?

    • This reply was modified 6 years, 10 months ago by Merkucio.

    That’s one way. You can also truncate under the “Operations” tab in phpMyAdmin when viewing the table. And you can select the table in the table overview and choose “Empty” in the droplist below the tables.

    If you are not familiar with working like this in phpMyAdmin I would recommend you ensure you have backups of the database, though this specific procedure should be fairly easy. Just in case you pick the wrong table or something like that… ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How can I clear wp_wfHits table?’ is closed to new replies.