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!

Questions on MySQL Server

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

  1. vlee

    vlee Well-Known Member

    Joined:
    Oct 13, 2005
    Messages:
    348
    Likes Received:
    23
    Trophy Points:
    168
    Location:
    Spokane, Washington
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. vlee

    vlee Well-Known Member

    Joined:
    Oct 13, 2005
    Messages:
    348
    Likes Received:
    23
    Trophy Points:
    168
    Location:
    Spokane, Washington
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,309
    Likes Received:
    393
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. vlee

    vlee Well-Known Member

    Joined:
    Oct 13, 2005
    Messages:
    348
    Likes Received:
    23
    Trophy Points:
    168
    Location:
    Spokane, Washington
    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.
     
    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