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.

How to downgrade back to MySQL 4.0.xx ?

Discussion in 'General Discussion' started by claven177, May 17, 2006.

  1. claven177

    claven177 Well-Known Member

    Joined:
    Sep 3, 2003
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Taipei
    I have order a new server : cpanel RE4

    Today, when I have transfer old server all accounts to this new server new server,
    I found the new server is MySQL 4.1.xx and my old server is MySQL 4.0.xx
    We use characters chinese code.
    How to downgrade back to MySQL 4.0.xx ?
    or

    Because cPanel 10.8.2-R83 only support MySQL 4.1.xx or latter.
    How to install WHM 10.8.0 cPanel 10.8.1-S114 on new server ?



    ========================================

    old server
    WHM 10.8.0 cPanel 10.8.1-S114
    RedHat 9 i686 - WHM X v3.1.0


    new server
    WHM 10.8.0 cPanel 10.8.2-R83
    RedHat Enterprise 4 i686 - WHM X v3.1.0


    Ref:
    ==============================
    http://forum.ev1servers.net/showthread.php?t=50261&highlight=mysql+4.1
    MySQL 4.1 stores table names and column names in UTF8. If you have table names or column names that use characters outside of the standard 7-bit US-ASCII range, you may have to do a mysqldump of your tables in MySQL 4.0 and restore them after upgrading to MySQL 4.1. The symptom for this problem is that you get a table not found error when trying to access your tables. In this case, you should be able to downgrade back to MySQL 4.0 and access your data.
    ==============================
     
  2. celliott

    celliott Well-Known Member

    Joined:
    Jan 2, 2006
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United Kingdom
    Its advisable that you run 4.1 on your servers, hence its now the default by cPanel. 4.0x is old and outdated.

    Just add the following in your my.cnf file and you should not have any problems:

    [mysqld]
    old-passwords

    Chris :)
     
  3. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    Login to WHM > Tweak settings > Mysql > select '4' instead of '4.1'.

    It is pretty much straightforward way to downgrade; and may well get you MySQL v4.0.25.

    The downgrade might not run smoothly, so be careful. Since this will change the version of MySQL server, you will need to backup your databases first, preferably in some standard SQL queried format and restore from these. In addition, be sure to stop chkservd and mysql before backing up your DBs, otherwise you can be left with either corrupt or incomplete databases.
     
  4. claven177

    claven177 Well-Known Member

    Joined:
    Sep 3, 2003
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Taipei

    Thanks

    In WHM 10.8.0 cPanel 10.8.2-R83
    RedHat Enterprise 4 i686 - WHM X v3.1.0

    I have read under Tweak settings in my WHM
    But it say Use old style (4.0) passwords with mySQL 4.1


    Is it real mySQL 4.0xx ?
    If I check the box in Use old style (4.0) passwords with mySQL 4.1,

    can I get real mysql 4.0xx ?




    =====================================
    MySQL

    MySQL Version to use (you must run Software/Update Server Software (or
    /scripts/mysqlup) for this to take affect. You should then run
    buildapache/easyapache after changing this option. You may also need to run
    /scripts/perlinstaller --force Bundle::DBD::mysql. Updating from a previous
    verion of MySQL to a later version is not automaticlly reversable. You should
    backup your databases if you think you might wish to downgrade in the future.
    5.0 4.1


    Use old style (4.0) passwords with mySQL 4.1 (required if you have problems
    with php apps authenticating)
     
  5. claven177

    claven177 Well-Known Member

    Joined:
    Sep 3, 2003
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Taipei


    Yes, you right.
    but

    I have check both server WHM > Tweak settings > Mysql
    old server : only MySQL 4 or 4.1 can be select
    new server : only MySQL 5.0 or 4.1 can be select ( without MySQL 4)


    Ref:
    =====================================
    ====in WHM 10.8.0 cPanel 10.8.1-S114

    MySQL 4 4.1

    MySQL Version to use (you must run Software/Update Server Software (or /scripts/mysqlup) for this to take affect. You should then run buildapache/easyapache after changing this option. You may also need to run /scripts/perlinstaller --force Bundle::DBD::mysql. Updating from mysql 4.0 to mysql 4.1 is not automaticlly reversable. You should backup your databases if you think you might wish to downgrade in the future.
    Use old style (4.0) passwords with mySQL 4.1 (required if you have problems with php apps authenticating)


    ====in WHM 10.8.0 cPanel 10.8.2-R83

    MySQL 5.0 4.1
    MySQL Version to use (you must run Software/Update Server Software (or /scripts/mysqlup) for this to take affect. You should then run buildapache/easyapache after changing this option. You may also need to run /scripts/perlinstaller --force Bundle::DBD::mysql. Updating from a previous verion of MySQL to a later version is not automaticlly reversable. You should backup your databases if you think you might wish to downgrade in the future.

    Use old style (4.0) passwords with mySQL 4.1 (required if you have problems with php apps authenticating)
     
    #5 claven177, May 18, 2006
    Last edited: May 18, 2006
  6. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    Since you need MySQL v4.0.x, downgrade the new server cPanel/WHM to an older version.

    This won't help you, since MySQL 4.1.x don't recognize or work with Chinese charset, unless you have a problem with apps authentication.
     
Loading...

Share This Page