MySQL Bugs: #10702: Problem for restoring with ANSI

Bug #10702	Problem for restoring with ANSI_QUOTE option
Submitted:	18 May 2005 8:05	Modified:	20 May 2005 17:27
Reporter:	Arnaud JARDIN	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	Administrator 1.0.20 & MySQL 4.1.11	OS:	Windows (Windows)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
Hello
I made many backup of my database with a old version of Administrator (I am not sure of the version) with the ANSI_QUOTE option and the restauration worked well. But with my backup make by Administrator 1.0.20, it's not possible to restore my database. With QueryBrowser I identify the line where is the problem, it's the line :
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO, ANSI_QUOTES' */;
And if you change order of the two option : /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ANSI_QUOTES' */; 
the restore works !!!
The problem is the blank between two options.

How to repeat:
Create a backup with ANSI_QUOTE option, drop the database and try to restore the backup.
If you change the line /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO, ANSI_QUOTES' */; in your backup file to 
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI_QUOTES,NO_AUTO_VALUE_ON_ZERO' */;
the resore works.

Suggested fix:
2 possibilities :
- modify Administrator for writing the good line in the backup file
- modify MySQL Server for it understand the line with the blank in the backup

Thank you for the bug report.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html