MySQL 4 and 5 on one machine....

[MethOd63]

Can someone tell me , how to do it ????
My Client's need's mysql 4 and 5 , but i don't know how i need to install this uppgrade.

Please help.

Thanks

[Zishan]

By default MySQL is installed at /var/lib/mysql path so using rpm it seems impossible to install two MySQL versions on the same server. However if you need two MySQL versions on the same server then you need to install one using RPM at default path /var/lib/mysql and the other need to be installed from source at any different path something like /var/lib/mysqlv4.

[goodmove]

By default MySQL is installed at /var/lib/mysql path so using rpm it seems impossible to install two MySQL versions on the same server. However if you need two MySQL versions on the same server then you need to install one using RPM at default path /var/lib/mysql and the other need to be installed from source at any different path something like /var/lib/mysqlv4.

How would you then allocate a database to run under v4 (assuming it was installed in /var/lib/mysqlv4)?

[Zishan]

How would you then allocate a database to run under v4 (assuming it was installed in /var/lib/mysqlv4)?

Depends that in which version database was created. Definitely both will not be managed by cPanel so if v4 need to be used then the databases need to be created from command line. While compiling v4 from source, path for bin files can also be defined to avoid conflict/overriding of other mysql binaries. Lets say mysql4 binaries are installed at /usr/bin/mysql4/ path. Database in MySQL5 can be created from cpanel and in MySQL4 from command line as:

/usr/bin/mysql4/mysqladmin -uroot -p create database_name