Sharing server files on two different operating systems

Franz · 2009-08-09 14:00:34

I am in the process of setting up a computer that has both Windows and Ubuntu installed.

I already installed WampServer on Windows and put the web root directory on a drive shared by both systems. Does anybody know how to do or ever done the same thing with a database server?

FSX · 2009-08-09 16:02:55

You can connect to a database that's on a different system. Just replace "localhost" with the IP or hostname of the server. I'm not sure if this needs extra configuration though.

Franz · 2009-08-09 16:16:37

Not what I meant. I was talking about having the actual database files stored on a drive used by two different database servers.
I think, I figured it out, though. I was able to move the data directory to a shared drive. I just hope I will be able to access these files from the MySQL server installed on Ubuntu, too.

FSX · 2009-08-09 16:29:56

Hmm, I'm not sure if that's a good idea. Maybe you can use something like this: http://www.howtoforge.com/mysql_database_replication

Franz · 2009-08-09 17:37:29

As far as I can see, that does not make sense, since both database servers are on one machine.

The point is that I want to be able to develop in Windows as well as in Linux, but AFAIK I can't install a database server on Windows that runs on Linux, too. That's why I simply want both servers to share common database files.

hcgtv · 2009-08-09 17:47:10

The problem that exists is that Windows cannot reliably read/write to EXT3 partitions. So you'll have to create a FAT32 shareable partition and hope that Ubuntu's MySQL is ok with it.

Or you can do what I do, use phpMyAdmin to export and import my database between operating systems.

Franz · 2009-08-09 18:05:27

I didn't want to do the import/export thing all the time. I could obviously do that with the contents in the two systems simply being different, but I wanna do it right

Yeah, the partition is formatted to FAT32. We'll see if it works.

EDIT: I see another problem coming my way. Won't both servers have a database called "mysql" with all the settings? Can they just use one together, too?

Last edited by Franz (2009-08-09 18:06:12)

Forums

#1 2009-08-09 14:00:34

Sharing server files on two different operating systems

#2 2009-08-09 16:02:55

Re: Sharing server files on two different operating systems

#3 2009-08-09 16:16:37

Re: Sharing server files on two different operating systems

#4 2009-08-09 16:29:56

Re: Sharing server files on two different operating systems

#5 2009-08-09 17:37:29

Re: Sharing server files on two different operating systems

#6 2009-08-09 17:47:10

Re: Sharing server files on two different operating systems

#7 2009-08-09 18:05:27

Re: Sharing server files on two different operating systems

Board footer