Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Aug 2004
    Posts
    28

    Default No option to downgrade mysql version

    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
    Last edited by kre8web; 02-09-2010 at 06:54 PM.

  2. #2
    cPanel Quality Assurance Analyst cPanelDon's Avatar
    Join Date
    Nov 2008
    Location
    Houston, Texas, U.S.A.
    Posts
    2,555
    cPanel/Enkompass Access Level

    DataCenter Provider

    Default

    Quote Originally Posted by kre8web View Post
    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
    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. #3
    cPanel Partner NOC cPanel Partner NOC Badge
    Join Date
    Dec 2004
    Posts
    392

    Wink 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
    UK Managed Hosting
    UK Linux Support
    The information given above is intended to be advice only.

  4. #4
    cPanel Quality Assurance Analyst cPanelDon's Avatar
    Join Date
    Nov 2008
    Location
    Houston, Texas, U.S.A.
    Posts
    2,555
    cPanel/Enkompass Access Level

    DataCenter Provider

    Default

    Quote Originally Posted by forlinuxsupport View Post
    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
    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

Similar Threads & Tags
Similar threads

  1. downgrade mysql version from 5.0.51 to 5.0.45 due to bugs
    By mahinder in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 07-17-2008, 01:41 PM
  2. Downgrade WHM version
    By cool38 in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 08-01-2006, 05:21 PM
  3. Can't downgrade to PHP Version 4.3.9!
    By Guile in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 05-31-2005, 06:36 PM
  4. How to downgrade to prev. PHP version?
    By 3amp in forum New User Questions
    Replies: 4
    Last Post: 07-31-2004, 07:24 AM
  5. How downgrade to the stable version ?
    By allenhui in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 02-02-2004, 02:29 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube