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.

Questions on MySQL Server

Discussion in 'Database Discussions' started by vlee, Jun 1, 2012.

  1. vlee

    vlee Well-Known Member

    Joined:
    Oct 13, 2005
    Messages:
    272
    Likes Received:
    6
    Trophy Points:
    18
    Location:
    Las Vegas, Nevada, United Stat
    cPanel Access Level:
    Root Administrator
    I am running on cPanel/WHM 11.32.2 (build 28)

    What is the difference between MySQL 5.1 and MySQL 5.5?

    Is it recommended to upgrade to MySQL 5.5?

    Is MySQL 5.5 safe to use without any issues to current websites?
     
  2. vlee

    vlee Well-Known Member

    Joined:
    Oct 13, 2005
    Messages:
    272
    Likes Received:
    6
    Trophy Points:
    18
    Location:
    Las Vegas, Nevada, United Stat
    cPanel Access Level:
    Root Administrator
    I have a response to my questions from my trusted cPanel friend.

    Certain version dependent queries in scripts [if any] shall not work if you upgrade the MySQL from 5.1 to 5.5. You may upgrade only if it is necessary and if there are no version dependent queries in your scripts. It is not possible to downgrade once you upgrade to 5.5.

    The following URL will be helpful to you.

    MySQL :: MySQL 5.5 Reference Manual :: 2.11.1.1 Upgrading from MySQL 5.1 to 5.5

    The end life for MySQL 5.1 is December 31, 2013 which is not that long from now so things need to be changed in the certain version dependent queries in scripts to work properly.

    Feel free to comment on this thread.
     
  3. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,468
    Likes Received:
    196
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
  4. vlee

    vlee Well-Known Member

    Joined:
    Oct 13, 2005
    Messages:
    272
    Likes Received:
    6
    Trophy Points:
    18
    Location:
    Las Vegas, Nevada, United Stat
    cPanel Access Level:
    Root Administrator
    I read all the others and I am going to test MySQL 5.5 on my cPanel test server and try everything out to if it breaks.
     
Loading...

Share This Page