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.

Upgrading To MySQL 4.1

Discussion in 'General Discussion' started by derekivey, Nov 30, 2005.

  1. derekivey

    derekivey Well-Known Member

    Joined:
    Nov 30, 2004
    Messages:
    50
    Likes Received:
    0
    Trophy Points:
    6
    Hi all,

    We are currently running MySQL 4.0.25, and want to upgrade to MySQL 4.1, but would like to know if we will experiance any problems with the databases while upgrading. Has anyone had any problems upgrading? I did a search on the forums, but couldn't find much.

    Thanks,
    Derek
     
  2. PvUtrix

    PvUtrix Well-Known Member

    Joined:
    Mar 12, 2005
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Ekaterinburg - Russia
    cPanel Access Level:
    Root Administrator
    Give google a try... :)

    2 things you should keep in mind

    1) 4.1 uses a different hashing method for user passwords (old_passwords takes care of that in my.cnf)

    2) each database, table and field will have their own encoding now...
     
  3. derekivey

    derekivey Well-Known Member

    Joined:
    Nov 30, 2004
    Messages:
    50
    Likes Received:
    0
    Trophy Points:
    6
    Ok, Thank You! :)
     
  4. derekivey

    derekivey Well-Known Member

    Joined:
    Nov 30, 2004
    Messages:
    50
    Likes Received:
    0
    Trophy Points:
    6
    One more question, would it be easy to go back to MySQL 4.0.25 if we have problems?

    Thanks,
    Derek
     
  5. cbwass

    cbwass Well-Known Member

    Joined:
    Mar 29, 2002
    Messages:
    148
    Likes Received:
    0
    Trophy Points:
    16
    Beware.
    If any database has used accents (ñ.á,í) in table, column or user names they will not work in 4.1.
    You can't go back to 4.0, it breaks all databases.
    See MySQL site for more info.
     
  6. MMarko

    MMarko Well-Known Member

    Joined:
    Apr 18, 2005
    Messages:
    316
    Likes Received:
    0
    Trophy Points:
    16
    There are a lot of topics covering this issue. Just use search.
     
  7. ShockHosts

    ShockHosts Well-Known Member

    Joined:
    Nov 25, 2005
    Messages:
    123
    Likes Received:
    0
    Trophy Points:
    16
    I did this without any research and it caused some problems...

    But I just kept playing around and it worked! :P So I don't know what fixed it.

    But backup your DB's before doing it...
     
Loading...

Share This Page