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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

New Server - MySQL5 vs. Migrating MySQL4 accounts

Discussion in 'General Discussion' started by mrcbrown, Jan 12, 2008.

  1. mrcbrown

    mrcbrown Well-Known Member

    Joined:
    Jun 5, 2003
    Messages:
    100
    Likes Received:
    1
    Trophy Points:
    168
    Okay -

    I am just curious, I have been looking to migrate to MySQL5 for some time, and since I am in the middle of migrating to some new hardware in a new DC, I am just curious if there are any known issues in setting up the server to default to MySQL5 and Importing accounts from the old cPanel box which are using MySQL4?

    Just trying to lay out a bit of a game plan really, just figured I'd ask if anyone had any experience with and any problems I could/should expect - also if there are any webapps out there which are not friendly with MySQL5 for any reason.

    Any feedback/suggestions/insults about my cat - gladly welcomed!

    -CB
     
    #1 mrcbrown, Jan 12, 2008
  2. mrcbrown

    mrcbrown Well-Known Member

    Joined:
    Jun 5, 2003
    Messages:
    100
    Likes Received:
    1
    Trophy Points:
    168
    Update to my own post for anyone else curious - if you have MySQL4 backups and restore them to MySQL5 based machine it'll import fine, thus far with the test sites running things like Wordpress, Mint, etc. no issues, sites came over clean and working fine.
     
    #2 mrcbrown, Jan 13, 2008
  3. harpon

    harpon Active Member

    Joined:
    Aug 19, 2005
    Messages:
    31
    Likes Received:
    0
    Trophy Points:
    156
    migration

    I have to migrate 250+ accounts from a machine, that is getting a tad old, to a new machine so I can retire the old machine.

    I face the same problem, since i want to run MySql 5 on the new server and have MySql4 on the old box.

    Did you simply perform an import from the MySql5 WHM server and does it take care of the conversion?

    If you did have any issues afterwards, what should I look out for?

    Thanks for the post too. Reading it made me feel a little more confident about the migration of this particular machine.
     
    #3 harpon, Jun 23, 2008
(You must log in or sign up to post here.)
Loading...
Similar Threads - Server MySQL5 Migrating
  1. maverickws

    SOLVED MySQL56 conflicts with file from package MariaDB-server

    maverickws, Dec 13, 2017, in forum: Database Discussions
    Replies:
    6
    Views:
    486
    cPanelMichael
    Dec 14, 2017
  2. Nirjonadda

    You must reboot the server to apply software updates

    Nirjonadda, Apr 20, 2018 at 11:43 AM, in forum: General Discussion
    Replies:
    6
    Views:
    49
    Nirjonadda
    Apr 20, 2018 at 1:47 PM
  3. Bashed

    CBL Listing Due to "Spam Trap Servers"

    Bashed, Apr 19, 2018 at 3:30 PM, in forum: E-mail Discussions
    Replies:
    6
    Views:
    43
    cPanelLauren
    Apr 20, 2018 at 7:46 AM
  4. neuf007

    Migrating VPS to Dedicated Server question

    neuf007, Apr 19, 2018 at 6:46 AM, in forum: Data Protection
    Replies:
    2
    Views:
    38
    cPanelLauren
    Apr 19, 2018 at 11:18 AM
  5. Andi Demirxhiu1

    Server Error: UID STORE: Error in IMAP command UID STORE: Invalid uidset (0.001 + 0.000 secs).

    Andi Demirxhiu1, Apr 19, 2018 at 5:24 AM, in forum: E-mail Discussions
    Replies:
    4
    Views:
    225
    kritapas
    Apr 22, 2018 at 12:05 AM

Share This Page