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.
The following error can be found in the
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:
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 https://pleskautomation.uservoice.com/forums/216577-ppa-improvements/suggestions/7027123-add-support-for-mysql-5-6
Meanwhile, you can use the following workarounds:
- Create a database copy with console at the MySQL 5.6 service node
- Downgrade MySQL from 5.6 to 5.5 which supports deprecated syntax