Two versions of MySQL on the same server

Question

meandrik Author

Level 1

0 points

Two versions of MySQL on the same server

Hello!

In the Console.app I see following errors:

(org.mysql.mysqld48150): Exited with exit code: 1

(org.mysql.mysqld): Throttling respawn: Will start in 10 seconds

I think the problem appears because a while ago I installed (because of some reason!!!) another version of MySQL. And now, I have two versionos of MySQL installed on the server. Mac trying to launch the first one - and can't do this. But another MySQL version works fine and we already use it.

Screenshot from Server Admin.app:

Screenshot from Settings:

The problem is that I can't simply remove the second (not native) version of MySQL because we already have a number of data bases there. Is there a way to gently point Mac to another MySQL version?

Thank you for your answers!!!!

Mac mini, OS X Server, Version 10.6.8

Posted on Sep 27, 2013 3:38 AM

Reply

Answer 1

Best reply

MrHoffman

Community+ 2024

Level 10

116,217 points

Sep 27, 2013 4:36 AM in response to meandrik

You can't remove the integrated MySQL database in OS X Server 10.6, and the add-on database is encountering a conflict on a system-wide construct. You can migrate the contents of the add-on database into the system database, or can shut down the parts of the add-on that are conflicting with the system database — likely the sockets. You can also shut down the system-defined MySQL, if there are no other OS X Server services using it. Alternatively, consider an upgrade to OS X Server 10.7 or later, which replaces MySQL with PostgreSQL, and thus removes the immediate conflict.

In short: no, there isn't a way to "gently" point the system-installed references somewhere else. You might get lucky with shutting it down and allowing tools that use the sockets and related to silently reference the new database, but there'll still be some references around to the system-defined locations. These cases tend to get tangled.

Reply

Answer 2

meandrik Author

Level 1

0 points

Sep 27, 2013 4:49 AM in response to MrHoffman

I'm sorry for aside (and dummy) question - but how to upgrade to Lion (or Mountain Lion) server? I opened App Store app and the only thing I can find there is "OSX Mountain Lion", but it's not server. But I need a server, with all the tools like Server Admin.app, and data base ... etc. etc.

Reply