Downgrade MySQL Version in cPanel




Note : cPanel do not encourage downgrading MySQL from version 5.5. to 5.1. Take all necessary
backup and do it on your own risk.

Check the MySQL version:

  root# mysqladmin --version

Replace the 5.5 MySQL version with 5.1 in “/var/cpanel/cpanel.config”

  root# sed -i 's/mysql-version=5.5/mysql-version=5.1/g' /var/cpanel/cpanel.configr

Run the following cPanel script :

  root# /scripts/check_cpanel_rpms –fix

Note : You will see “Error : Unknown table engine ‘PERFORMANCE_SCHEMA’” this is because 5.1 don’t have this table engine.

When the script completed the execution, check the version:

  root# mysqladmin --version


--

No comments:

Post a Comment