MySQL Bugs: #6594: Administrator backup creates scripts with "

Bug #6594	Administrator backup creates scripts with " - which don't work
Submitted:	12 Nov 2004 14:13	Modified:	10 Oct 2005 8:18
Reporter:	Patrick Questembert	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.0.14	OS:	Windows (Windows XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
Scheduled or one-time backup of a table generate a script of the form:

USE "mydatabase";
CREATE TABLE "mytable" ("time" datetime);

However, MySQL doesn't accept " around either the table name or the column name. I had to edit the script to:

USE "mydatabase";
CREATE TABLE `mytable` (`time` datetime);

(for some reason MySQL doesn't mind the " when around the database name)

I am using MySQL 4.1 Gamma.

Somehow I would be surprised if everyone is having that problem, perhaps there is a configuration setting for MySQL to tell it to accept " ?

How to repeat:
Just create a new backup project, select any table from your database, as "Single Transaction", then "Execute Backup Now".

Resulting .sql file should have the " in the Create Table statement, which fail under MySQL.

For example, 
 CREATE TABLE "mytable" ("time" datetime);
will fail.

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info:

This has been very likely already fixed.