Topic: MySql 4.x

[chaissac]

Could we please consider the passage in version 4.x of MySql, to enjoy the variables, the subqueries, etc... ?

[dsemuk]

Could we please consider the passage in version 4.x of MySql, to enjoy the variables, the subqueries, etc... ?

MySQL can be updated to v4.x by following this simple howto:

http://forums.contribs.org/index.php?topic=18597.0

Dave

[chaissac]

http://forums.contribs.org/index.php?topic=18597.0

Doesn't seem to work  

"No posts exist for this topic"

But it seems to be a forum failure. Hope it will be fix soon  

[ergozd]

Cut & paste from the link.

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..

[ergozd]

Cut & paste from the link.

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..

[chaissac]

thx for the explanations.

During this time, the forum ended up functioning again, so the link works now.

I'll try it soon, it's a real need.

BTW, I maintenances my position: it would be nice to update mysql (and php besides) in the future isos of SME Server.

 
one pint to help to swallow my bad English !

[grand-pa]

I agree. For the SME Server v7.0 it would be nice to have at least (and even newer if available) :
- Apache v2.x
- MySQL v4.x
- PHP v5.x
- PERL v6.x

For the two last ones, i know they are not yet released, but for the v7.0, who knows...
And, yes, i know it's a very huge work to do.

[Anonymous]

I guess the 'latest and greatest' does not imply thew most stable and secure.

So maybe a discussion about 'policy' may be usefull.

Let me start off by my point of view;

I go for stable and secure, I can always update server components if I need to do so, and I myself will be responisble for doing so.

Any thoughts?

RequestedDeletion

[grand-pa]

You're wright, the very last version isn't always the best choice.
But i think there is a need to upgrade some componants with the latest major release versions (ie. Apache 1.3.x -> 2.0.x).

[webster]

I guess the 'latest and greatest' does not imply thew most stable and secure.

RequestedDeletion

I Agree Latest and greatest isnt the best option, but there are also problems in the other direction.
Some othe the lesser important packages(to the operation of the server and security) like php, perl, mysql etc have been lagging (i guess the view has always been if they do what they need to, there is need to change it) which means people have to "try"  and upgrade them themselves.

The problem I see(and have found) is that anyone that wants to use these other packages often find some of the features are are missing because they are so old and limited...so its becomes harder to do things that we would like to.

From what I read on a previous post.... the php/gd version on the current system is from about feb 2002? packages from this age could atleast be upgraded to something from last year!! (not thats not me volunteering!!!   )

anyone want to share thier view... visit my previous post and use the poll
http://forums.contribs.org/index.php?topic=20283.msg79813#msg79813

[haj]

Latest version are needed if they give essential new features...

Apache v2.x

I have had a try with it on redhat 8.0 and it is realy slow!