Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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... –  Jaime Pardos Nov 18 '10 at 17:05
add comment

2 Answers

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
1  
This seems a bit too cumbersome... I guess it could be automated, though. Seems like the only really safe solution. –  Jaime Pardos Nov 18 '10 at 17:05
1  
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
add comment

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... –  Jaime Pardos 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
add comment

Your Answer

 
discard

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.