Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: john on September 24, 2003, 08:49:05 PM

Title: MYSQL 4.0 UPDATE HOWTO
Post by: john on September 24, 2003, 08:49:05 PM

UPDATING  TO MYSQL 4.0..(tested on sme 6.0b3)

1. STOP MYSQL

   /etc/rc.d/init.d/mysql stop

2. REMOVE OLD RPM

rpm -e --nodeps mysql-client mysql-server
rpm -e mysql-devel
rpm -e mysqlclient9

3. DOWNLOAD MySQL 4.0. FROM WWW.MYSQL.COM

 INSTAL NEW RPMS:

rpm -Uhv MySQL-server-4.0.15-0.i386.rpm
rpm -Uhv MySQL-client-4.0.15-0.i386.rpm
rpm -Uhv MySQL-shared-compat-4.0.15-0.i386.rpm
rpm -Uvh MySQL-devel-4.0.15-0.i386.rpm

4. CONFIGURE

chkconfig --levels 2345 mysql on
rm /etc/rc.d/rc7.d/S90mysqld
ln -s /etc/rc.d/init.d/mysql /etc/rc.d/rc7.d/S90mysqld

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no (enable remote access)
/sbin/e-smith/expand-template /root/.my.cnf
/etc/rc.d/init.d/mysql restart

5. ENJOY..

Title: Re: MYSQL 4.0 UPDATE HOWTO
Post by: guestHH on September 25, 2003, 02:29:53 PM

'/etc/rc.d/init.d/mysql' must be '/etc/rc.d/init.d/mysqld' (mysql with d)

Title: Re: MYSQL 4.0 UPDATE HOWTO
Post by: Ted on September 27, 2003, 06:25:29 AM

umm...I get /etc/rc.d/init.d/mysqld restart

bash: /etc/rc.d/init.d/mysqld: No such file or directory


I followed the directions to the T?

Title: Re: MYSQL 4.0 UPDATE HOWTO
Post by: john on September 27, 2003, 05:50:13 PM

use /etc/rc.d/init.d/mysql  restart...... worked for me.

Title: Re: MYSQL 4.0 UPDATE HOWTO
Post by: guestHH on September 29, 2003, 01:22:42 PM

John,

Thanks for wrting up the how-to. I performed it on a 5.6 box and it worked like a charm!

The only thing is that I had to use /etc/rc.d/init.d/mysqld
so maybe it's different from SME6b.

Thanks again.

Title: Re: MYSQL 4.0 UPDATE HOWTO
Post by: GeoffP on September 30, 2003, 07:24:56 PM

Perhaps stick "DOWNLOAD MySQL 4.0. FROM WWW.MYSQL.COM" as step 1 - finding out mysql.com is down after doing step 2 would be annoying.....

Thanks for a great HOWTO.

G

Title: Re: MYSQL 4.0 UPDATE HOWTO
Post by: GeoffP on September 30, 2003, 08:25:33 PM

heh - spoke too soon. If you perform step 3 in the order listed, you'll get the following error:

[root@kylie mysql]# rpm -Uvh MySQL-server-4.0.15-0.i386.rpm
error: failed dependencies:
        libmysqlclient.so.10   is needed by perl-DBD-MySQL-1.2219-6
        libmysqlclient.so.10   is needed by php-mysql-4.1.2-7.3.4

You need to download the 4 rpm's into a directory and do a:

rpm -Uvh *.rpm

then they'll all install ok.... (this is on 5.6 by the way)

G

Title: Re: MYSQL 4.0 UPDATE HOWTO
Post by: Derek Godfrey on November 24, 2003, 10:35:49 AM

Well, I have tried this method and the moving files method.  I am missing the mysql.sock and also the mysqld start or stop no longer works either.  I cannot log into mysql because of the sock error with PHPMyAdmin.

Is tehre anyway to recover from this without having to format my SCSI hard drives and doing a fresh install of 5.6?  Should I just do a clean install of 6B3 instead if I have to F&R?

I need PHP 4.1+ and MySQL 4+ to run a portal system.  I have PHP 4.3.2 following teh howto for that...but this howto just hosed everything up.  Thanks

Derek (Still a newbie after 3 years)

Title: Re: MYSQL 4.0 UPDATE HOWTO
Post by: chrsim on February 14, 2004, 12:29:10 PM

Quote from: "RequestedDeletion"

'/etc/rc.d/init.d/mysql' must be '/etc/rc.d/init.d/mysqld' (mysql with d)

You were cool

Worked ok on a 6.0 final server-only
I am enabling horde this afternoon

Title: Re: MYSQL 4.0 UPDATE HOWTO
Post by: chrsim on February 14, 2004, 12:35:24 PM

Quote from: "john"

UPDATING  TO MYSQL 4.0..(tested on sme 6.0b3)

1. STOP MYSQL

   /etc/rc.d/init.d/mysql stop

2. REMOVE OLD RPM

rpm -e --nodeps mysql-client mysql-server
rpm -e mysql-devel
rpm -e mysqlclient9

3. DOWNLOAD MySQL 4.0. FROM WWW.MYSQL.COM
 in a fresh directory
 INSTAL NEW RPMS:

 -rpm -Uhv MySQL-server-4.0.15-0.i386.rpm
 -rpm -Uhv MySQL-client-4.0.15-0.i386.rpm
 -rpm -Uhv MySQL-shared-compat-4.0.15-0.i386.rpm
 -rpm -Uvh MySQL-devel-4.0.15-0.i386.rpm
Should be rpm -Uvh *.pm for dependancies
4. CONFIGURE

chkconfig --levels 2345 mysql on
rm /etc/rc.d/rc7.d/S90mysqld
ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc7.d/S90mysqld

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no (enable remote access)
/sbin/e-smith/expand-template /root/.my.cnf
/etc/rc.d/init.d/mysql restart

5. ENJOYING..

6. Checked the ibays (phpbb, admin panel, PHPMyAdmin)
   THEY ALL WORK COOL

Title: direct url location for mysql 4 rpm
Post by: nefkho on February 16, 2004, 06:20:50 AM

hi,

i cant fine the mysql 4 rpms in mysql site, any one have the direct link?

thanks,

nef kho

Title: MYSQL 4.0 UPDATE HOWTO
Post by: smeghead on February 16, 2004, 06:32:29 AM

http://www.mysql.com/downloads/mysql-4.0.html

Linux x86 RPM downloads section.

Title: MYSQL 4.0 UPDATE HOWTO
Post by: Tech on February 27, 2004, 08:33:50 AM

After upgrading, MySQL does not start automaticaly after reboot.

Appearantly, the service name hase changed from "mysqld" to "mysql", Could that be the cause?

How to fix it?

Title: MySql client 3.23.58
Post by: eekb on August 29, 2004, 06:14:36 PM

After upgrading to MySQL 4.0.20 I still see in PHPinfo the 3.23.58 client.
In my console when I type mysql -V I see the version 4.0.20. Why is this.
How can I get the client also go to 4.0.20?