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.10

Discussion in 'General Discussion' started by Blue|Fusion, Feb 18, 2005.

  1. Blue|Fusion

    Blue|Fusion Well-Known Member

    Joined:
    Sep 12, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Cleveland, Ohio
    Any word on when CP will update their mirrors and scripts for use with MySQL 4.1.10 from 4.1.8? If not any time soon, I guess I'll just use the official RPMs which then get overwritten by upcp when ran back to 4.1.8.
     
  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
    rm /var/cpanel/mysqlup

    That will stop upcp from touching MySQL.

    To upgrade manually to 4.1.10

    service mysql stop
    service chkservd stop

    Grab the official RPMs

    rpm -Uvh MySQL-*.rpm

    service chkservd start

    You should recompile PHP after a MySQL upgrade to make sure any MySQL library/client changes go into effect.
     
  3. Blue|Fusion

    Blue|Fusion Well-Known Member

    Joined:
    Sep 12, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Cleveland, Ohio
    Thanks alot Sinewy, upgrade went fine all 3 servers. Only concern...
    There is no /var/cpanel/mysqlup present on any of the 3 servers. Do you mean /scripts/mysqlup?
     
  4. 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
    /var/cpanel/mysqlup is the file that tells upcp to run mysqlup.

    If it doesn't exist, then upcp won't run mysqlup nightly.
     
  5. Blue|Fusion

    Blue|Fusion Well-Known Member

    Joined:
    Sep 12, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Cleveland, Ohio
    Well it doesn't exist, which I guess is a good sign in this case, however I also don't want MySQL to be touched when I run upcp manually, as I'm running CURRENT tree and updates come out every few days. Should I move or chmod 000 and chattr +i /scripts/mysqlup? Would it prevent it?
     
  6. fusioncroc

    fusioncroc Well-Known Member

    Joined:
    Sep 28, 2004
    Messages:
    261
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    U.K.
    Yesterday when mysql messed up for me i re compiled to mysql 4.1.10 from the rpm's and its been working ok ( except a problem with not seeing databases in "manage mysql" and the root password for phpmyadmin not working , after changing it etc )
     
  7. Blue|Fusion

    Blue|Fusion Well-Known Member

    Joined:
    Sep 12, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Cleveland, Ohio
    Actually after testing it now, it seems running upcp and even /scripts/mysqlup, it doesn't mess with MySQL. It says MySQL is up to date, which is even better than having to mess with the scripts. As for the root pass, I had similar problems when going from 4.0 to 4.1 and had to downgrade back to 4.0, reset pass, then upgrade once again to 4.1, and set the pass, then it worked.
     
  8. fusioncroc

    fusioncroc Well-Known Member

    Joined:
    Sep 28, 2004
    Messages:
    261
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    U.K.
    I've tryied that and its still messed up but i might just try again :D
    ( if only i could get the php errors to stop)
     
Loading...

Share This Page