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:
Category:MySQL Server: Backup Severity:S1 (Critical)
Version:5.6 OS:Windows
Assigned to: CPU Architecture:Any
Tags: dump backup

[28 Jun 2013 16:55] Ilya Zatuchny
I have been unable to backup to a file, or export to another database for about a month now. I have upgraded but still...


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
[28 Jun 2013 17:08] Todd Farmer
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.
[28 Jun 2013 17:37] Ilya Zatuchny
I have downloaded the latest versions of everything. What specifically do I need to download for the sql dump?