MySQL Bugs: #13047: mysqldump --skip-quote-names does not work

Bug #13047	mysqldump --skip-quote-names does not work
Submitted:	7 Sep 2005 19:21	Modified:	9 Sep 2005 18:00
Reporter:	Patrick Lum	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	4.1.14-standard	OS:	Linux (RH Enterprise 3)
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
I am trying the following command to create a dump file that is compatible with MySQL 3.23:

#  mysqldump -u root -p --all-databases --add-drop-table --allow-keywords --extended-insert --flush-logs --skip-quote-names --compatible='mysql323' > mysql3_dump

However, the quotes are always around the table and database names

How to repeat:
execute above command and just do a "head -100 mysql3_dump" to see the first 100 lines. It will contain quotes around the database names e.g. USE `mysql`.

Suggested fix:
none

the backtick quotes are added if either the --allow-keywords or --quote-names option is active,
you have used the --skip-quote-names but due to the use of --allow-keywords option quotes
are still added

this is not really clear from the documentation so i changed this to a documentation issue ...

No, that didn't work. I am trying:

$ mysqldump -u root -p --all-databases --add-drop-table  --skip-quote-names --compatible='mysql323' >  mysql3_dump

$ head -100 mysql3_dump | grep "CREATE TABLE" 
CREATE TABLE `columns_priv` (
CREATE TABLE `db` (
CREATE TABLE `func` (

Option --compatible=... implicitely sets --quote-names on. It can be forced to
not quote names by adding --skip-quote-names *after* --compatible=... option.

However, MySQL 3.23 is capable of reading output with quoted names, also
mysqldump in release 3.23 is capable of producing quoted output. (Tested with 3.23.59)
Are you having problems with using output with quoted names?

Thanks, that worked!

Version 3.23.58 does not understand quoted names.

Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).

Additional info:

I'll add a note that --skip-quote-names has to be given
after --compatible or it will have no effect.