View Single Post

   
  #2 (permalink)  
Old 03-07-2008, 03:29 PM
Sarah
 
Posts: n/a
Default Re: basic question re: upgrading from 4.1.11 to 5.0 on RHE 4

> Is it merely a matter of extracting the s/ware? Am I supposed to just
> untar over the existing MySQL installation, i.e. into the same
> directories where the version 4 software lives? Again, sorry to be so
> stupid, I really have tried to find the answer on my own. Thanks VERY
> much in advance for your help I will be very grateful to have a firm
> idea of what I need to do!!


Hi,

Maybe I should ask this a different way. Are these the steps I should
take to upgrade from 4.1.11 to 5.0.x:

1. make sure I have dumps for each database including the mysql
database.
2. shutdown MySQL 4.1.11 and rename it/copy it somewhere else
3. upload the non-RPM Linux (x86) tar.gz file to the server.
4. untar the tar.gz file into the same directories where the 4.1.11
version is (we're not using the standard directory structure, not my
decision, sigh).
5. start MySQL, login, make sure I can do basic stuff in the
databases and make sure the user accounts are all still there.
6. run mysql_upgrade
7. run other CFT's / verify the applications can connect, etc.

The thing that seems sketchy about this is that I assume the 4.1.11
version gets overwritten, making it difficult to go back to that
version if something goes wrong with the new version. I would prefer
to install the new version to a separate directory tree but if I do
that I'll have to create & upload all the databases and then re-create
all the user accounts, which seems cumbersome.

I need to get this work done right away. ANY advice very gratefully
received. THANKS!

Sarah Anderson
Reply With Quote