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
     
    #1 promesashost, Jun 19, 2014
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    36,436
    Likes Received:
    1,215
    Trophy Points:
    363
    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.
     
    #2 cPanelMichael, Jun 20, 2014
  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
     
    #3 shufil, Jun 24, 2014
  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
     
    #4 EThSupport24, Jun 24, 2014
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    36,436
    Likes Received:
    1,215
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Yes, it's advised to upgrade MySQL directly through Web Host Manager:

    "WHM Home » Software » MySQL Upgrade"

    Thank you.
     
    #5 cPanelMichael, Jun 24, 2014
  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
     
    #6 shufil, Jun 25, 2014
  7. SS-Maddy

    SS-Maddy Well-Known Member

    Joined:
    Mar 28, 2009
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    56
    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
     
    #7 SS-Maddy, Jun 25, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - Mysql upgrade error
  1. MyDreamscape

    Error MySQL/MariaDB Upgrade (5.6 to 10.0) step 4

    MyDreamscape, Sep 29, 2016, in forum: Database Discussions
    Replies:
    4
    Views:
    779
    cPanelMichael
    Oct 6, 2016
  2. DPNmw

    Cpanel/Whm 56.0 - Mysql 5.5 upgrade error

    DPNmw, Jun 18, 2016, in forum: Database Discussions
    Replies:
    4
    Views:
    832
    cPanelMichael
    Jun 21, 2016
  3. arjanvr

    upgrade mysql

    arjanvr, Apr 4, 2017, in forum: Database Discussions
    Replies:
    11
    Views:
    308
    cPanelMichael
    Apr 6, 2017
  4. anseme

    SOLVED Upgrade EasyApache first before upgrading Mysql?

    anseme, Jan 6, 2017, in forum: EasyApache
    Replies:
    2
    Views:
    349
    anseme
    Jan 7, 2017
  5. tamalero

    SOLVED Mysql 5.5 to 5.6 Upgrade issue

    tamalero, Nov 30, 2016, in forum: General Discussion
    Replies:
    8
    Views:
    867
    tamalero
    Dec 21, 2016

Share This Page