[mythtv-users] OT: Upgrade to Mysql 5.0

[Tom Lichti]

R. G. Newbury wrote:
> 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
>
>   
Upgrade:
mod_auth_mysql
perl-DBD-MySQL
php-mysql
qt-MySQL
MySQL-python

at the same time as MySQL 5.

Tom