wfhoover Table Doesn’t exist MySQL Dump Error

  • Resolved Ramael Metatron

    (@rekast)


    8 years, 6 months ago

    I have had this issue in the past, and have come up against it again while migrating users to another server.
    When dumping a MYSQL Database with WF installed I get an error that completely fails the dump from CLI, which I need to perform for user migration

    mysqldump: Got error: 1146: Table ‘DBNAME_wfHoover’ doesn’t exist when using LOCK TABLES

    What is this and how should it be resolved? My entire backup process is failing due to this table.

    DB has been optimized already.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter Ramael Metatron

    (@rekast)

    8 years, 6 months ago

    I have WF on multiple sites, so I need a way to resolve this effectively.
    Also I need a way to resolve this outside of WordPress, these accounts are suspended and do not have web access.

    Thread Starter Ramael Metatron

    (@rekast)

    8 years, 6 months ago

    This resolves the issue when wordpress access is possible.
    https://support.wordfence.com/support/solutions/articles/1000010321-how-can-i-remove-all-wordfence-data-or-reset-wordfence-to-the-default-settings-

    But this error causes daily failed backups on my server due to the dump error.
    This is a major issue for me as it means using wordfence will fail my hosting account server backup.

    Anyone else come across this issue? its not new.

    wfyann

    (@wfyann)

    8 years, 6 months ago

    Hi @rekast,

    Can you confirm that the table appears in the output of the “mysqlshow db_name” command?

    If so, the most likely cause is that the table is corrupted and needs to be repaired.

    Thread Starter Ramael Metatron

    (@rekast)

    8 years, 6 months ago

    I have deactivated and removed wordfence, I do not have an install to troubleshoot it on at the moment.

    I don’t understand how every single site I had wordfence installed on would have a corrupted table. I think this is something related to the plugin and how it creates tables.

    Luckly the option to delete the tables helped me get over this issue.

    wfyann

    (@wfyann)

    8 years, 6 months ago

    Hi @rekast,

    We test Wordfence on a large variety of hosting systems and while we do hear about customers reporting crashed tables sometimes, it’s not something we see consistently.

    Which Storage Engine are you using? InnoDB or myISAM?
    In the latter case, please try using InnoDB instead since it’s less prone to crash.

    You mentioned that

    “every single site I had wordfence installed on would have a corrupted table.”

    so it would be interesting to check what all those sites have in common.

    Were they all on a specific host? Were they all using a specific MySQL version or a specific PHP version?

    Does your system meet all Wordfence system requirements?

    wfchloe

    (@wfchloe)

    8 years, 5 months ago

    Hello!

    I hope we were successful in helping you resolve your issue with Wordfence! Since we have not heard back from you in the past 2 weeks I will now be marking this support thread as resolved. However, if we still haven’t resolved your issue please reach out to us as we would be more than happy to further assist you!

    Thanks and have a great day!
    Chloe

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

The topic ‘wfhoover Table Doesn’t exist MySQL Dump Error’ is closed to new replies.