Hi All, Could anyone tell me, how to correctly install MySQL4.1 on Centos 5 ? By default Centos 5 comes with mysql5? If I will compile mysql4 from sources to separate prefix, some features may be unavailable (unix sockets for example). I?m moving some critical application (online booking) based on java, tomcat5, mysql4.1 from old server fedora 4 to new server running Centos 5. So, I don?t want update mysql to new version this time. Thanks, SK
Sergej Kandyla wrote: ..> I?m moving some critical application (online booking) based on java, > tomcat5, mysql4.1 from old server fedora 4 to new server running Centos > 5. So, I don?t want update mysql to new version this time.Why not go for Centos 4? Mogens -- Mogens Kjaer, Carlsberg A/S, Computer Department Gamle Carlsberg Vej 10, DK-2500 Valby, Denmark Phone: +45 33 27 53 25, Fax: +45 33 27 47 08 Email: mk at crc.dk Homepage: http://www.crc.dk
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Sergej Kandyla wrote:> Hi All, > > > Could anyone tell me, how to correctly install MySQL4.1 on Centos 5 ? > By default Centos 5 comes with mysql5? If I will compile mysql4 from > sources to separate prefix, some features may be unavailable (unix > sockets for example). > > I?m moving some critical application (online booking) based on java, > tomcat5, mysql4.1 from old server fedora 4 to new server running Centos > 5. So, I don?t want update mysql to new version this time. >In the time it takes you to figure out how to cleanly install MySQL 4.1 on CentOS 5 you could just use the included MySQL 5 and do some extensive tests to ensure that nothing breaks. You're going to have to do the testing for the 4.1 on CentOS so you may as well do the upgrade and be done with it, assuming that you ignore the advice to load CentOS 4 -- which already has the testing for MySQL 4.1 done. Barry -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (GNU/Linux) iD8DBQFH2YlMCFu3bIiwtTARAi7QAJ4/M8SBUsKvA5cL9eEMqsq34MPTZQCcCKQJ 4a6U7rM8uEEFiL2v+kFJcPw=EH6p -----END PGP SIGNATURE-----
Sergej Kandyla wrote:> Hi All, > > > Could anyone tell me, how to correctly install MySQL4.1 on Centos 5 ? >Thanks, all! The problem is solved. Also I've tried to run our application on default centos mysql5, but have some errors with sql queries. In our application used very big, long and difficult sql queries, and they don't work after updating to mysql5. I've tried to compile mysql4.1.22 and 4.1.20 by hand too, but also have errors. I've compiled with only options --prefix=/usr/local/mysql4 --exec-prefix=/usr/local/mysql4 All compiled ok, and works seems ok, but our application still not work correctly. I don't have ideas about this matter. May be some specific options required...I don't know. In the end, I've downloaded precompiled mysql 4.1.22 (http://dev.mysql.com/downloads/mysql/4.1.html#linux-x86-32bit-rpms) unpacked it to /usr/local/mysql4, made some changes in mysql4 startup script, started... and all seems working fine now :) . PS. sorry for my EN. -- Wbr, SK