I wanted to upgrade to Mysql version 4.x as I'm having too many problems with table corruption with the current Mysql version.

How would one go about upgrading the mysql version?

Thankyou.

[mod edit]
Please do not use this forum for advertisement.
Consider this last warning, next time you will be banned.
[/edit]

stop adv man.


How to update Mysql:
http://fedoranews.org/contributors/tony_smith/mysql/

carlos

www.atomicrocketturtle.com

Use up2date or yum to update mysql by subscribing to the channels you need to

could someone help me out a little on the easiest way to do this now? I followed that first link but I was unable to find the old mysql 3 rpm anywhere and the newest version of mysql is out so the spec file on that link will not work.

just download MySQL 4 RPMs from mysql.com put them in a folder and go rpm -hUV on them

after that run the mysql_fix_privileges script to take advantage of new features and that's about it, be sure to get compat-shared libs to avoid breaking existing software in your box

regards

Thanks kamihacker,

I went ahead and did that, it installed with no errors and I verified that mysql 4 is running but I get this error when starting apache

Starting httpd: Syntax error on line 6 of /etc/httpd/conf.d/php.conf:
Cannot load /usr/lib/httpd/modules/libphp4.so into server: libpspell.so.15: cannot open shared object file: No such file or directory
[FAILED]

Also I was unabled to find that privliges script anywhere on the server, I did also check and it says libpspell is installed (I ran up2date to install it) and a spell was installed prior to mysql 4 install

I also found my libphp4.so in /usr/lib/httpd/modules and changed my /etc/httpd/conf.d/php.confto point to it thinking that may help but got basically the same error.

if you're not using it, disable pspell on php.ini as temporary measure



my mistake on the script name, TIP: sometimes it helps to type


if you're uncertain about additional mysql (or any other) command name

regards

Well that got rid of the pspell error that you so now all we are left with is the lilphp4.so error, not sure why it is giving this error as the file is there

[root@srv1 root]# service httpd start
Starting httpd: Syntax error on line 6 of /etc/httpd/conf.d/php.conf:
Cannot load /modules/libphp4.so into server: /modules/libphp4.so: cannot open shared object file: No such file or directory
[FAILED]
[root@srv1 root]# locate libphp4.so
/usr/lib/httpd/modules/libphp4.so
[root@srv1 root]#

I am trying to follow the steps given from the URL as suggested. However, it seems to be slightly out of date, possibly leading to the error I encounter when I issue the command "rpmbuild -ba mysql4.1.spec":

Executing(%prep): /bin/sh -e /var/tmp/rpm-tmp.24686
+ umask 022
+ cd /usr/src/redhat/BUILD
+ LANG=C
+ export LANG
+ unset DISPLAY
+ $'r'
: command not found686: line 25:
error: Bad exit status from /var/tmp/rpm-tmp.24686 (%prep)


RPM build errors:
Bad exit status from /var/tmp/rpm-tmp.24686 (%prep)


I have no idea what this means..

I downloaded 4.1.10a instead of 4.1.7 because I cannot find 4.1.7 anymore.
The only change I made to the protocol on that website was to the mysql4.1.spec file to replace the old version with 4.1.10a for the %define mysql_version variable at the top of that file.

I hope to get MySQL 4.x working soon because my system requires it.

Thanks!
David