HOW TO: UpgradeMySQL4.1.14

[@how@]

Hello,

Here new how to
http://www.directadmin.com/forum/showthread.php?s=&threadid=12006

UPDATE 13/2/2006 12GMT









Old post

just update with script

nano mysql

copy the script to mysql file

#!/bin/sh

/etc/rc.d/init.d/mysqld stop

cd $HOME

echo -e "\n\n\033[1;37web4host.net\033[0m\n\n";

[url]http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-server-4.1.14-0.i386.rpm/from/http://mysql.he.net/[/url]
[url]http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-client-4.1.14-0.i386.rpm/from/http://mysql.he.net/[/url]
[url]http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-devel-4.1.14-0.i386.rpm/from/http://mysql.he.net/[/url]

rpm -Uvh ./MySQL-server-4.1.14-0.i386.rpm
rpm -Uvh ./MySQL-client-4.1.14-0.i386.rpm
rpm -Uvh ./MySQL-devel-4.1.14-0.i386.rpm


rm -fr ./MySQL-server-4.1.14-0.i386.rpm ./MySQL-client-4.1.14-0.i386.rpm ./MySQL-devel-4.1.14-0.i386.rpm



echo -e "\n\n\033[1;37web4host.net\033[0m\n\n";

rm -f /etc/init.d/mysql
rm -f /etc/rc?.d/*mysql

/etc/rc.d/init.d/mysqld restart

exit 0;

save

chmod +x mysqld

run

./mysql

DONE.

take look in System Information MySQL 4.1.14

 

[RenDprogrammeur]

Tnx it workt!

 

[@how@]

welcome

 

[albatroz]

Can you all confirm if the script above works fine?

There are some lines that looks garbled due to the way this forum software handles them...

 

[@how@]

just you need to download rpm
MySQL-server-4.1.14-0.i386.rpm
MySQL-client-4.1.14-0.i386.rpm
MySQL-devel-4.1.14-0.i386.rpm

then run this

#!/bin/sh

/etc/rc.d/init.d/mysqld stop

cd $HOME

echo -e "\n\n\033[1;37web4host.net\033[0m\n\n";


rpm -Uvh ./MySQL-server-4.1.14-0.i386.rpm
rpm -Uvh ./MySQL-client-4.1.14-0.i386.rpm
rpm -Uvh ./MySQL-devel-4.1.14-0.i386.rpm


rm -fr ./MySQL-server-4.1.14-0.i386.rpm ./MySQL-client-4.1.14-0.i386.rpm ./MySQL-devel-4.1.14-0.i386.rpm



echo -e "\n\n\033[1;37web4host.net\033[0m\n\n";

rm -f /etc/init.d/mysql
rm -f /etc/rc?.d/*mysql

/etc/rc.d/init.d/mysqld restart

exit 0;

work fine 100%

 

[albatroz]

I tried the above but "phpinfo" tells me that mysql client api is still from MySQL 4.0.2. Any ideas to fix this?

 

[@how@]

you need to download new RPM form here
http://dev.mysql.com/downloads/mysql/4.1.html
then set
MySQL-server-4.1.16-0.i386.rpm
MySQL-client-4.1.16-0.i386.rpm
MySQL-devel-4.1.16-0.i386.rpm
in place
MySQL-server-4.1.14-0.i386.rpm
MySQL-client-4.1.14-0.i386.rpm
MySQL-devel-4.1.14-0.i386.rpm

run ./mysql

 

[albatroz]

It seems that I need to recompile PHP with the new client API.

Does anybody have any instructions?

 

[nobaloney]

Do a complete customapache update:

First log in as root:

cd /usr/local/directadmin/customapache
(above kills changes; save them first)
./build clean
./build all d
./build zend

Then check link:

cd /usr/lib
ls -al libgdbm.so

if not found you need to create a link:

cd /usr/lib
ln -s libgdbm.so.2.<tab> libgdbm.so

where <tab> is replaced by pressing the tab-key.

Then verify:

ls -al libgdbm.so*

Jeff

 

[albatroz]

It seems OK, but the problem persists

 

[@how@]

you Upgrade to 4.1 or downgrade from 5.0 to 4.1 ?

 

[albatroz]

Upgraded from 4.0 to 4.1.x

The problem actually persists in some (not all) php pages like phpmyadmin 2.64.

 

[waterkei]

is it work with for FC2?

 

[albatroz]

It is running on Redhat 9

 

[@how@]

i use MySQL 4.1.14 in 4 server with CentOS 4.2 work fine 100%
try to install RPM with force / nodeps
Stop MySQL

/etc/rc.d/init.d/mysqld stop

then install RPM again

rpm -Uvh --force --nodeps ./MySQL-server-4.1.14-0.i386.rpm
rpm -Uvh --force --nodeps ./MySQL-client-4.1.14-0.i386.rpm
rpm -Uvh --force --nodeps ./MySQL-devel-4.1.14-0.i386.rpm

start MySQL

/etc/rc.d/init.d/mysqld restart

End




Wael

 

[@how@]

is it work with for FC2?

work fine

 

[The_cobra666]

Can anyone post a script to update to 4.1.16? Don't want to take the risk to change the script above and make a mistake. It's for CentOS 4.2

Greetz

 

[The_cobra666]

For the people who want it ==>

#!/bin/sh

/etc/rc.d/init.d/mysqld stop

cd $HOME

echo -e "\n\n\033[1;37web4host.net\033[0m\n\n";

wget [url]http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-server-4.1.16-1.i386.rpm/from/http://mysql.he.net/[/url]
wget [url]http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-client-4.1.16-1.i386.rpm/from/http://mysql.he.net/[/url]
wget [url]http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-devel-4.1.16-1.i386.rpm/from/http://mysql.he.net/[/url]


rpm -Uvh ./MySQL-server-4.1.16-1.i386.rpm
rpm -Uvh ./MySQL-client-4.1.16-1.i386.rpm
rpm -Uvh ./MySQL-devel-4.1.16-1.i386.rpm


rm -fr ./MySQL-server-4.1.16-1.i386.rpm ./MySQL-client-4.1.16-1.i386.rpm 
./MySQL-devel-4.1.16-1.i386.rpm



echo -e "\n\n\033[1;37web4host.net\033[0m\n\n";

rm -f /etc/init.d/mysql
rm -f /etc/rc?.d/*mysql

/etc/rc.d/init.d/mysqld restart

exit 0;

 

[@how@]

For the people who want it ==>

#!/bin/sh

/etc/rc.d/init.d/mysqld stop

cd $HOME

echo -e "\n\n\033[1;37web4host.net\033[0m\n\n";

wget [url]http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-server-4.1.16-1.i386.rpm/from/http://mysql.he.net/[/url]
wget [url]http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-client-4.1.16-1.i386.rpm/from/http://mysql.he.net/[/url]
wget [url]http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-devel-4.1.16-1.i386.rpm/from/http://mysql.he.net/[/url]


rpm -Uvh ./MySQL-server-4.1.16-1.i386.rpm
rpm -Uvh ./MySQL-client-4.1.16-1.i386.rpm
rpm -Uvh ./MySQL-devel-4.1.16-1.i386.rpm


rm -fr ./MySQL-server-4.1.16-1.i386.rpm ./MySQL-client-4.1.16-1.i386.rpm 
./MySQL-devel-4.1.16-1.i386.rpm



echo -e "\n\n\033[1;37web4host.net\033[0m\n\n";

rm -f /etc/init.d/mysql
rm -f /etc/rc?.d/*mysql

/etc/rc.d/init.d/mysqld restart

exit 0;

just use in frist post.
coz there in no RPM to MySQL4.1.16-1 386


Wael

 

[The_cobra666]

I runed the script from above, and mysql was updated to 4.1.16....