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:
    156
    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.
     
    #1 typhon, Jan 15, 2006
  2. Sinewy

    Sinewy Well-Known Member

    Joined:
    May 15, 2004
    Messages:
    367
    Likes Received:
    1
    Trophy Points:
    168
    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
     
    #2 Sinewy, Jan 15, 2006
  3. typhon

    typhon Well-Known Member

    Joined:
    Feb 17, 2004
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    156
    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 :)
     
    #3 typhon, Jan 15, 2006
  4. typhon

    typhon Well-Known Member

    Joined:
    Feb 17, 2004
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    156
    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 :)
     
    #4 typhon, Jan 15, 2006
  5. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,472
    Likes Received:
    20
    Trophy Points:
    463
    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
     
    #5 chirpy, Jan 15, 2006
  6. b0072k1

    b0072k1 Well-Known Member

    Joined:
    Dec 30, 2004
    Messages:
    132
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Glasgow
    any one o fgettin the new phpmyadmin running on 4.1?
     
    #6 b0072k1, Mar 20, 2006
  7. [MuTe]

    [MuTe] Member

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

    This worked for me too.

    Thx for posting it :D
     
    #7 [MuTe], Mar 21, 2006
  8. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    8
    Trophy Points:
    193
    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?
     
    #8 Spiral, Mar 25, 2006
  9. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    193
    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.
     
    #9 AndyReed, Mar 25, 2006
  10. NetBlaster

    NetBlaster Member

    Joined:
    Jun 12, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    151
    #10 NetBlaster, Mar 26, 2006
  11. Bulent Tekcan

    Bulent Tekcan Well-Known Member

    Joined:
    May 11, 2004
    Messages:
    178
    Likes Received:
    0
    Trophy Points:
    166
    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 ?
     
    #11 Bulent Tekcan, Apr 30, 2006
  12. NetBlaster

    NetBlaster Member

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

    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.
     
    #12 NetBlaster, Apr 30, 2006
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL
  1. sparek-3

    New Thread MySQL to MariaDB - what to expect?

    sparek-3, Jun 26, 2017 at 11:59 AM, in forum: Database Discussions
    Replies:
    1
    Views:
    24
    mtindor
    Jun 26, 2017 at 2:26 PM
  2. burn1024

    Munin mysql2 plugin isn't working

    burn1024, Jun 23, 2017 at 5:41 PM, in forum: General Discussion
    Replies:
    1
    Views:
    32
    cPanelMichael
    Jun 26, 2017 at 10:57 AM
  3. Souther

    MySQL Profiles: user app migration to using remote server

    Souther, Jun 21, 2017 at 11:30 PM, in forum: Database Discussions
    Replies:
    6
    Views:
    66
    Souther
    Jun 22, 2017 at 12:43 PM
  4. crismarques silva

    Dedicated server overloading because of mysql

    crismarques silva, Jun 21, 2017 at 6:33 AM, in forum: Database Discussions
    Replies:
    3
    Views:
    50
    cPanelMichael
    Jun 21, 2017 at 9:46 AM
  5. Naila

    Mysql Always Restarting During Full Backup Restore

    Naila, Jun 20, 2017 at 7:42 AM, in forum: Database Discussions
    Replies:
    4
    Views:
    85
    Naila
    Jun 22, 2017 at 1:35 PM

Share This Page