• Resolved tomforster

    (@tomforster)


    When I backup my site it fails to backup my database everything else is backed up just fine.

    It seems to get stuck on the same table in my database every time ha3v_wfhoover

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor bcrodua

    (@bcrodua)

    Hi,

    Can you please send us a copy of the latest full backup log?
    This can be found in the UpdraftPlus Existing Backups tab.
    The contents will be too long to post here directly, but you can use an online service such as Dropbox or Pastebin, and post the link here.

    Regards,
    Bryle

    Thread Starter tomforster

    (@tomforster)

    Plugin Contributor bcrodua

    (@bcrodua)

    Hi,

    It shows that the backup process is timed out or killed off while backing up the database.

    I would suggest asking your hosts/server admin to investigate their PHP error logs. These logs should contain more information on the exact issue that is causing the backup process to halt.

    Kind Regards,
    Bryle`

    Thread Starter tomforster

    (@tomforster)

    I’ve spoke with my host and they said the following:

    `After investigating the PHP error log for your domain name – itphire.co.uk we managed to see that there are errors related to the plugin UpdraftPlus_backup.

    The last entry states that the WordPress database error Table ‘itphire_db.ha3v_wfhoover’ doesn’t exist for query DESCRIBE ha3v_wfhoover

    Here is the full error entry:
    [26-May-2021 08:06:57 UTC] WordPress database error Table ‘itphire_db.ha3v_wfhoover’ doesn’t exist for query DESCRIBE ha3v_wfhoover made by do_action_ref_array(‘updraft_backup_resume’), WP_Hook->do_action, WP_Hook->apply_filters, UpdraftPlus->backup_resume, UpdraftPlus_Backup->backup_db, UpdraftPlus_Backup->backup_table

    You are able to view the full error log here:
    /home/itphire/logs/itphire_co_uk.php.error.log

    Plugin Contributor bcrodua

    (@bcrodua)

    Hi,

    Can you ask your host to increase your server resources (I/O limit, maximum_execution_timeout and site memory)?

    Regards,
    Bryle

    Thread Starter tomforster

    (@tomforster)

    I asked my hosting to double our current resources you listed this has had no effect

    The backup still gets stuck on the table ha3v_wfhoover

    Plugin Contributor DNutbourne

    (@dnutbourne)

    Hi,

    Apologies for the delay.

    In this case, I would recommend excluding the problem table in question.
    The ha3v_wfhoover table is part of the WordFence plugin, and used to store URLs flagged during a scan.

    As such, excluding it from the backup should not cause any issues.

    Instructions on how to exclude a database table can be found here:
    https://updraftplus.com/faqs/how-can-i-exclude-a-specific-table-from-the-backup/

    Is there any issue regarding that table logged in the WordFence diagnostics?
    If so, I would also recommend contacting WordFence support regarding the issue.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Failing to Back up database’ is closed to new replies.