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!

Upgrade from MySQL4 to MySQL5. Will my scripts stop working?

Discussion in 'General Discussion' started by SuperBaby, Jun 19, 2009.

  1. SuperBaby

    SuperBaby Well-Known Member

    Joined:
    Nov 27, 2003
    Messages:
    336
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Thailand
    cPanel Access Level:
    Website Owner
    Twitter:
    I am currently running PHP 5.2.9 but I am still using MySQL4. I am running a lot of Perl and PHP scripts (that use MySQL database) in my websites. I would like to upgrade to MySQL5 but I worry that my scripts will stop working. Will my scripts stop functioning?

    After upgrading and if there are problems, can I switch back to MySQL4?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 SuperBaby, Jun 19, 2009
  2. InstaCarma_Tech

    InstaCarma_Tech Well-Known Member

    Joined:
    Apr 22, 2009
    Messages:
    228
    Likes Received:
    1
    Trophy Points:
    68
    Stop the MySQL service and take a backup of all your databases first. Then you can upgrade the MySQL . Note that you will have to recompile PHP after the upgrade.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 InstaCarma_Tech, Jun 20, 2009
  3. SuperBaby

    SuperBaby Well-Known Member

    Joined:
    Nov 27, 2003
    Messages:
    336
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Thailand
    cPanel Access Level:
    Website Owner
    Twitter:
    Thanks for the advice. But do you think it is likely my scripts will give problems after upgrading?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 SuperBaby, Jun 20, 2009
  4. pjman

    pjman Well-Known Member

    Joined:
    Mar 22, 2003
    Messages:
    101
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    New York
    Should be safe.

    I had the same predicament last year. Should I upgrade MYSQL from 4.0.x to 5, when I had to upgrade PHP to 5? I chose to keep MYSQL 4.0x. I'm about to upgrade next week. From all my research, I here that the jump to MYSQL 4.1x is a pain, but very do-able. And the leap to MYSQL 5, is easy.

    I haven't heard anyone report big problems with any scripts of any kind when moving to MYSQL to 5. If you hear anything, I would love to know.

    Good Luck....
     
    #4 pjman, Jun 22, 2009
  5. PlatinumServerM

    PlatinumServerM Well-Known Member
    PartnerNOC

    Joined:
    Jul 10, 2005
    Messages:
    400
    Likes Received:
    3
    Trophy Points:
    168
    Location:
    New Jersey, USA
    cPanel Access Level:
    Root Administrator
    Upgrading from mysql4 to mysql5 sometimes does cause problems with existing databases/scripts. Sometimes it goes smoother than others. Always make full backups just in case and you should be fine if something goes wrong.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 PlatinumServerM, Jun 22, 2009
  6. UBERHOST

    UBERHOST Well-Known Member

    Joined:
    Jan 13, 2008
    Messages:
    102
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    California, US
    Adding to all of the above, I'd say that if you have scripts so outdated that they would be broken by upgrading MySQL, such scripts pose a security hazard to your server.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 UBERHOST, Jun 22, 2009
(You must log in or sign up to post here.)
Loading...
Similar Threads - Upgrade MySQL4 MySQL5
  1. joanatanasoff314

    WHM Upgrade Inquiry

    joanatanasoff314, Aug 17, 2018 at 2:26 PM, in forum: User Experience
    Replies:
    5
    Views:
    28
    cPanelMichael
    Aug 17, 2018 at 4:01 PM
  2. Angel Castro

    SOLVED upgrade to latest version whm

    Angel Castro, Aug 15, 2018 at 11:28 AM, in forum: General Discussion
    Replies:
    2
    Views:
    49
    Angel Castro
    Aug 15, 2018 at 2:08 PM
  3. sozotech

    SOLVED WHMCS integration problem after upgrade to 74

    sozotech, Aug 14, 2018 at 8:23 AM, in forum: General Discussion
    Replies:
    7
    Views:
    200
    sozotech
    Aug 14, 2018 at 2:35 PM
  4. Raj Janorkar

    Not able to upgrade from 70 to 74

    Raj Janorkar, Aug 11, 2018, in forum: General Discussion
    Replies:
    7
    Views:
    65
    cPanelLauren
    Aug 14, 2018 at 8:23 AM
  5. Caleb Anderson

    SOLVED Upgrade EA3 to EA4 Errors

    Caleb Anderson, Jul 24, 2018, in forum: EasyApache
    Replies:
    7
    Views:
    136
    cPanelMichael
    Aug 1, 2018

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.
    Accept Learn More...
    Dismiss Notice