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.

How safe is it to upgrade MySQL to 4.1+ from 4.0.25?

Discussion in 'General Discussion' started by electron33, Mar 31, 2006.

  1. electron33

    electron33 Well-Known Member

    Joined:
    Feb 24, 2004
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    16
    I've read other threads about upgradeing MySQL 4.0.25 to 4.1+, but they are not very informative.

    I'm running 4.0.25 on CentOS 4 (WHM 10.8.0 cPanel 10.8.1-R113 , and I'd appreciate if anyone can share their experience with me:

    1. Is is safe to upgrade upgrade to 4.1+? Would it cause any problems with existing databases?

    2. What is the latest version supported

    3. Is there a way to do it via WHM or /scripts?

    Thanks for your help.
     
  2. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United Kingdom
    I was in the same situation as you, and after reading a lot of posts I gave it a go. Installation went fine, however it completely messed up passwords on our billing system, even with the "use old password" feature enabled.

    Because of this I just went back to 4.0.25.

    On the Release tree you will get MySQL 4.1.14
     
  3. electron33

    electron33 Well-Known Member

    Joined:
    Feb 24, 2004
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    16
    Thanks Celliott. So, I could end up screwing up my server :-(
     
    #3 electron33, Mar 31, 2006
    Last edited: Mar 31, 2006
  4. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United Kingdom
    You could always give it a go, make a backup of all your databases first.

    Do this by making a copy or archiving /var/lib/mysql

    Then its just a case of changing the version in cpanel tweak settings, wait 30 sec, click update and then recompile apache. Should anything go wrong, change version to 4.0 and update again. Then delete /var/lib/mysql and replace it with the copy you backed up earlier.

    I have been looking into the password issue and it seems a line can just be added into the server my.cnf. I will have another attempt later on tonight as there will be less visitors, or in theory at least.

    If you want to give it a go and need any help, just send me a PM and I will be happy to help.
     
    #4 celliott, Mar 31, 2006
    Last edited: Mar 31, 2006
  5. trhosting.net

    trhosting.net Well-Known Member

    Joined:
    Mar 7, 2006
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Turkey
    Mysql 4.1.x is very different from 4.0.x.
    It stores all databases in utf8 format and you have to make characterset settings after you connect to mysql.

    I transfered to 4.1 but i want to go back to 4.0.
    It seems not possible now because i have a lot of databases.

    Conclusion:
    If you like 4.0 and you have no problem with it, don't upgrade to 4.1 :)
     
  6. electron33

    electron33 Well-Known Member

    Joined:
    Feb 24, 2004
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    16
    Let's assume I must upgrade to 4.1+ (customer requests).
     
  7. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    You could buy a phone support session at http://www.cpanel.net/store/ and have a tech do it for you live so any issues could be addressed as they arise.
     
  8. electron33

    electron33 Well-Known Member

    Joined:
    Feb 24, 2004
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    16
    Just out of interest, what is the rate for phone support?
     
  9. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    Phone support is $65 per incident. Not sure what an 'incident' covers though.
     
  10. abubin

    abubin Well-Known Member

    Joined:
    Dec 7, 2004
    Messages:
    393
    Likes Received:
    1
    Trophy Points:
    18
    the main problem you will face with 4.0 to 4.1 is the new password system. But this problem is well documented in a lot of websites. You can just google for the solution and even on mysql site, there are well written solutions.

    Other than that...not much other problems. Shouldn't be too big a problem for a normal server admin to work it out. If someone as noob as me can solve them, I am sure most other admins can do it.
     
  11. cygnuzz

    cygnuzz Member

    Joined:
    Jan 25, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    I'm using Centos also for my CPanel server. If I tick options for CPanel updates in Main - Server Configuration - Update Config, and choose Automatic updates for all, will mysql also updated automatically? Is it wise to automatically all updates?
     
  12. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United Kingdom
    No. You need to specify the MySQL version in "Tweak Settings" if you want the 4.1 tree. For the moment cPanel updates will only give you MySQL 4.0.25

    From my experience I would also advise to turn off automatic updates. Since if anything is broken in a update, you can always wait for a fix or solution before updating your server.
     
Loading...

Share This Page