ee99ee

Well-Known Member
Aug 15, 2003
70
0
156
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

Well-Known Member
Apr 1, 2006
69
0
156
INDIA
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.

[email protected] [~]# 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.
#####################################

[email protected] [~]# 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

Well-Known Member
Mar 3, 2006
1,213
0
166
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

Well-Known Member
Apr 1, 2006
69
0
156
INDIA
We have a server with the following config -------->

[email protected] [~]# 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

[email protected] [~]# 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

Well-Known Member
Aug 15, 2003
70
0
156
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