[mythtv-users] OT: Upgrade to Mysql 5.0

Mon May 1 18:50:10 UTC 2006

You've got 3 options:

1) Remove MySQL 4.1 (i'm guessing you're on a RedHat distribution given the
file places, could be wrong).  You can use RPM directly to try to uninstall
MySQL and all it's dependent packages or you can try going into xwindows and
to the package manager there (add-remove programs if you're in a recent
version of gnome) and remove MySQL from there.

2) Try Upgrading MySQL 4.1 to 5.X in place using RPM, Yum, etc. I don't have
a whole lot of experience here, but technically if you have all the packages
you need in the same directory when you do the upgrade the RPM system SHOULD
be able to figure out a way around it's dependencies to get everything
installed.  With some packages (don't know about MySQL) typically you're
reduced to upgrading half your operating system to get it to work in this
way.  You might try to simply yum install the MySQL5 package and see what
happens, who knows, this might be the easiest.

3) Work "around" the currently installed MySQL.  Doing this requires you to
do a few things:

* use chkconfig to remove mysqld from the boot up process (optional, see
steps at end for modifying mysqld to start your new MySQL istallation at
boot, if you wish to do so then don't do this.)
* Install the New MySQL version into a new place (I like /opt as it contains
all the packages you've upgraded and /usr/local just gets CROUDED with
crap), using either binaries or a code distribution (i've used both, both
arn't too terribly difficult to put in place).
* **IMPORTANT** add </installdirectory/bin> (e.g. /opt/mysql5/bin) to your
PATH BEFORE any of the standard binaries paths (/usr/bin, /bin, /sbin,
/usr/sbin, etc.)
* Modify your mysqld file in /etc/init.d (or whatever bootup file you're
using to start safe_mysqld) to point to the new safe_mysqld binary.

What all of this should do is to put the MySQL 5 installation AHEAD of the
MySQL 4.1 installation.  Any time you run a MySQL command (mysql,
mysqladmin, safe_mysqld, etc.) it should pick up the 5.x versions BEFORE the
4.x versions due to your path setting.

Can't tell you how many times i've done this on RedHat/Fedora/Mandrake/etc.
systems that use package managers.  It's just easier to work around the
package managers than to try to work with them...when removing Samba starts
complaining about dependencies in the base X Windows libraries, it's time
you decide either to install the new version of Fedora to upgrade your samba
(which is stupid) or start figuring out how you can "obsolete" the RPMs that
were previously installed, the above is the trick to doing so.  Typically I
have an installation rule:  If i'm not interested in updateing the package
when the operating system maintainer (redhat, mandrake, debian, etc.)
decides it should be updated, or if I feel i'll want to update it more
frequently than the os maintainer (cause we all know debian and redhat do
SUCH a good job of keeping their systems up to date with the most recent set
of code...) I simply DO NOT install that package during system installation
time, and I use tar.gz's or binary distributions to keep the system up to
date on my schedule.

GL to you, working with the package managers of Linux are much harder than
you'd think it would be.

--Douglas Wagner

On 5/1/06, Tom Lichti <tom at redpepperracing.com> wrote:
>
> 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
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060501/71a9ff25/attachment.htm 