How can I make mysqldump keep case-sensitive table names?

Question

I am trying to migrate a database from windows to a linux host.

Thanks!

Ashley

Answer 1

You will not find table names in linux mysql, because its default value is case sensitive. And for windows - not case sensitive.

I cannot guess if ignoring case sensitivity works for you. But you can do it by adding a line to my.conf. i.e. make mysql on linux case insensitive.

mysqlserver:~# vi /etc/mysql/my.cnf
...
[mysqld]
lower_case_table_names = 1

Answer 2

Check out the following links and see if this helps:

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

http://dev.mysql.com/doc/refman/5.1/en/identifier-case-sensitivity.html

Answer 3

Error 33898 suggests setting lower_case_table_names=2.