MySQL 4.1 or 5.0?

[ee99ee]

We're currently running MySQL 4.0 in production. In order to support upgrading to the latest PHP version, we must be running the 4.1.x or 5.x series of MySQL.

What series do you guys run?

I am a developer as well, and I know had I had major breakage when I tried to use 5.x on my development box on common application a few months ago, even with all the backward compatability stuff enabled. Because of that, I'm a bit afraid to go to the 5.x version.

Thoughts?

-Chris

 

[madan.cpanelnet]

Login to the WHM interface, and from “Server Configuration / Tweak Settings” choose in the “MySQL” section the 5.0 radio button. Then click “Save” and you are done. This will actually run the script: /scripts/mysqlup that will download and install the latest MySQL5 rpms available at that time.
After completion as instructed you should rebuild your perl mysql libraries and rebuild apache (to have php build against the newly installed mysql library).

/scripts/perlinstaller --force Bundle::DBD::mysql



Next restart mysql.. and you will find that mysql fails to start.


Tip:- Remove the line basedir=/var/lib from your my.cnf file... and restart.. you are done.

root@server2 [~]# mysql -V
mysql Ver 14.12 Distrib 5.0.24, for pc-linux-gnu (i686) using readline 5.0




Very simple my.cnf on a cpanel server with mysql 5.
#####################################

root@server2 [~]# cat /etc/my.cnf
[mysqld]
set-variable = max_connections=500
safe-show-database
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
old-passwords = 1

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid




Thats it.

 

[jayh38]

We're currently running MySQL 4.0 in production. In order to support upgrading to the latest PHP version, we must be running the 4.1.x or 5.x series of MySQL.

What series do you guys run?

I am a developer as well, and I know had I had major breakage when I tried to use 5.x on my development box on common application a few months ago, even with all the backward compatability stuff enabled. Because of that, I'm a bit afraid to go to the 5.x version.

Thoughts?

-Chris

MySql 4.1x php 5.1x I am a developer as well and have many developer clients that prefer this configuration.

 

[madan.cpanelnet]

We have a server with the following config -------->

root@vp2a [~]# php -v
PHP 5.0.4 (cli) (built: Oct 13 2006 16:02:02)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v2.0.4-dev, Copyright (c) 1998-2004 Zend Technologies

root@vp2a [~]# mysql -V
mysql Ver 14.7 Distrib 4.1.21, for pc-linux-gnu (i686) using readline 4.3


In order to upgrade PHP ... you can follow the following doc..


http://www.ducea.com/2006/06/20/upgrade-php-on-cpanelwhm/



Thanks

 

[ee99ee]

Thanks for the information on how to upgrade, but I just wanted to know what you all thought of the various versions, I already knew how to do the upgrade.

Thanks for the information! I think we're going to stick with 4.1, that's what I was leaning toward anyway...

Thanks,

Chris Miller