Bug #68683 Fail do dump my database, with mysqldum, on MySQL Workbench CE 5.2.47

• Submitted: 15 Mar 2013 11:33
• Modified: 11 Jun 2013 21:46
• Reporter: evan boissonnot
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S1 (Critical)
• Version: 5.2.47
• OS: Windows (win server 2008 r2)
• CPU Architecture: Any
• Tags: MySQL Workbench CE 5.2.47, mysqldump

[15 Mar 2013 11:33] evan boissonnot

Description:
Hi everyone

I have a produciton database on mysql, with windows installer.

It had installed MySQL Workbench CE 5.2.47 and mysql.

Now ,I want to launch mysqldump to get a backup of my production database.
mysqldump is in MySQL Workbench CE 5.2.47 directory right.

So i launch this dos command :

/mysqldump -udu -pdu mydatabase_prod > d:/test.sql

Version of mysql : mysqldump --version => 5.5.16.

And ... starting .. FAILED
I've got this uggly error : 

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)

How to repeat:
Now ,I want to launch mysqldump to get a backup of my production database.
mysqldump is in MySQL Workbench CE 5.2.47 directory right.

So i launch this dos command :

/mysqldump -udu -pdu mydatabase_prod > d:/test.sql

Version of mysql : mysqldump --version => 5.5.16.

Suggested fix:
Can I get a earlier mysqldump.exe ?

Why mysqldump is older than mysql bench version ?

[29 Mar 2013 17:57] MySQL Verification Team

Hello evan boissonnot,

Thank you for the report.
Verified as described.

Thanks,
Umesh

[11 Jun 2013 21:46] Philip Olson

Fixed as of the upcoming MySQL Workbench 6.0.2 release, and here's the changelog entry:

An older version of the MySQL Client was bundled with MySQL Workbench, and it
has since been updated. This caused problems while executing "mysqldump".

Thank you for the bug report.