Greetings,
I have a situation where I need to make the perl dbi module use a specific installed version of mysql. I have 3 servers which are currently pulling needed data over the wire from a central db. I've set up replication on each machine. I now want to query the needed info from the local replicated db. The problem is, that the replication required that I set up on older mysql 3x version. Mysql 4. was and is also installed and was the only installed version at the time of the original perl module install. I've been told that there is a way to be specific on what version/install of mysql that DBI uses. This may require a reinstall of the perl DBI module which would be fine. If I can accompish this, there's no need to have it work with mysql v4. You may be asking: "why did I install two versions and not remove the one not needed and reinstall the perl DBI again". Answer, production servers, couldn't bring down for any length of time. Once I can point to the older mysql version, I can remove the uneeded one. I've not had much luck finding information on how. Can someone here shed some like on this for me? Thank you very much. Tony D.
