| Bug #6250 | mysqldump doesn't quote database names | ||
|---|---|---|---|
| Submitted: | 25 Oct 2004 18:49 | Modified: | 25 Oct 2004 21:11 |
| Reporter: | Harm van Tilborg | Email Updates: | |
| Status: | Won't fix | Impact on me: | |
| Category: | MySQL Server: mysqldump Command-line Client | Severity: | S3 (Non-critical) |
| Version: | 3.23.58 | OS: | Linux (Debian GNU/Linux Woody 3.0) |
| Assigned to: | CPU Architecture: | Any | |
[25 Oct 2004 21:11]
MySQL Verification Team
Hi, Thank you for the report. mysqldump works fine in 4.0. So, just use recent version of mysqldump.
[26 Oct 2004 11:36]
Harm van Tilborg
Hi Victoria, Is that possible? To use a different version client tools then the server version. I did however solved it by myself to just change the rule which writes the 'CREATE DATABASE' string... Thanks for the reaction.
Description: The mysqldump programm has a little 'supposed-to-have' feature missing. When you've turned the directive 'quote-names' on, the dump programm suppostes to be quoting database, table and column names. For the last two that works, however, database names aren't being quoted. How to repeat: By running mysqldump again. Suggested fix: In client/mysqldump.c on line 1335 (2 lines before it was leet ;]), a small if statement for what to do if 'quote-names' has been turned on. And if it has been turned on, which quote character needs to be concatated, the standard (`) or the ANSI-quote (").