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 version update

Discussion in 'General Discussion' started by galantina, Apr 20, 2005.

  1. galantina

    galantina Member

    Joined:
    Sep 2, 2004
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Hi!

    Something is not clear to me and I hope someone can explain that to me. :confused:

    I have two servers with WHM/Cpanel. I use Mysql 4.1 on both of them. I use WHM "realese "
    updates in my update config. I update WHM manually. cPanel Package Updates and security
    Package Updates are set to be automatic.
    I have updated whm few weaks ago and for the last weak I see that server1(centos) is running mysql 4.10a and server2(RHE) is running mysq4.11-standard. I tried updating system software and updating server software from whm, but still the same.
    How can this be? As I understand mysql version is determined by cpanel. How can this two servers have different versions of mysql?

    Thanks. Best regards to all of you.
     
  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    WHM > Tweak Settings > MySQL Version to use > 4.1 > make sure you follow the Click Here link after clicking Save
     
  3. galantina

    galantina Member

    Joined:
    Sep 2, 2004
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    still the same.
    Can someone tell me what version of mysql 4.1 do you have with your update config on RELEASE tree?
     
  4. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    MySQL is release independent, so it would not be relevant. I'd suggest that you remove all the MySQL rpms and then run /scripts/mysqlup that's always worked for me when MySQL has gotten screwed up.
     
  5. galantina

    galantina Member

    Joined:
    Sep 2, 2004
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    Ok Thanks.
    I would just like to ask other peaople if they could tell me which version of mysql 4.1 do they have and on which OS.

    Thanks. Best Regards.
     
  6. dwh2

    dwh2 Well-Known Member

    Joined:
    Jan 14, 2004
    Messages:
    106
    Likes Received:
    0
    Trophy Points:
    16
    I don't know my rpm from my elbow. How do you remove mysql rpms?
     
  7. DigitalN

    DigitalN Well-Known Member

    Joined:
    Sep 23, 2004
    Messages:
    420
    Likes Received:
    1
    Trophy Points:
    18
    To upgrade MySQL you can do just do this

    # rpm -qa | grep -i mysql

    To see which rpms are installed.

    Then download the latest releases from the MySQL site

    # mkdir new-mysql

    # cd new-mysql

    # wget ..... remote path to download MySQL rpms from the nearest mirror.rpm

    To upgrade the rpms once downloaded, you can then

    # rpm -Uvh *.rpm

    To actually remove rpms, you would

    # rpm -e rpm-package-name (being the actual name of the rpm as per the rpm -qa output

    Make sure you don't need the MySQL data or back up prior to removing the rpms.
     
Loading...

Share This Page