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 upgrade error version 5.1 to 5.5 (500 Iternal server error)

Discussion in 'Database Discussions' started by promesashost, Jun 19, 2014.

  1. promesashost

    promesashost Registered

    Joined:
    Jun 19, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I have a problem with my server just upgraded mysql from version 5.1 to version 5.5 and is giving me 500 error internal error I need urgent help thanks
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    What method did you use to upgrade to MySQL 5.5? Did you ensure PHP was rebuilt using EasyApache during the process? What's the output in /usr/local/apache/logs/error_log when this error occurs?

    Thank you.
     
  3. shufil

    shufil Well-Known Member

    Joined:
    Mar 19, 2014
    Messages:
    71
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello Team,

    sorry here

    I need also upgrade from mysql 5.1 to 5.5 , so whitch methode we can use here , also we need to up all php libs with mysql5.5 and related pakeges .
    so please advice .

    Regards,
    Shufil
     
  4. EThSupport24

    EThSupport24 Registered

    Joined:
    Jun 21, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,

    Upgrade Mysql through WHM , Home » Software » MySQL Upgrade and follow the instructions. At the end you will see option for PHP compilation that is EasyApche just select it and proceed with the upgrade.

    If you still facing same errors, run /scripts/easyapache on the shell.

    Thanks,

    EthSupport
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  6. shufil

    shufil Well-Known Member

    Joined:
    Mar 19, 2014
    Messages:
    71
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello,

    Thanks , Thanks for support , :) .

    may be its not happen , by chance If my new mysql vertion not support current DB, so what we do that situvation .

    Regards,
    Shufil
     
  7. SS-Maddy

    SS-Maddy Well-Known Member

    Joined:
    Mar 28, 2009
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    The "500 Iternal server Error" is webserver error and checking the apache logs will be more helpful. MySQL version change won't affect the functionality of existing DBs. The issue looks to be related with php mysql extension. Please make a php recompile with updated mysql extension and check. You may check mysql log file for any possible db issues through /var/lib/mysql/server_name.err
     
Loading...

Share This Page