500PTS!! Help With Upgrading Upgrading Using RPM

Hello All,

    I am having a Problem Using the RPM in Red hat. I have Mysql Installed and want to upgrade to a newer rev. Problem is that when i do a RPM -e to remove the OLD version, it complains about dependicies...What do i do in a case like this??

Or when there are dependicies for any other RPM??

JohnysteaksAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

paullamhkgCommented:
Have you try rpm -Uvh to do the upgrade?

I personally don't like to use the RPM because of the dependencies, I always upgrade my mysql using the BINARY code, the procedure is very easy as below :


     shell> groupadd mysql
     shell> useradd -g mysql mysql
     shell> cd /usr/local
     shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
     shell> ln -s full-path-to-mysql-VERSION-OS mysql
     shell> cd mysql
     shell> scripts/mysql_install_db
     shell> chown -R root  .
     shell> chown -R mysql data
     shell> chgrp -R mysql .
     shell> bin/safe_mysqld --user=mysql &
     or
     shell> bin/mysqld_safe --user=mysql &
     if you are running MySQL 4.x

and put the /mysql/bin/mysql into /usr/bin that's it.

have a check here for more info on using the mysql rpm http://www.mysql.com/doc/en/Linux-RPM.html

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
himallickCommented:
To remove an update and revert to the original version of your
software, locate your original RPM package(s) and run the
command:

  rpm -Uvh --oldpackage OLD_RPM_NAME ...


So download old packages, and run the package upgrade
marko020397Commented:
You probably don't have only one MySQL rpm package installed. There are more MySQL-server, MySQL-client, MySQL-devel, MySQL-shared. Find out which RPM you have with "rpm -qa | grep MySQL". If you try to install new MySQL-server it won't install because MySQL-client needs previous version. First download all RPM you need. You have many options:

1. Upgrade all packages: run where you have downloaded new RPMS "rpm -Uvh MySQL*"
2. Uninstall everything except server then upgrade the server and install other packages.
3. Uninstall all MySQL packages and install the new ones.

Any option will do the job. The only thing you should be carefull is about versions. Some time ago the
server was named mysql.x.x.x.x.rpm and was then renamed to MySQL-server.x.x.x.x.rpm (x.x.x.x means
version). In this case it is best to uninstal MySQL completely and install it again.

If you are upgrading from a very old version you could have problems with database named "mysql" because
there are many new permissions in newer versions and database "mysql" is different.

All databases will remain intact during upgrade/install/uninstall. Except database "mysql" in some cases.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux

From novice to tech pro — start learning today.