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.

Upgrade to MySQL 5.0 while staying with Apache1/PHP4

Discussion in 'EasyApache' started by christiannancy, Apr 9, 2009.

  1. christiannancy

    christiannancy Registered

    Joined:
    Apr 9, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    We are contemplating upgrading MySQL to 5.0 from 4.1 but we need to keep the Apache1/PHP4 version because of some of our customers' needs.

    Can someone confirm that we will be able to upgrade MySQL to 5.0 (using the WHM functionality) without having to also upgrade Apache or PHP?

    Since this is a production server we can't just "try and see what happens" :)

    Thanks,
    Christian
     
  2. servertechs

    servertechs Active Member

    Joined:
    Aug 24, 2008
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    India
    Yes you can upgrade the MySQL version without recompiling the apache/php and there is no need to recompile the apache to upgrade the MySQL Version

    To upgrade the MySQL Version

    Login to WHM and go to >> Server Configuration >> Tweak Settings

    here find "MySQL" and select the version 5 then save the settings and run following command on shell as root user

    #/scripts/mysqlup --force

    This script will upgrade the MySQL Version on your server.

    Enjoy;)
     
  3. christiannancy

    christiannancy Registered

    Joined:
    Apr 9, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Thanks for the confirmation.

    Will try this at our next maintenance window in a couple weeks and report back if we run into trouble.

    -Christian
     
  4. anatolia

    anatolia Member

    Joined:
    May 9, 2005
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
  5. mambovince

    mambovince Well-Known Member

    Joined:
    Jan 15, 2005
    Messages:
    192
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    London, UK
    Are there any issues to be aware of when upgrading to MySQL 5 from MySQL 4.1.22 especially in regards to popular scripts like Joomla, WordPress etc...

    Many thanks,

    - Vince
     
  6. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Downgrading databases from MySQL 5 to 4.1 is not readily possible. So please make a backup of your databases before you commence with the upgrade - just in case for some reason you need to revert back to 4.1.

    From a PHP script perspective, most scripts work just as well (if not better) in MySQL 5.0 than 4.1. I use Joomla and WordPress and just upgraded from 4.1 to 5.0 myself - didn't have to do anything to either Joomla nor WordPress.

    Going from MySQL 4.0 to 4.1 was a much bigger leap than going from MySQL 4.1 to 5.0.
     
  7. PaulCleese

    PaulCleese Registered

    Joined:
    Apr 17, 2009
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    thanks i was having trouble with this too.
     
Loading...

Share This Page