MySQL on OS X Server
I do not run the Apple pre-cooked MySQL on OS X
Server. I always install the MySQL AB OS X Binaries and update when I want. I
don't want Apple OS X Server software updates updating the MySQL server
binaries. Bruce Dembecki at liveworld.com gave this tip on cleanly integrating
the MySQL binaries into OS X Server....
Our way of dealing with this is firstly to use
MySQL AB binaries. Secondly
we make sure the path includes /usr/local/mysql/bin/. Next we edit the
Startup script to make sure it is launching mysqld_safe from
/usr/local/mysql/bin and not from /usr/bin and finally, and this is the most
important one... As root you:
cd /usr/bin/
rm my*
ln -s /usr/local/mysql/bin/* .
This is not only replacing the Apple Binaries with the MySQL binaries, it is
protecting you as you upgrade MySQL versions... Each time you upgrade MySQL
versions the symlink to /usr/local/mysql/bin/ will always point to the
current version of MySQL you are using.
The only thing you need to watch is from time to time Apple will update
their MySQL installs (snuck into a System Update), which will overwrite your
symlinks with new Apple Binaries (which is why the real fix it so make sure
you have the right path settings and replace the startup scripts, even if
Apple overwrites your symlinks, you'll still be calling your binaries).
Still, you should get in the habit of checking the files in /usr/bin/my*
each time you install a System update in case Apple has updated versions.
Best Regards, Bruce
we make sure the path includes /usr/local/mysql/bin/. Next we edit the
Startup script to make sure it is launching mysqld_safe from
/usr/local/mysql/bin and not from /usr/bin and finally, and this is the most
important one... As root you:
cd /usr/bin/
rm my*
ln -s /usr/local/mysql/bin/* .
This is not only replacing the Apple Binaries with the MySQL binaries, it is
protecting you as you upgrade MySQL versions... Each time you upgrade MySQL
versions the symlink to /usr/local/mysql/bin/ will always point to the
current version of MySQL you are using.
The only thing you need to watch is from time to time Apple will update
their MySQL installs (snuck into a System Update), which will overwrite your
symlinks with new Apple Binaries (which is why the real fix it so make sure
you have the right path settings and replace the startup scripts, even if
Apple overwrites your symlinks, you'll still be calling your binaries).
Still, you should get in the habit of checking the files in /usr/bin/my*
each time you install a System update in case Apple has updated versions.
Best Regards, Bruce
Posted: Thursday - April 14, 2005 at 11:19 AM
Quick Links
Statistics
Total entries in this blog:
Total entries in this category:
Published On: Dec 29, 2008 02:27 PM
Total entries in this category:
Published On: Dec 29, 2008 02:27 PM