case sensitivity

[guntersammet]

Hi all:
Just FYI in case you have problems with case sensitivity in table names when migrating from Windows to *nix:

If you start MYSQL with the "--lower-case-table-names=2" option, table names will be created case sensitive in Windows. I solved it by changing the line in mysql_start.bat to

mysql\bin\mysqld --defaults-file=mysql\bin\my.cnf --standalone --console --lower-case-table-names=2

Not sure where you would change it in the control center. Hopefully they use the individual batch files to start up.
HTH

Gunter