Host Build Interrupt and Mysqldump

  • Resolved Greybox

    (@greybox)


    1 year, 5 months ago

    I’ve been using Duplicator for many years. Recently I started seeing “Host Build Interrupt” errors. Reinstalled the plugin – same problem. My last successful backup was done on April 30, 2023. I increased PHP Max Execution Time from 30 seconds to 4 minutes, but the problem didn’t go away. I noticed that the DUPLICATOR-LITE PACKAGE-LOG file contains the following:

    ***********************************************
DATABASE:
***********************************************

BUILD MODE: MYSQLDUMP
MYSQLTIMEOUT: 5000
MYSQLDUMP: Is Supported
MYSQL DUMP ERROR 2
===============================================
DUPLICATOR ERROR
Please try again! If the error persists see the Duplicator 'Help' menu.
-----------------------------------------------
MESSAGE:
Shell mysql dump error. Change SQL Mode to the "PHP Code" in the Duplicator > Settings > Packages

    So I changed the SQL Mode from Mysqldump to PHP Code and the backup started to work again. My Duplicator version is 1.5.4. My backup size is around 263MB.

    Why Mysqldump mode doesn’t work anymore?

    • This topic was modified 1 year, 5 months ago by Greybox.
    • This topic was modified 1 year, 5 months ago by Greybox.
Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support mohammedeisa

    (@mohammedeisa)

    Hi @greybox ,

    Thanks for reaching out to the Duplicator support team.

    I have consulted a developer about your issue and the feedback I got that you need to consult your host about this.

    This might be a permission issue or privilege issue, and we didn’t change this area of code.

    I hope this helps.

    Thanks!

    Thread Starter Greybox

    (@greybox)

    Thank you for your reply! Is there any disadvantage for my backup if I switch from Mysqldump to PHP Code?in Duplicator SQL mode?

    Plugin Support mohammedeisa

    (@mohammedeisa)

    Hi?@greybox?,

    No, the PHP Code works well and it saves server memory space while creating the backup.

    @greybox – Is this issue got resolved for you and did you change any permission or privilege? Even I am facing the same issue. The last backup was two months back after that the “Host build got interrupted”. I tried all the possible ways, but it’s not helping anymore. I am using Duplicator lite.

    Thread Starter Greybox

    (@greybox)

    All I did I switched from Mysqldump to PHP Code?in Duplicator SQL mode.

    • This reply was modified 1 year, 5 months ago by Greybox.
    Plugin Support mohammedeisa

    (@mohammedeisa)

    @arunkumar143 Can you please open a new ticket for your issue? I will be happy to help you.

    Thanks!

    Plugin Support mohammedeisa

    (@mohammedeisa)

    @greybox Are you able to fix the issue after you switched to PHP Code?

    Thread Starter Greybox

    (@greybox)

    I changed the SQL Mode from Mysqldump to PHP Code and the backup started to work again.

    Plugin Support mohammedeisa

    (@mohammedeisa)

    @greybox

    I’m glad that you can backup your website.

    Please don’t hesitate to contact us if you have any questions. We are happy to help.

    Thanks!

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Host Build Interrupt and Mysqldump’ is closed to new replies.

Tags