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

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

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

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 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 two

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:

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, not a local socket.

Re: Win and Linux ?

2002-07-19 Thread Jimmy Fernandez
PROTECTED] Subject: Re: Win and Linux ? Ver 3 and Ver 4 compatibility ? Date: Thu, 18 Jul 2002 21:46:59 -0700 On Fri, Jul 19, 2002 at 03:24:34AM +, Jimmy Fernandez wrote: Hi ALL, I just wanted to clarify something: 1. Can I upgrade the MySQL version from one older version to a newer

Re: Win and Linux ?

2002-07-19 Thread Jeremy Zawodny
On Fri, Jul 19, 2002 at 05:40:21AM +, Jimmy Fernandez wrote: Hi jeremy Thanks for the quick response. Appreciate it. One more clarification though... How about bringing the database from Unix/liux to Windows. Still OK? Yes, all MyISAM tables are stored in a platfor-neurtal format. --

Win and Linux ? Ver 3 and Ver 4 compatibility ?

2002-07-18 Thread Jimmy Fernandez
Hi ALL, I just wanted to clarify something: 1. Can I upgrade the MySQL version from one older version to a newer version? For example if I have data base in ver 3.0 can I import over to newly downloaded ver 4.0 ? Will it still work ? Can I then delete off ver 3..0 and run the old database from

Re: Win and Linux ? Ver 3 and Ver 4 compatibility ?

2002-07-18 Thread Jeremy Zawodny
On Fri, Jul 19, 2002 at 03:24:34AM +, Jimmy Fernandez wrote: Hi ALL, I just wanted to clarify something: 1. Can I upgrade the MySQL version from one older version to a newer version? For example if I have data base in ver 3.0 can I import over to newly downloaded ver 4.0 ? Will it

Re: win to linux

2001-03-17 Thread Yusuf Incekara
Try to dump your database from Linux first. Then put them into Windows via ftp. Then import it into a Windows. I am using MySQL on windows platform. How can I port mt datas from MySQL server on windows to MySQl server on Linux? Thanks for all.

win to linux

2001-03-14 Thread rozakdemir
Hello, I am using MySQL on windows platform. How can I port mt datas from MySQL server on windows to MySQl server on Linux? Thanks for all.

Re: win to linux

2001-03-14 Thread Steve Ruby
rozakdemir wrote: Hello, I am using MySQL on windows platform. How can I port mt datas from MySQL server on windows to MySQl server on Linux? Thanks for all. You should search the sarchives and manual, this is a very FAQ... tables extension is like .MY* you can just copy them, if not

Re: win to linux

2001-03-14 Thread René Tegel
use ftp to copy your database/table files :) - Original Message - From: "rozakdemir" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 10:05 PM Subject: win to linux Hello, I am using MySQL on windows platform. How can I port mt datas from MySQL server

RE: win to linux

2001-03-14 Thread Brian Kaney
I don't think that works across platformsits better to use the mysqldump command. Brian -Original Message- From: René Tegel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 5:09 PM To: rozakdemir; [EMAIL PROTECTED] Subject: Re: win to linux use ftp to copy your database