Re: Porting Tables Between Windows and Linux Version of MySQL

2004-12-13 Thread Gleb Paharenko
Hello. Before doing anything you should read: http://dev.mysql.com/doc/mysql/en/Windows_vs_Unix.html http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html lan Scott - Yahoo Acct wrote: > We have 2 distinct groups of developers - Windows vs. Linux. Our production > server is g

Re: Porting Tables Between Windows and Linux Version of MySQL

2004-12-10 Thread Ken Johanson
The only gotcha I'm aware of is that you must set the *nix server to use case-insensitive table names, since on windows the SQL table references didnt need to match case. I'll leave you to you own devices to find that documentation (I just dont have it handy, sorry) "select 8 from testtable" ||

Porting Tables Between Windows and Linux Version of MySQL

2004-12-10 Thread Alan Scott - Yahoo Acct
We have 2 distinct groups of developers - Windows vs. Linux. Our production server is going to run on Solaris. The issue is that all developers run there own instance of MySQL server Linux or Windows based and the same version 4.1.7. Also, each developer has the database for their particular pr