Error with database Backup – Memory Limit

  • Resolved Matt Scheidler

    (@matt6303)


    8 months ago

    I tried adding a comment to another’s topic here but it got deleted. I understand the forum guidelines but in this case I felt it was helpful information…I’ve been a member here for over 13 years and don’t tack on to someone else’s topic unless it makes sense. This time did, in my estimation.

    Anyway, I am having the exact same problem as the issue here:

    https://www.ads-software.com/support/topic/error-with-database-backup-memory-limit/

    The site in question is also on Ionos hosting. I have BackWPup on dozens of sites, but just one of those sites is on Ionos and it’s the only site experiencing the problem.

    The issue is directly related to the size of the wp_options table. At this moment I am unable to determine whether it’s an issue with the site or with the hosting, but with @fitnsexy describing the exact same issue with the exact same host, I wanted to add a comment. Perhaps my information might be helpful.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support happyAnt

    (@duongcuong96)

    Hi @matt6303

    did you increase the PHP memory limit?

    Also, in case the backup database is too large, I would suggest you split the database backup into smaller jobs, so for example, one job for just backup wp_options table, and another one for backup all remains tables.

    Plugin Support happyAnt

    (@duongcuong96)

    since we haven’t heard back from you, I’m going to mark it as resolved.
    In case you’re still having problems, feel free to let us know!

    Thread Starter Matt Scheidler

    (@matt6303)

    Yes, I’m still having problems, but I’m not sure it’s a BWU problem. I have increased the PHP memory limit and created a new Job with just the one table and it still gives me the same error:

    [01-Apr-2024 02:57:21] ERROR: Allowed memory size of 170917888 bytes exhausted (tried to allocate 9533984 bytes)

    For now I’m just running two separate jobs and at least getting everything else backed up. It’s only happening on one site, which is hosted on a different server than my other BWU sites that are still working fine. So it’s likely either site-specific, or host-specific. I haven’t given up my investigation but I’m not sure as of now if there’s anything more BWU can do. Thank you.

    Plugin Support happyAnt

    (@duongcuong96)

    can you help me exclude all unrelated to WordPress folders, these folders? In backup WordPress install folder, just keep wp-admin wp-content and wp-includes

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Error with database Backup – Memory Limit’ is closed to new replies.