JD, my answer may seem ridiculous, too, but with the following setup you should be able to use MySQL databases and tables both under Linux and Windows on the same machine.
About the only thing you need is access to the MySQL data directory from both Linux and Windows. Regardless of the operating system, mysqladmin variables will show you where DATADIR is. Of course (though it may sound even more ridiculous), you have to have MySQL installed both under Linux and under Windows. Whether you've started mysqld or not, you can issue mysqld --print-defaults to find out the location of DATADIR. However, this will not show you DATADIR if it's not in my.cnf / my.ini. Now, let's say DATADIR is in /var/lib/mysql/ under Linux, and under Windows this is c:\mysql\data\ (I'm not informed how paths will look like when you share them between OS's). In this case, you would edit /etc/my.cnf under Linux and fill in: [mysqld] datadir=/var/lib/mysql And, under Windows, this would be the following in c:\winnt\my.ini (assuming you boot Win NT/2000/XP): [mysqld] datadir=c:\mysql\data Now, I suggest you start the MySQL server (both OS's) as follows: shell> mysqld --standalone --console This will output a lot of start information, so you can find out what's going wrong at startup. HTH, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "JD" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 31, 2003 7:11 AM Subject: Making Lin/Win share DataSource > Hallo list, > this might sound ridiculous. But, because my computer is dual booting > Linux/Windows, I'm looking for ways to put the datasource in windows D:\ > or vfat, so that the data can be shared mutually by the two OS. But > until now I still cannot do that. > > I have tried to: > - change the owner to mysql; > - change the /etc/my.cnf > > Well, does somebody out there do something like this already? > > Thank you. > > > JD > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
