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

Created:

2016-11-16 13:10:55 UTC

Modified:

2017-04-24 11:04:32 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows

Symptoms

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'
Error:
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)

Cause

The issue caused by MySQL bug #67507

Resolution

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

Have more questions? Submit a request
Please sign in to leave a comment.