UGN Security Forums Thread Like Summary - Shared MySQL database

hi, i had a question for anyone familiar with mysql. i run a dual-boot machine with windows and linux. on that machine i run a website which uses perl and mysql. i'd like to know if it's possible to share the mysql database between both the windows and linux setup depending on what i'm booted into. for example, windows: f:\MySQL Datafiles\ibdata1 i want to use that in linux. i have f: mounted to /files in linux. apache runs fine with the perl scripts and all, i just need to find a way to share the database. all the solutions i've seen so far require dumping the database from windows (the database was originally created in windows) and then using that to set up mysql under linux. the problem with this is that it wont' update the windows mysql datafiles. and so, if i wanted to switch back to windows with an up-to-date databse, i'd have to dump the linux mysql one, and bring that back over. i understand that there are more files than just ibdata1 that might be required. really, i would just like to know if it's possible to share the same database files. note: also, i'm pretty sure all the database and table names are lowercase and i don't THINK i've used any floating point numbers in the database...although, i dont' know for sure. but does anyone know if the floating-poitn number format in windows and linux differ? never had to worry about that before. and i do believe the database type is innodb.//

I could definately see data collisions with that setup; why not just set mysql to allow each pc to connect to the username to utilize the database through the server itself vs trying to run two servers with one set of data?

no, I'm saying, have the MySQL server run on one machine, and set the username to allow connections from the other machine; then you set the connection data on the one machine to connect to the server machien...

I'm trying to figure out why you want access to the mysql files in the first place; are you trying to use them to connecft with a seperate install and use that data or what? If you want both machines to use the same mysql data, then set machine A to be a server, and set machine B to use machine A's mysql server (using machineA's ip address on your network as the host, and the user account on machineA's user/password)

For example, I have 3 machines here. MySQL data is used on either Machine B or machineC (2 mysql instances because I do testing on multiple versions).
MachineA hosts final builds, so I use MachineB and MachineC to connect to it to use it as the server.
MachineB has my alpha work, just drawn out data, I do testing mainly just on that server to connect from php to its own sql server.

I also use SQLYog to connect from Laptop to Machine A and machineB to do some quick update work on them both.

It's all quite simple to do, just set the sql username to allow connections from ip's other than "localhost".

Oh, so you're dual booting, check...

Humm, it may be kinda difficult; I know that when you install MySQL via linux from source you can specify your path, so you could mount your fat drive and install MySQL to there; I however am not sure if the W32 version allows you to specify locations of mysql data... Even if it would, you'd want to ensure you're running the EXACT same versions of the W32 and Linux versions of MySQL...

If the Windows install allows you to specify the datafile location it shouldn't be too difficult as I'm sure it stores the data the exact same way... The only problem would be if MySQL stores EVERYTHING in the data directory (program files included)...

You'd ultimately have to give it a go and try to customize it... I don't dual boot here since I had the spare hw for a seperate linux box.

Probably issues with the windows data, I'm not sure how it stores data or if it stores it properly (windows is so wonky lol).

You could try running your linux in a vmware session (or vice versa)

I would strongly advise against such a set up. At best you could install a version per OS and be sure to make one the primary and back up the other from that one.

Linux and windows use very different file systems and different hooks. The mysql version for windows and the version for Linux though they will act the same for the most part will be configured and have very different files that make them work.

The other alternative is to go out and buy a Pentium I or pentium II and install an OS it can handle (psst go linux or BSD) LAMP (Linux Apache MySQL Perl,Python,PHP).

Then your scripts on your local box can access a single data set on the cheapy MySQL box.