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

  • Applies to:
  • Plesk Automation 11.5

Symptoms

  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)
    

Cause

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:

http://dev.mysql.com/doc/refman/5.5/en/set-statement.html

and then dropped in MySQL 5.6:

http://dev.mysql.com/doc/refman/5.6/en/set-statement.html

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

Resolution

A feature request Add support for MySQL 5.6 was created. You can vote for the feature at https://pleskautomation.uservoice.com/forums/216577-ppa-improvements/suggestions/7027123-add-support-for-mysql-5-6

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