Bug #68037 mysqldump output fails to restore, due to syntax error
Submitted: 5 Jan 2013 20:37 Modified: 5 Jan 2013 20:46
Reporter: Giuseppe Maxia Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S1 (Critical)
Version:5.6.9 OS:Any
Assigned to: CPU Architecture:Any

[5 Jan 2013 20:37] Giuseppe Maxia 
Description:
in the release of 5.6.9, mysqldump changes its output.
It now includes the following:

--
--GTID state at the beginning of the backup 
--

The comment before GTID does not include a space, and when restoring the file, mysql complains of a syntax error.

How to repeat:
install MySQL 5.6.9

mysqldump somedatabase sometable

Suggested fix:
add a space after the comment
[5 Jan 2013 20:43] MySQL Verification Team 
This is fixed in 5.6.10 already.. Please wait for that..
Duplicate of: 
BUG 15922502 - UNNECESSARY ERROR OCCURS WHEN RELOADING THE DUMP FROM SERVER WITH GTID ENABLED
[5 Jan 2013 20:46] Giuseppe Maxia 
As of today, the release notes for 5.6.10 don't mention anything about this bug. That's why I reported it