Bug #22525 mysqldump exporting broken sql
Submitted: 20 Sep 2006 16:01 Modified: 20 Oct 2006 16:11
Reporter: Daniel Platt Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.24a OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any
Tags: export, mysqldump

[20 Sep 2006 16:01] Daniel Platt
Description:
Happens when exporting a database as SQL.

The correct table name is `clientContacts`

but when trying to create the table, the name changes to
`clientcontacts`. Create seems to be the only place
this is happening in the generated SQL.

Extract from generated SQL

-- 
-- Table structure for table `clientContacts`
-- 

CREATE TABLE `clientcontacts` (
`clientContactId` int(11) NOT NULL auto_increment,
`clientId` int(11) NOT NULL default '0',

-- 
-- Dumping data for table `clientContacts`
-- 

INSERT INTO `clientContacts` (`clientContactId`,
`clientId`, `contactTitle`, `contactFirstName`,
`contactSurname`, `contactSex`, `contactPosition`, 

How to repeat:
Try to dump a database with a uppercase character in it.

mysqldump --user=root db > db.sql
[20 Sep 2006 16:11] Valeriy Kravchuk
Thank you for a problem report. Please, send the results of:

show global varaibles like '%lower%';

from your server. Read http://dev.mysql.com/doc/refman/5.0/en/name-case-sensitivity.html for the details.
[20 Oct 2006 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".