Search Engine: Elastic

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

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF