Page 1 of 1

case sensitivity

PostPosted: 21. February 2008 22:07
by 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.