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 4.1.22 to Mysql 5.x

Discussion in 'General Discussion' started by Tymsah, Dec 8, 2008.

  1. Tymsah

    Tymsah Well-Known Member

    Joined:
    Apr 6, 2007
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hi,

    How can i upgrade mysql 4.1.22 to mysql 5.x

    i dont want to lost customer database or table data ?

    Regards,
    Tymsah
     
  2. MattDees

    MattDees cPanel Product Owner
    Staff Member

    Joined:
    Apr 29, 2005
    Messages:
    417
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    This can be upgraded from within tweak settings in WHM.

    I would advise running a full backup first just in case.
     
  3. Stephen

    Stephen Active Member

    Joined:
    Aug 14, 2001
    Messages:
    39
    Likes Received:
    1
    Trophy Points:
    8
    I upgraded MySQL on a few servers running MySQL4.1.22 to MySQL5. The upgrade through "tweak settings" was seamless, no problems what so ever.

    To be safe, I did not do the full backup but I backup the mysql folder instead:

    cd /var/lib
    tar zcf mysql.tgz mysql

    => then set the mysql5 setting in "tweak settings"
     
  4. Tymsah

    Tymsah Well-Known Member

    Joined:
    Apr 6, 2007
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Thank you for all
    i will try now upgrade mysql server.

    Regards,
    Tym
     
  5. Tymsah

    Tymsah Well-Known Member

    Joined:
    Apr 6, 2007
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hi,

    Today upgrade Mysql 4.1.22 to Mysql 5.0.51a-community without errors and lost data.


    Thank you for all
    Regards,
    Tymsah
     
  6. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,460
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    When migrating between different versions of MySQL, making a copy of the database files can be insufficient as the on-disk format may have changed. The proper way to perform a database backup is, and likely always will be, to DUMP the data into an external file ( or several files ).
     
Loading...

Share This Page