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.

No option to downgrade mysql version

Discussion in 'General Discussion' started by kre8web, Feb 9, 2010.

  1. kre8web

    kre8web Active Member

    Joined:
    Aug 11, 2004
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    1
    Im in Tweak settings and under the SQL section there is no option to change mysql version. The only options are...

    SQL
    When displaying disk usage in cPanel/WHM include Postgresql and MySQL® disk usage. [Requires MySQL® 5+] (SQL disk usage is only updated every four hours)
    Use old style (4.0) passwords with MySQL® 4.1+ (required if you have problems with PHP apps authenticating)

    Where do i find the option to change mysql versions?

    Thankyou in advance :)

    NVM, i see it, it has its own Mysql upgrade section :)
     
    #1 kre8web, Feb 9, 2010
    Last edited: Feb 9, 2010
  2. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Upgrading to a new MySQL major version (e.g., from 4.0 to 4.1 to 5.0 to 5.1) is now moved into a new MySQL Upgrade tool and is accessible via the following menu path:
    WHM: Main >> Software >> MySQL Upgrade

    I recommend reviewing the official cPanel Release Notes for cPanel 11.25 that details further information about the new MySQL Upgrade tool as well as other new features, fixes, and enhancements.
     
  3. forlinuxsupport

    forlinuxsupport Well-Known Member
    PartnerNOC

    Joined:
    Dec 22, 2004
    Messages:
    386
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    downgrade

    You can downgrade mysql or change version by doing this :

    vi /var/cpanel/cpanel.config

    Change the line
    mysql-version=

    to 4.0 or 4.1 or 5.0

    Now run :
    /scripts/mysqlup --force

    Now re-run apache build (easyapache) - so it can build php-mysql connector
    /scripts/easyapache
     
  4. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    The method described would be performed at one's own risk. A manual downgrade is not recommended and can incur significant risk when attempted on an existing system. A full backup of the MySQL data directory is advised, and for a proper downgrade one should consider using mysqldump to create an SQL dump before downgrading.

    Please ensure to thoroughly read the official MySQL documentation regarding downgrades:
    MySQL :: MySQL 5.1 Reference Manual :: 2.4.2 Downgrading MySQL
    MySQL :: MySQL 5.0 Reference Manual :: 2.18.2 Downgrading MySQL
    MySQL :: MySQL 3.23, 4.0, 4.1 Reference Manual :: 2.11.2 Downgrading MySQL
     
Loading...

Share This Page