Re: Sharing databases between win and linux

2004-10-20 Thread SGreen
See below... Lau Sennels <[EMAIL PROTECTED]> wrote on 10/20/2004 12:49:19 PM: > Thanks for your reply. > > > >[client] > > >#password = your_password > > >port= 3306 > > >socket = /var/lib/mysql/mysql.sock > > > > Your client needs to connect to the windows machine, n

Re: Sharing databases between win and linux

2004-10-20 Thread Lau Sennels
> try adding to my.cnf: > > lower_case_table_names=1 You have a point it seems. Some tables, ones created with all lower-case names/keys are actually accessible. Thanks. Lau -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/

Re: Sharing databases between win and linux

2004-10-20 Thread Lau Sennels
Thanks for your reply. > >[client] > >#password = your_password > >port= 3306 > >socket = /var/lib/mysql/mysql.sock > > Your client needs to connect to the windows machine, not a local socket. The files are on the local machine. This is not a server/client setup, but tw

Re: Sharing databases between win and linux

2004-10-20 Thread Lau Sennels
Hi Michael. > try adding to my.cnf: > > lower_case_table_names=1 That doesn't do the trick unfortunately. Setting the above should affect both the way future tables are stored /and/ the way mysql looks up names of existing tables, right? Lau -- MySQL General Mailing List For list archives:

Re: Sharing databases between win and linux

2004-10-20 Thread gerald_clark
Lau Sennels wrote: Hello. I am trying to set up a MySQL database shared between SuSE 9.1 and a Win XP (both 4.0.18 from binary). The database resides on a FAT32 partiton accessible from both OS's. I am able to access the database transparently from Win XP by modifying my.cfg as described in th

Re: Sharing databases between win and linux

2004-10-20 Thread Mike McMahon
I also share databases Linux to XP. It could be an uppercase/lowercase issue, try adding to my.cnf: lower_case_table_names=1 Lau Sennels wrote: Hello. I am trying to set up a MySQL database shared between SuSE 9.1 and a Win XP (both 4.0.18 from binary). The database resides on a FAT32 partiton

Sharing databases between win and linux

2004-10-20 Thread Lau Sennels
Hello. I am trying to set up a MySQL database shared between SuSE 9.1 and a Win XP (both 4.0.18 from binary). The database resides on a FAT32 partiton accessible from both OS's. I am able to access the database transparently from Win XP by modifying my.cfg as described in the manual. The pro