[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

FWD: Making Lin/Win share MySQL DataSource



Hallo list, 
Hopefully this thread that I sent to MySQL mailing-list can also be useful for some in this list.
This is about putting mysql datasource in a windows vfat directory in a dual-booting environment, so that Linux-Windows can share the datasource mutually.


------------------
On Fri, 2003-01-31 at 06:39, Stefan Hinz, iConnect (Berlin) wrote:

Hallo Stefan,
Thanks for your kind reply. But anyway, me too,I've solved the problem
as well...:) :)

So, here is what I did in term of commands:

1- $ mount /home/myfiles
   [this /home/myfiles is the D:\ partition in my dual-boot laptop. I'm
now mounting it simply still as a normal user -- NOT as root]
2- $ mkdir /home/myfiles/MySQL
3- $ su 
   [obvious..., accessing the root privilege] 
4- $ mv /var/lib/mysql/* /home/myfiles/MySQL/
5- $ vi /etc/my.cnf 
   [surely..., changing the datadir line to become and to look like:
datadir:/home/myfiles/MySQL/
6- $ safe_mysqld &

And all done! 

The only "mistake" that I did earlier was that I as a normal-user
copied/moved the data to the vfat partition. This way, when I started
mysqld as root, I had no privilege at all over the datasource.

But..., wait..., I am now still in Linux and haven't gone to or tried it
in Windows [kind of allergic..., you know :)]. But, assuming the core
datasource for Lin-Win is not different at all, I believe that in
Windows it wouldn't be a big deal at all.

Nice! So now no matter I'm in Windows or Linux, my data can always be
intact...:)

BTW..., if one tries this way too, please inform the success/failure.


JD

--------------------
> 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 <hinz iConnect de>
>   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" <filsuf softhome net>
> To: <mysql lists mysql com>
> 
> 
> > 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 <mysql-thread131280 lists mysql com>
> > To unsubscribe, e-mail
> <mysql-unsubscribe-list_hinz=iconnect de lists mysql com>
> > 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 <mysql-thread131313 lists mysql com>
> To unsubscribe, e-mail <mysql-unsubscribe-zhiren=bigvalley net lists mysql com>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 






[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]