Article ID: 128721, created on Apr 21, 2016, last review on Jun 27, 2016

  • Applies to:
  • Plesk Automation 11.5


  1. On attempt to copy a database running on the service node with MySQL 5.6 installed it fails with the error:

    Error: Unable to copy the database. 
  2. The following error can be found in the /usr/local/psa/admin/logs/panel.log:

    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 SET syntax depends on current MySQL client tool version installed on the management node. The syntax SET OPTION ... was deprecated in MySQL 5.5:

and then dropped in MySQL 5.6:

The mysqldump utility on the management node has older version and uses deprecated syntax.


A feature request Add support for MySQL 5.6 was created. You can vote for the feature at

Meanwhile, you can use the following workarounds:

  1. Create a database copy with console at the MySQL 5.6 service node
  2. Downgrade MySQL from 5.6 to 5.5 which supports deprecated syntax

Search Words

duplicate database

supported third-party components

usermng: /usr/bin/crontab execution failed:

copy database in mysql 5.6

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF