Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Upgrading to MySQL 4.1x

Discussion in 'General Discussion' started by celliott, Feb 28, 2006.

  1. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    United Kingdom
    I am tempted to make the upgrade to MySQL 4.1 since a few customers have requested it, and it also includes added functionality for them. The procedure looks nice and straightforward after reading a quick guide however I am wondering what will happen to all the existing databases.

    There are currently at least 50 databases on my server which have all been used with MySQL 4.0.25, the cpanel default. When I upgrade to 4.1 will they still work, are there likely to be any problems?

    Any advise appreciated on this.

    Thanks
     
    #1 celliott, Feb 28, 2006
    Last edited: Feb 28, 2006
  2. rustelekom

    rustelekom Well-Known Member
    PartnerNOC

    Joined:
    Nov 13, 2003
    Messages:
    290
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    moscow
    should be work okay if you just upgrade Mysql by cpanel upgrade option. But there is may happen issue. Especially in multilanguage environment. Mostly for collation and charset new features. Some older scripts (include commercial software) also can do not work correct. Another big problem is incompatibiltes with old mysql password system (you should enable old-password option when you will upgrade mysql). I can't recommend you this upgrade just becuase mysql 4.1 already is not mainstream version (current GA version is MySQL 5.0). I think will be better just wait further updates from MySQL. For user which anyway would like use MySQL 4.1 you may install it in different location and give to them access. But you will need do this manually.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    United Kingdom
    So the existing databases created in MySQL 4.0 should work without needing modifications on MySQL 4.1?
     
  4. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    166
    It's often advised that you backup 4.0 databases before upgrading to 4.1, asyour databases will no longer be compatible if you downgrade back to 4.0.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    United Kingdom
    What is the best method of backing up all databases?
     
  6. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    166
    Since it's the format of the database files you are interested in preserving, instead of just the data, a copy of all that is in /var/lib/mysql may do the trick.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,460
    Likes Received:
    21
    Trophy Points:
    463
    Location:
    Go on, have a guess
    That's a good idea. However, if you do do that, be sure to stop chkservd and mysql before backing up those files otherwise you can be left with either corrupt or incomplete databases.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice