Lik`s forum

[lik]

Downgrade MySQL 5 to MySQL 4.1 on cPanel dedicated server

For some reason (mainly, due to different syntax of GRANT) 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:

Code: Select all

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:

Code: Select all

cp /var/lib/mysql /var/lib/mysql.bk

It’s much better to do a mysqldump of your databases than to do a file restore of the databases. This dump can be properly restored into MySQL 4 or 5 (depending on features used) rather than having to totally rebuild MySQL to accommodate the flat file restore.
mysqldump compatibility mode
You can learn about it by reading

Code: Select all

mysqldump --help | less

--compatible=name

Change the dump to be compatible with a given mode. By
default tables are dumped in a format optimized for
MySQL. Legal modes are: ansi, mysql323, mysql40,
postgresql, oracle, mssql, db2, maxdb, no_key_options,
no_table_options, no_field_options. One can use several
modes separated by commas. Note: Requires MySQL server
version 4.1.0 or higher. This option is ignored with
earlier server versions.

Now, you will have to edit the cPanel config file and make manual changes under this, so edit it with the command:

Code: Select all

nano -w /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:

Code: Select all

/scripts/mysqlup --force

You can now check again with the command:

Code: Select all

rpm -qa | grep -i mysql-