Sharing MySQL in a partition with two distributions.
Linux - ServerThis forum is for the discussion of Linux Software used in a server related context.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
Sharing MySQL in a partition with two distributions.
Not too difficult and I got a partial solution to the problem already, but I was looking for a better one.
I got Fedora 12 and Ubuntu Jaunty installed in this computer (as well as Windows Vista, but last time it was used was several weeks ago). I got a partition of MySQL (mounted, in both OS, on /media/MySQL). The thing is, that when I'm on Fedora, I have to change the owner in order to have MySQL working, and when I get back to Ubuntu, I have to change the permissions yet again.
For the moment, I just have a script that runs when the system starts (... ok, not a script but a command ).
chown -R mysql:mysql /media/MySQL
So, it works... but I don't think it's ok to have it changing permissions every time the system starts. Is there a more natural way of sharing permissions in two different installations? I got different software in each OS that uses the same databases.
And if you ask me "why have to distributions?", let's just say I have to =) At least for the following month.
'Sounds like you might be better off booting to one OS (or the other), then running the other one as a VM (e.g. in VMWare or VBox).
PS:
I assume you've already tried setting ownership to the *same* user and group ... and making sure they have the *same* numeric uid and gid on both OS's...
I think the problem is in the uid and gid of the mysql user/group on the different distros. If so, you need to get those the same but that might be a tricky exercise. If it's only for a month, I would live with it.
Quote:
but I don't think it's ok to have it changing permissions every time the system starts
Why not? Exceptional circumstances require exceptional solutions Just my
Thanks for the help. That last commands are what I needed =)
I had Fedora running in VirtualBox before the installation. The idea is to make a slow transition from Ubuntu to Fedora (and by slow I mean 2-3 months), because there's a lot of software running already in Ubuntu and because I want to see how stable Fedora is (I'm running the Alpha of Fedora 12... meaning it won't be much stable, although so far it's been good. When 12 comes as stable, I will most likely make the change).
I second chrism01's opinion regarding Fedora's short life cycle. At this moment I don't second his opinion on Centos 5.3 (there are some stories going around about late updates). chrism01 might be able to indicate if that's still the case.
Ubuntu server has 5 years support on the LTS versions (8.04 currently).
I second chrism01's opinion regarding Fedora's short life cycle. At this moment I don't second his opinion on Centos 5.3 (there are some stories going around about late updates). chrism01 might be able to indicate if that's still the case.
Ubuntu server has 5 years support on the LTS versions (8.04 currently).
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.