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

Refers to:

  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows

Created:

2016-11-16 13:10:55 UTC

Modified:

2016-12-21 20:07:59 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'

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.