my.cnf search order revisited

I've read the other threads here about the search order for my.cnf, but I have encountered a problem that doesn't seem to be addressed in any of the discussions that I could find:

I'm running mysql-5.0.46 under a linux system that has been configured using yum to manage its rpm packages. Various other system components are dependent on this instance of mysql, and yum keeps them all in sync.

However, for various reasons, I need to bring up a second, completely separate version of mysql on this system in a way that doesn't depend on the package manager. Therefore, I decided to build mysql from source and to change all of the paths so that every directory that is uses is under a private file system that I created: /usr/private. In order to perform the build, I did the configuration as follows:

  dir=/usr/private

  ./configure                      \

    --prefix=${dir}                \
    --exec-prefix=${dir}           \
    --program-suffix="_${suffix}"  \
    --bindir=${dir}/bin            \
    --sbindir=${dir}/sbin          \
    --libexecdir=${dir}/libexec    \
    --datadir=${dir}/share         \
    --sysconfdir=${dir}/etc        \
    --sharedstatedir=${dir}/var    \
    --localstatedir=${dir}/var     \
    --libdir=${dir}/lib            \
    --includedir=${dir}/include    \
    --oldincludedir=${dir}/include \
    --infodir=${dir}/info          \

I then did a "make" followed by a "make install", and everything properly got installed under the completely separate /usr/private directory.

However, there is one fly in the ointment. This new version still wants to look in /etc/my.cnf for its configuration, but since the standard yum-based version is also using /etc/my.cnf, I can't keep the two versions separated in the way I intend.

In reading the other discussions here, it seems that a conscious, deliberate decision was made to always have mysql and its utilities look in /etc/my.cnf first, before looking in any of the other locations. This feature prevents me from having these two, completely separate versions running on a single machine.

Is it true that my only option is to patch the source code to my private mysql version, so that it looks somewhere other than /etc/my.cnf first? Or is there some other way for me to accomplish what I want to do?

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

Thanks in advance.

-- 
 Lloyd Zusman
 ljz@asfast.com
 God bless you.



-- 
MySQL Internals Mailing List
For list archives: 
http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=lists@pantek.com