[mythtv-users] OT: Upgrade to Mysql 5.0

[R. G. Newbury]

Tom Lichti wrote:
> R. G. Newbury wrote:
>> I ma having a senior moment day I think.
>>
>> I want to upgrade to mysql 5.0 from 4.1. The installation instructions 
>> which come with the (binary-version) tar, just talk about un-'tar'ring 
>> the file in a chosen folder and then adding that folder to PATH.
>>
>> The existing installation has the executable mysql and mysqld(_safe) 
>> files in /usr/bin, and the libraries in /usr/lib..
>> There does not appear to be a particular folder containing all of the 
>> program parts.
>>
>> Anyone out there been through this and have any understanding of what 
>> should be done.
>>
>> Geoff
>>   
> Sounds like your original installation was done using an RPM (or DEB) 
> file. If so, I'd see if there are pre-packaged versions available.
> 
> Tom

The client installed from the rpm, with --force but the server fails 
with dependency issues.

[root at tor2 tar]# rpm -ivf --force ySQL-client-5.0.20a-0.glibc23.i386.rpm
Preparing packages for installation...
MySQL-client-5.0.20a-0.glibc23


[root at tor2 tar]# rpm -ivf --force ySQL-server-5.0.20a-0.glibc23.i386.rpm
error: Failed dependencies:
         MySQL conflicts with mysql-4.1.16-1.FC4.1.i386
         MySQL-server conflicts with mysql-server-4.1.16-1.FC4.1.i386

[root at tor2 tar]# rpm -U --force MySQL-server-5.0.20a-0.glibc23.i386.rpm
error: Failed dependencies:
         libmysqlclient.so.14 is needed by (installed) 
mod_auth_mysql-2.6.1-4.i386
         libmysqlclient.so.14 is needed by (installed) 
perl-DBD-MySQL-2.9007-1.i386
         libmysqlclient.so.14 is needed by (installed) 
php-mysql-5.0.4-10.5.i386
         libmysqlclient.so.14 is needed by (installed) 
qt-MySQL-3.3.5-11.4.fc4.kde.i386
         libmysqlclient_r.so.14 is needed by (installed) 
MySQL-python-1.2.0-1.i386


Any idea how I get around that?

Geoff