• Resolved xfe2532929046

    (@xfe2532929046)


    mysqldump: Got error: 145: Table ‘./dataname@002ecom/wp_wfHits’ is marked as crashed and should be repaired when using LOCK TABLES

    When we want to backup database to databasename.sql, it show a error as above.
    We delete the wordfence but the problem still exist.
    What can we do? Thank you so much!

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

    (@wfadam)

    Hello @xfe2532929046 and thanks for reaching out to us!

    It looks like something is causing the crash in the wfHits table, which usually shows Live Traffic feed. I would suggest clearing the tables and recreating them to see if that resolves the issue.

    A complete re-install of Wordfence might be a good step. It’s always best to make a backup of the site and database before installing/removing plugins, just to be safe.

    Additionally, you can 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.

    Let me know if this helps!

    Thanks again!

    Thread Starter xfe2532929046

    (@xfe2532929046)

    A complete re-install of Wordfence might be a good step. It’s always best to make a backup of the site and database before installing/removing plugins, just to be safe.
    =====
    Thank you for your reply.
    We have reinstalled.(Stop plug-in operation、Then delete the plugin-Wordfence,but problem still exist)
    Can’t solve the problem.
    Whether after delete the plug-in,
    We also need to restart the server?
    Thank you very much!

    Plugin Support WFAdam

    (@wfadam)

    Thanks for trying that!

    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.

    Thanks again!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘mysqldump error: 145 wp_wfHits’ is marked as crashed’ is closed to new replies.