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 Udapte

Discussion in 'General Discussion' started by rorobobo, Jun 29, 2006.

  1. rorobobo

    rorobobo Active Member

    Joined:
    Dec 9, 2005
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    Currently my virtual server has Mysql 4.0.27 and I want to udapte Mysql.

    Can you help me ?

    Regards
     
  2. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    To which version are you looking to upgrade?
     
  3. rorobobo

    rorobobo Active Member

    Joined:
    Dec 9, 2005
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    Mysql 4.1.19 or later
     
  4. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    Select the relevant option in WHM > Tweak settings.

    Just make sure you double backup all databases before upgrading - dump all data and copy the entire contents of /var/lib/mysql. Reverting from 4.1 to 4.0 is a messy process!

    Once MySQL has been upgraded, recompile Apache/PHP to get MySQL support working in PHP scripts.

    You should expect around 30 minutes downtime across various services (as MySQL is upgraded and then Apache/PHP is rebuilt), so perform the upgrade at a quiet time.
     
  5. rorobobo

    rorobobo Active Member

    Joined:
    Dec 9, 2005
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    Hello

    I can this, but after :

    Internal Server Error
    The server encountered an internal error or misconfiguration and was unable to complete your request.

    Please contact the server administrator, webmaster@ and inform them of the time the error occurred, and anything you might have done that may have caused the error.

    More information about this error may be available in the server error log.

    Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

    Can you help me ?
     
  6. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    What did you do that caused this to happen?

    Did you upgrade MySQL and rebuild Apache and rebuild PHP as well? Things won't work without Apache and PHP being rebuilt.
     
  7. rorobobo

    rorobobo Active Member

    Joined:
    Dec 9, 2005
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    In Tweak Setting : Mysql : I click on 4.1 and save and after :

    Internal Server Error
    The server encountered an internal error or misconfiguration and was unable to complete your request.

    Please contact the server administrator, webmaster@ and inform them of the time the error occurred, and anything you might have done that may have caused the error.

    More information about this error may be available in the server error log.

    Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

    I stop this problem, in tweak setting : Mysql : I re-click on 4 and save and now it's works fine but it's Mysql 4.0.27

    What's the problem ?
     
  8. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    Where are you seeing that internal server error (specific details really help!)

    Do you see it in WHM or do you see it when trying to view hosting webpages that use PHP/MySQL?
     
  9. rorobobo

    rorobobo Active Member

    Joined:
    Dec 9, 2005
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    I see in website that use PHP/MySQL.
     
  10. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    As I mentioned, after upgrading MySQL you must rebuilt Apache and PHP.

    If you do so, it will work. If you don't, it won't.

    You might then need to restart MySQL.
     
  11. rorobobo

    rorobobo Active Member

    Joined:
    Dec 9, 2005
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    Can you make HOW TO, to rebuilt Apache and PHP ?

    I can rebuilt Apache and PHP in WHM ?
     
  12. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    Not really - this topic has been covered plenty of times already. Just search the forums.

    Hint: WHM > Update Apache

    Ensure you know what you're doing before you proceed. If in doubt, contact cPanel support.

    Yes, as above.
     
  13. rorobobo

    rorobobo Active Member

    Joined:
    Dec 9, 2005
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    I don't want to have a problem after in my virtual server.

    You can make udapte Mysql and rebuilt Apache and PHP and how many cost ?
     
  14. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    Sorry, I don't offer those sort of services.

    cPanel support should be able to do it for you free of charge, so long as you've purchased your cPanel licence direct from them.

    Other than that, you'd have to find a professional to help you. I believe Andy Reed (servertune.com) offers such services at reasonable prices.

    However it's really really straightforward. In WHM > Update Apache just select the options you need and away you go. If you're not sure what to select, choose 'Load previous config' and then start the build.
     
Loading...

Share This Page