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 5.x

Discussion in 'General Discussion' started by typhon, Jan 15, 2006.

  1. typhon

    typhon Well-Known Member

    Joined:
    Feb 17, 2004
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    6
    Has anyone attempted to do an RPM update for MySQL from 4.1 to 5.x yet?

    I am sure someone on here has, maybe tell us what you did? I was thinking about doing so and removing all the old rpms and doing a new intall with 5.x now. I am getting sick of the wait times before getting items like this and since it is third party it is not the main focus. So yep. I might attempt to do this later although all I have is my production box.
     
  2. Sinewy

    Sinewy Well-Known Member

    Joined:
    May 15, 2004
    Messages:
    367
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Sydney, Australia
    cPanel Access Level:
    DataCenter Provider
    I would dump all the databases etc. uninstall the 4.1 rpms, remove the mysql data directory, install 5.0 fresh and then reload the databases etc back.

    Regards,
    Alan
     
  3. typhon

    typhon Well-Known Member

    Joined:
    Feb 17, 2004
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    6
    cool. this upgrade worked like a charm... it seems that the mysql functions in WHM work as well. Then I downloaded and updated phpmyadmin so we are all set to go here :)

    "Welcome to phpMyAdmin 2.7.0-pl2
    MySQL 5.0.18-standard running on localhost"

    Here was the steps...

    rpm -e all of the old mysql rpms
    rpm -i all of the 5.0 rpms

    service mysql restart
    /usr/bin/mysql_fix_privilege_tables --password=yourpasswordhere

    cd /usr/local/cpanel/base/3rdparty
    wget http://easynews.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.7.0-pl2.zip
    unzip phpMyAdmin-2*
    rm phpMyAdmin-2*.zip
    chown root:wheel phpMyAdmin-2*
    chmod 0700 phpMyAdmin-2*
    cd phpMyAdmin-2*
    chown -R cpanel:cpanel *
    chmod -R 0700 *
    cp ../phpMyAdmin/config.inc.php
    cd ../
    mv phpMyAdmin phpMyAdmin-bak
    mv phpMyAdmin-2* phpMyAdmin

    now you should be all set to go :)
     
  4. typhon

    typhon Well-Known Member

    Joined:
    Feb 17, 2004
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    6
    One note I should add onto this...
    When you install the rpms for client and server make sure to use the flag --nodeps otherwise it will complain about perl-DBI not being installed. When I checked through cpan DBI was infact installed just not through an RPM. So keep that in mind :)
     
  5. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    Don't forget to do the following or cPanel updates will wipe out all your hard work:

    touch /etc/mysqlupdisable
     
  6. b0072k1

    b0072k1 Well-Known Member

    Joined:
    Dec 30, 2004
    Messages:
    133
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Glasgow
    any one o fgettin the new phpmyadmin running on 4.1?
     
  7. [MuTe]

    [MuTe] Member

    Joined:
    Oct 4, 2004
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    Thx This Worked

    This worked for me too.

    Thx for posting it :D
     
  8. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    I would be more interested in user compatibility problem to be reported with MySQL 5.

    We have not upgraded to MySQL 5 yet because we have had a large number of
    users tell us that their scripts and programs are not compatible with MySQL 5.

    (The largest group of complainers are coming from those running IPB forum software)

    So for those who have gone to MySQL 5, are you getting any user complaints
    coming back at you regarding any software incompatibilities?
     
  9. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    Yes, we upgraded MySQL to one of our clients to v5.0.19-0 and VB behaved weird, so we had to downgrade to v4.1.18.
     
  10. NetBlaster

    NetBlaster Member

    Joined:
    Jun 12, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
  11. Bulent Tekcan

    Bulent Tekcan Well-Known Member

    Joined:
    May 11, 2004
    Messages:
    177
    Likes Received:
    0
    Trophy Points:
    16
    After upgrade I have received this error...

    Warning: Default theme green_orange not found! in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/Theme_Manager.class.php on line 57


    Any idea ?
     
  12. NetBlaster

    NetBlaster Member

    Joined:
    Jun 12, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1

    Edit this file: /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php

    Find the line with green_orange and change it to darkblue_orange.

    You can add different theme from phpmyadmins site.
     
Loading...

Share This Page