The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL 4.1 or 5.0?

Discussion in 'General Discussion' started by ee99ee, Oct 29, 2006.

  1. ee99ee

    ee99ee Well-Known Member

    Joined:
    Aug 15, 2003
    Messages:
    70
    Likes Received:
    0
    Trophy Points:
    6
    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
     
  2. madan.cpanelnet

    madan.cpanelnet Well-Known Member

    Joined:
    Apr 1, 2006
    Messages:
    69
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    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.

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

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    MySql 4.1x php 5.1x I am a developer as well and have many developer clients that prefer this configuration.
     
  4. madan.cpanelnet

    madan.cpanelnet Well-Known Member

    Joined:
    Apr 1, 2006
    Messages:
    69
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    INDIA
    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
     
  5. ee99ee

    ee99ee Well-Known Member

    Joined:
    Aug 15, 2003
    Messages:
    70
    Likes Received:
    0
    Trophy Points:
    6
    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
     
Loading...

Share This Page