Case Sensitivity Of Table Names Imported From .sql Script

[jcmonty]

Using SQLyog 5.15 on Windows XP Pro

When I import a .sql script file to a new database, the table names are all created as lowercase. The table names in the script are mixed case. Is there a setting somewhere to maintain the case of the table names to match the way the are in the imported .sql file?

Thanks.

[peterlaursen]

The setting is in MySQL configuration itself. The configuration parameter is named “lower_case_table_names”

Insert this line in the [mysqld] section your my.ini file

lower_case_table_names=2

..and you will get the behaviour you want! You need to restart MySQL for the change to take effect.

lower_case_table_names=0 means case-insensitive, store as lower-case (default on Windows)

lower_case_table_names=1 means case-sensitive, store as mixed-case (default on most *nix – except Mac OS-X)

lower_case_table_names=2 means case-insensitive, store as mixed-case

However MySQL has confirmed a bug that I reported here:

http://bugs.mysql.com/bug.php?id=20356

(but it only affects the 'show create table' statement, not .sql import)

[Author]

Posts