ansaurus

Question

Maintain case sensitivity when importing db into windows

Answer 1

A:

There is a setting for mysql to allow case differentiation in windows. You need to edit the my.cnf file and alter the setting:

lower_case_table_names=2

Then restart mysql.

Otherwise, this may be a case of phpmyadmin changing case in the way it passes queries to the server rather than a linux-to-windows problem. Have you tried importing the sql dump using another mysql manager such as SQLyog? (Tools -> Restore from SQL Dump...)

JYelton 2010-05-19 23:21:29

Thanks for the help, but even with setting that command (which wasn't in the ini, had to add it after [mysqld] ), restarting mysql and then using the command line to import the data it still didn't keep the table name case.

2010-05-20 04:09:00

It may be that the variable needs to be 0 instead of 2, as Atonewell suggests, however the reference manual says this: " *You should* not *set this variable to 0 if you are running MySQL on a system that has case-insensitive file names (such as Windows or Mac OS X). If you force this variable to 0 with --lower-case-table-names=0 on a case-insensitive file system and access MyISAM tablenames using different lettercases, index corruption may result.* "

JYelton 2010-05-20 14:39:45

Answer 2

A:

It is probably worth reading the following page from the MySQL Reference Manual: http://dev.mysql.com/doc/refman/5.5/en/identifier-case-sensitivity.html

Based on that, I think you need to set to 0, not 2, which will ensure that the schema is stored using the same case as defined in your DDL.

lower_case_table_names=0

Atonewell 2010-05-20 10:28:11

ansaurus

tags:

views:

answers:

Maintain case sensitivity when importing db into windows

related questions