Thanks, makes perfect sense but due to my lack of DB knowledge, I would
have never thought of it. :( I downloaded
the binary package, removed all traces of mysql packages and brought up
the binary version of 4.0 in /usr/local/mysql
using the script in support-files. I then yum installed php-mysql which
brought in all the dependencies. I can connect
with the "mysql" client in /usr/bin which is the 4.1 versions. However,
JFFNMS still says that php-mysql is not loaded
and cannot talk to the DB. How would you go about testing the
php-mysql piece?
Thanks!!!
Chris
Troy Engel wrote:
> Chris Hammond wrote:
>
>> Greetings all!
>>
>> I have built a new server with MySQL and have noticed that before
>> even doing anything
>> to it I found that the MySQL logins were much slower than the 4.0
>> server I used prior to it.
>
>
> Just as a note, I have not noticed this problem at all -- my logins
> are just as fast/fine/snappy as always. Not sure what's wrong with
> your stuff..
>
>> I am at a loss of what to do. I would prefere to go with MySQL 4.1
>> just because that is what
>> comes with CentOS 4, short of that I need php-mysql to work with
>> 4.0. Databases and
>> custome building of RPM's is beyond my capabilities.
>
>
> You can use the builtin 4.1 *client* binaries (which are what php and
> it's ilk are linked to), while using the 4.0 server binaries. All you
> need to do is uninstall "mysql-server" RPM, install your downloaded
> 4.0 binary package to /usr/local/mysql/ (eg), and run the server from
> there using it's custom initscript.
>
> Make sure the /etc/my.cnf is all configured nicely before
> bootstrapping the downloaded 4.0 install, and everything should just
> click (within reason). Most importantly, make sure the socket path and
> database path is set.
>
> -te
>
