Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a dual boot (windows 7/linux) computer. I have an NTFS partition to exchange data between them. I want to install a MySQL Server. However, I don't have another computer and, as I would like to use the data from windows and linux, I want to install MySQL and store the data in the shared disk.

However, the idea makes me cringe. Should this be possible at all? How careful must I be with updates? I.e. if the linux updater installs a sqcurity patch, would it be safe to not install it in windows?

share|improve this question
I'm thinking of going with sqlite instead... – raven Nov 18 '10 at 17:05
up vote 3 down vote accepted

You could do a dump export when you shut down after changes are made, and then import when starting the other OS. In this case, however, you may consider not having MySQL start automatically.

share|improve this answer
This seems a bit too cumbersome... I guess it could be automated, though. Seems like the only really safe solution. – raven Nov 18 '10 at 17:05
It should be fairly easily automated... I think that it'll be less cumbersome than attempting to manage MySQL versions between platforms. – gWaldo Nov 18 '10 at 20:11

The only problem i forsee, is that..

You will need to maintain exactly the same version on both linux and windows to share the data..

Updates change functionality, update engines, change data structures.. You really need to maintain this equally, which i think would be a little too much stress..

To avoid the headache, just install it twice :D

share|improve this answer
+1 for caution. – gWaldo Nov 18 '10 at 13:17
I don't mind just installing it once, same version in both systems. I don't care for security issues because it will be in an isolated network, and there won't be anything critical there. But I fear linux automated security updates can drive me crazy. I just wonder if security updates use to be backwards-compatible... – raven Nov 18 '10 at 14:46
I feel that they are.. but no one can be sure with anything anymore.. Oracle has begun a slow death of mysql.. :( – Arenstar Nov 18 '10 at 14:49

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.