Bug #6685 mysqldump creates dump file with " and ` quotes
Submitted: 17 Nov 2004 19:22 Modified: 24 Nov 2004 12:06
Reporter: Victoria Reznichenko Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:4.0 OS:Linux (linux)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[17 Nov 2004 19:22] Victoria Reznichenko 
Description:
mysqldump with --compatible=ansi option that connects to the 4.0 MySQL server use both type of quotes: double quotes and backticks.

Result of the mysqldump looks like:

DROP TABLE IF EXISTS "a";
CREATE TABLE `a` (
  `a` int(11) default NULL,
  `b` int(11) default NULL
) TYPE=MyISAM;

How to repeat:
1. Start 4.0 MySQL server with --ansi option
2. Run mysqldump with --compatible=ansi option
[17 Nov 2004 19:24] MySQL Verification Team 
Forgot to say: mysqldump is from 4.1
[24 Nov 2004 12:06] Ramil Kalimullin 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

--compatible option "Requires MySQL server version 4.1.0 or higher. This option is ignored with earlier server versions"