Koozali.org: home of the SME Server
  1. Koozali.org: home of the SME Server
  2. Legacy Forums
  3. Experienced User Forum
  4. Topic: MYSQL 4.0 UPDATE HOWTO
« previous next »
Pages: [1]   Go Down

MYSQL 4.0 UPDATE HOWTO

  • 13 Replies
  • 6345 Views

john

MYSQL 4.0 UPDATE HOWTO
« 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..
Logged

guestHH

Re: MYSQL 4.0 UPDATE HOWTO
« Reply #1 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)
Logged

Ted

Re: MYSQL 4.0 UPDATE HOWTO
« Reply #2 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?
Logged

john

Re: MYSQL 4.0 UPDATE HOWTO
« Reply #3 on: September 27, 2003, 05:50:13 PM »
use /etc/rc.d/init.d/mysql  restart...... worked for me.
Logged

guestHH

Re: MYSQL 4.0 UPDATE HOWTO
« Reply #4 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.
Logged

GeoffP

Re: MYSQL 4.0 UPDATE HOWTO
« Reply #5 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
Logged

GeoffP

Re: MYSQL 4.0 UPDATE HOWTO
« Reply #6 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
Logged

Derek Godfrey

Re: MYSQL 4.0 UPDATE HOWTO
« Reply #7 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)
Logged

chrsim

Re: MYSQL 4.0 UPDATE HOWTO
« Reply #8 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
Logged

chrsim

Re: MYSQL 4.0 UPDATE HOWTO
« Reply #9 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
Logged

Offline nefkho

  • *****
  • 183
  • +0/-0
    • http://www.cagothonglines.com
direct url location for mysql 4 rpm
« Reply #10 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
Logged
Nef Kho  :-) .........

Offline smeghead

  • *
  • 563
  • +0/-0
MYSQL 4.0 UPDATE HOWTO
« Reply #11 on: February 16, 2004, 06:32:29 AM »
http://www.mysql.com/downloads/mysql-4.0.html

Linux x86 RPM downloads section.
Logged
..................

Tech

MYSQL 4.0 UPDATE HOWTO
« Reply #12 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?
Logged

eekb

MySql client 3.23.58
« Reply #13 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?
Logged
Pages: [1]   Go Up
« previous next »
  1. Koozali.org: home of the SME Server
  2. Legacy Forums
  3. Experienced User Forum
  4. Topic: MYSQL 4.0 UPDATE HOWTO