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 4.0.27 to 4.1 or 5.0 to avoid charset issues?

Discussion in 'Database Discussions' started by expthep, Jan 18, 2014.

  1. expthep

    expthep Registered

    Joined:
    Dec 14, 2006
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    A client who is using MySQL v. 4.0.27 asked me to upgrade it and pay particular attention to charsets.

    Charset in all tables is latin1 and i was wondering if the upgrade would cause any problems with special characters (his website is in italian).

    Will the upgrade through WHM create the right charsets/collations or will it try to convert everything to utf-8?

    Should i first upgrade to 4.1 or is it safe to move to 5.0/ 5.1 ?

    Thanks
     
  2. Eric

    Eric Administrator
    Staff Member

    Joined:
    Nov 25, 2007
    Messages:
    746
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    Howdy,

    You would do best to do this in stages and make backups along the way.

    Thanks!
     
Loading...

Share This Page