Failure to create database archive

  • Resolved meatbrain

    (@meatbrain)


    8 years ago

    I am attempting to create a package to back up a development site, which will be used to move the site into the production directory. The package build fails almost immediately, with the error message:

    Host Build Interrupt
    This server cannot complete the build due to setup constraints.

    The log file indicates that there is a problem setting a MySQL option:

    RESPONSE: mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_QUOTE_SHOW_CREATE=1' at line 1 (1064)

    The complete log file has been uploaded to pastebin.com here.

    The error persists whether I set Duplicator to archive only the database or the entire site. The odd thing is that I successfully created a package of the production site, which is hosted on the same server.

    Please advise.

    Thanks…

    JGB

Viewing 3 replies - 1 through 3 (of 3 total)
  • Cory Lamle

    (@corylamleorg)

    8 years ago

    I would recommend switching to “PHP Code” mode see Settings > Package > SQL Script and seeing if that works.

    For whatever reason, mysqldump on that server is having an issue with the internal call to that SQL statement. The closest bug related issue I could find is here:
    https://bugs.mysql.com/bug.php?id=66765

    Which might be the mysql version that the server is running on…

    Hope that helps~

    Thread Starter meatbrain

    (@meatbrain)

    8 years ago

    Thanks, @corylamleorg. That did the trick. I’ve no idea how the setting got changed on the production site, but a full archive of the development site has just completed successfully.

    JGB

    Cory Lamle

    (@corylamleorg)

    8 years ago

    Excellent! Thanks for the update.

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

The topic ‘Failure to create database archive’ is closed to new replies.