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 > 5 Update

Discussion in 'General Discussion' started by celliott, Dec 10, 2007.

  1. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United Kingdom
    Hi,

    I have been putting off updating MySQL 4.1 based servers to 5 because of the associated problems with scripts.

    On one shared production server we have about 200 accounts with scripts like vBulletin, PhpBB, Wordpress, OScommerce etc.

    Is updating MySQL likely to have many issues/has anyone done this recently?

    Thanks
     
  2. trhosting.net

    trhosting.net Well-Known Member

    Joined:
    Mar 7, 2006
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Turkey
    MySQL 4.1 -> 5.0 update is very simple.
    I think that your upgrade will complete smoothly without any error.

    4.0 -> 4.1 or 4.0 -> 5.0 is a headache :)
     
  3. 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
    Agreed, moving from 4.0 seems to be the biggest headache.

    I have a lot of custom-built scripts as well as WordPress installations and other "canned" scripts, and have never noticed when moving among servers that have MySQL 4.1 vs. 5.0. If a script doesn't explicitly support 4.1 (anything reasonably maintained will support 5), just set it for 4.1 and it'll likely work.
     
  4. InterServed

    InterServed Well-Known Member

    Joined:
    Jul 10, 2007
    Messages:
    255
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    DataCenter Provider
    upgraded to 5.0 and i get the following error on cron executions:

    php: error while loading shared libraries: libmysqlclient.so.14: cannot open shared object file: No such file or directory
     
  5. 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
    Did you also recompile PHP/Apache using EA after you upgraded MySQL? I ask, because it is a common mistake.
     
Loading...

Share This Page