case sensitivity
Posted: 21. February 2008 22:07
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
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