Page 1 of 1
Downgrade Mysql from 5 to 4
Posted: Mon Sep 11, 2006 2:11 pm
by awillys
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
Posted: Tue Sep 12, 2006 4:02 am
by breun
How did you install MySQL 5 (rpms from mysql.com? from source?)? Plesk is not compatible with MySQL 5 yet.
Posted: Tue Sep 12, 2006 5:10 am
by awillys
RPM from Remi repository :/
I was just trying to upgrade php from 4 to 5 and it also upgraded mysql...
Posted: Tue Sep 12, 2006 6:04 am
by breun
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.
Posted: Tue Sep 12, 2006 9:55 am
by scott
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
Posted: Tue Sep 12, 2006 6:37 pm
by awillys
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
Posted: Wed Sep 13, 2006 3:45 am
by breun
Download all of the rpms you want and install them all at once.