MySQL Bugs: #69614: Unable to do backup

Bug #69614	Unable to do backup
Submitted:	28 Jun 2013 16:55	Modified:	28 Jun 2013 17:37
Reporter:	Ilya Zatuchny	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Server: Backup	Severity:	S1 (Critical)
Version:	5.6	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	dump backup

Description:
I have been unable to backup to a file, or export to another database for about a month now. I have upgraded but still...

WARNING

mysqldump.exe is version 5.5.16, but the MySQL Server to be dumped has version 5.6.12.

Because the version of mysqldump is older than the server, some features may not be backed up properly.

It is recommended you upgrade your local MySQL client programs, including mysqldump to a version equal to or newer than that of the target server.

The path to the dump tool must then be set in Preferences -> Administrator -> Path to mysqldump Tool:

11:49:05 Dumping sales (all tables)

Running: mysqldump.exe --defaults-extra-file="c:\users\ilya\appdata\local\temp\tmpyxprvi.cnf"  --user=root --max_allowed_packet=1G --host=localhost --port=3306 --default-character-set=utf8 --single-transaction=TRUE "sales"

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)

Operation failed with exitcode 2

11:49:05 Export of C:\Users\ilya\Documents\dumps\Dump20130628.sql has finished with 1 errors

How to repeat:
Just go to export and try to run a dump

Thank you for taking the time to report a problem.  Unfortunately you are not using a current version of the product you reported a problem with -- the problem might already be fixed. Please download a new version from http://www.mysql.com/downloads/

Specifically, the mysqldump.exe client program for 5.5 issues SET OPTION statements, a syntax which was deprecated earlier and for which support was removed in MySQL 5.6.  Please use mysqldump.exe from the MySQL 5.6 distribution to avoid this problem.

I have downloaded the latest versions of everything. What specifically do I need to download for the sql dump?