Article ID: 123139, created on Oct 13, 2014, last review on Oct 13, 2014

  • Applies to:
  • Plesk 12.0 for Windows


I am using MySQL server version 5.6 on the source server. Migration fails with

Error: domain "domain.tld"
Cannot dump database content 'wordpress_3' of type 'mysql'
Cannot backup content of database 'wordpress_3'. The mysqldump utility has returned '2'.
STDERR: 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 issue caused by MySQL bug #67507


Replace mysqldump.exe in %ProgramFiles(x86)%\Parallels\PleskMigrationAgent\Tools with %plesk_dir%\MySQL\bin\mysqldump.exe

Search Words

use mysqldump from MySQL 5.5 to dump data from a MySQL 5.6 server

mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1'


MySQL 5.6

mysql 1064

ed7be2b984f9c27de1d2dc349dc19c6d 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 a766cea0c28e23e978fa78ef81918ab8

Email subscription for changes to this article
Save as PDF