FW: Moving innodb from Linux to Windows

2004-11-15 Thread Boyd E. Hemphill
PROTECTED] Subject: Re: Moving innodb from Linux to Windows Boyd, please send this correspondence to [EMAIL PROTECTED] Right, lower_case_table_names=2 does not work with InnoDB. I guess the way for you is then to use lower_case_table_names=1 on both Unix and Windows. The drawback is that table

Re: Moving innodb from Linux to Windows

2004-11-12 Thread Hassan Schroeder
Heikki Tuuri wrote: on Windows, InnoDB puts all database names and table names to lower case, because on Windows MySQL is case-insensitive. But Java running on Windows is not, which makes it painful to move apps back and forth. We may fix this in the future, so that on Windows InnoDB will also fin

Re: Moving innodb from Linux to Windows

2004-11-12 Thread Gleb Paharenko
Hello. Windows filesystem is not case sensitive. See: http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html >I am attempting to move a set of db's from Linux (Mysql 4.0.20) to Windows >(4.1.6). I have everything running, and I can query tables that are all >lower case. > > >

Re: Moving innodb from Linux to Windows

2004-11-12 Thread Heikki Tuuri
Boyd, --=_NextPart_000_0038_01C4C7F5.22045240 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit All: I am attempting to move a set of db's from Linux (Mysql 4.0.20) to Windows (4.1.6). I have everything running, and I can query tables that are all lower case. Howev

Moving innodb from Linux to Windows

2004-11-11 Thread Boyd E. Hemphill
All: I am attempting to move a set of db's from Linux (Mysql 4.0.20) to Windows (4.1.6). I have everything running, and I can query tables that are all lower case. However I cannot issue a query on a table that contains uppercase letters. This is the my.ini file: [client] port=3306