Downgrade MySQL 5 to MySQL 4.1 on cPanel dedicated server
For some reason you need to downgrade MySQL 5 to MySQL 4.1 to achieve this you will have to do the following:
To check the which all mysql rpm’s are available use the command:
rpm -qa | grep -i mysql-
First of all take a backup of /var/lib/mysql, and also ask the other users to keep a backup it with them. This can also be a .sql file. The command to take a backup is:
cp /var/lib/mysql /var/lib/mysql.bk
Now, you will have to edit the cPanel config file and make manual changes under this, so edit it with the command:
nano /var/cpanel/cpanel.config
And here, find for the line “mysql-version=5.0” and change it to “mysql-version=4.1”
Now, we will forcefully install mysql by the following command:
/scripts/mysqlup --force
You can now check again with the command:
rpm -qa | grep -i mysql-
This is done and worked for me.
引用:
降級MySQL的5到MySQL 4.1的cPanel專用服務器
For some reason you need to downgrade MySQL 5 to MySQL 4.1 to achieve this you will have to do the following:出於某種原因,您需要降級MySQL的5至MySQL 4.1中實現這一目標,您必須做到以下幾點:
To check the which all mysql rpm’s are available use the command:要檢查所有的MySQL轉速的,可使用命令:
rpm -qa | grep -i mysql-轉速基地| grep按我的MySQL -
First of all take a backup of /var/lib/mysql, and also ask the other users to keep a backup it with them.首先採取的備份到/ var / lib / MySQL的,同時也要求其他用戶隨時備份攜帶。 This can also be a .sql file.這也可以是。數據庫文件。 The command to take a backup is:命令採取的備份是:
cp /var/lib/mysql /var/lib/mysql.bk處長到/ var / lib / MySQL的是/ var / lib / mysql.bk
Now, you will have to edit the cPanel config file and make manual changes under this, so edit it with the command:現在,你將不得不修改的cPanel配置文件,並根據本手冊的變化,以便對其進行修改的命令:
nano /var/cpanel/cpanel.config納米/無功/的cPanel / cpanel.config
And here, find for the line “ mysql-version=5.0 ” and change it to “ mysql-version=4.1 ”在這裡,找到了線“ 的MySQL版本= 5.0 ” ,並更改為“ MySQL的版本= 4.1 ”
Now, we will forcefully install mysql by the following command:現在,我們將有力地安裝的MySQL由以下命令:
/scripts/mysqlup --force /腳本/ mysqlup -武力
You can now check again with the command:現在,您可以再次檢查的命令:
rpm -qa | grep -i mysql-轉速基地| grep按我的MySQL -
This is done and worked for me.這樣做是為我工作。
Let us know if this has helped you and have any suggestions on this.讓我們知道這有助於你和有任何的建議。