Downgrade Mysql from 5 to 4

awillys · Unread post by **awillys** » Mon Sep 11, 2006 2:11 pm

Hi there,

Server: FC 4 with Plesk 8, apache 2, php 5, mysql5

How can i possibly downgrade Mysql from 5 to 4 because with mysql 5 i have broken my PSA install :/
I want to do it without loosing the data from my DBs

Any advise would be much appreciated.

Cheers,
Antonio

breun · Unread post by **breun** » Tue Sep 12, 2006 4:02 am

How did you install MySQL 5 (rpms from mysql.com? from source?)? Plesk is not compatible with MySQL 5 yet.

awillys · Unread post by **awillys** » Tue Sep 12, 2006 5:10 am

RPM from Remi repository :/
I was just trying to upgrade php from 4 to 5 and it also upgraded mysql...

breun · Unread post by **breun** » Tue Sep 12, 2006 6:04 am

I think the only PHP and MySQL upgrades that play nice with Plesk are to be found here, althought I don't know Remi's repository really. I'd download your distribution's latest php and mysql rpms and rpm -Uvh --oldpackage them.

Unread post by **scott** » Tue Sep 12, 2006 9:55 am

yeah I don't know that one either, assuming you havent had any database activity under 5.0 (no inserts, etc), it should be OK. If you have made updates to the DB, theres a good chance that it won't be compatible with a 4.1 box any more, so you'll need to do an SQL dump, and restore

awillys · Unread post by **awillys** » Tue Sep 12, 2006 6:37 pm

Thanks for th tip.
How do i deal with the dependencies though?

because i got think like:
Retrieving ftp://ftp.univie.ac.at/systems/linux/fe ... 0.i386.rpm
error: Failed dependencies:
php = 5.1.6-2.fc4.remi is needed by (installed) php-pdo-5.1.6-2.fc4.remi.i386
php = 5.1.6-2.fc4.remi is needed by (installed) php-gd-5.1.6-2.fc4.remi.i386
php >= 5.1.0-1 is needed by (installed) php-pear-1.4.11-2.fc4.remi.noarch
php = 5.1.6-2.fc4.remi is needed by (installed) php-mysql-5.1.6-2.fc4.remi.i386
php = 5.1.6-2.fc4.remi is needed by (installed) php-xml-5.1.6-2.fc4.remi.i386
php = 5.1.6-2.fc4.remi is needed by (installed) php-imap-5.1.6-2.fc4.remi.i386
php = 5.1.6-2.fc4.remi is needed by (installed) php-mbstring-5.1.6-2.fc4.remi.i386
php = 5.1.6-2.fc4.remi is needed by (installed) php-ldap-5.1.6-2.fc4.remi.i386
php = 5.1.6-2.fc4.remi is needed by (installed) php-pgsql-5.1.6-2.fc4.remi.i386
php-common = 5.1.6-2.fc4.remi is needed by (installed) php-cli-5.1.6-2.fc4.remi.i386

any hint?

Thanks in advance.
Antonio

breun · Unread post by **breun** » Wed Sep 13, 2006 3:45 am

Download all of the rpms you want and install them all at once.