Hi everyone,

I must be the most stupid human on the planet but after doing
extensive searching in the MySQL manuals/help, in this group, on the
MySQL site and Google searches I cannot find the answer to my
question. I need to upgrade from MySQL 4.1.11 to 5.0 on Linux Redhat
Enterprise 4. I know where to get the 5.0 s/ware and I understand I
need to backup all of my databases before doing the upgrade but
exactly how do I *do* the upgrade? Everything I've read either refers
to upgrading on Windows or for Linux talks about the prep and what one
might need to do afterwards but then stops short of saying something
like:

Extract the tar.gz file into xxx directory and then do such-and-such.

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!!

Sarah Anderson
The Nature Conservancy

> 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

On 6 Mar, 15:26, Sarah <sander...@tnc.org> wrote:
> > 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

What is the problem with following the instructions in the manual?

On Mar 6, 12:02 pm, Captain Paralytic <paul_laut...@yahoo.com> wrote:

>
> What is the problem with following the instructions in the manual?

I have looked at the 5.0 documentation, specifically sections 2.4.17
and 2.4.17.2.

"2.4.17 Upgrading MySQL" talks about the following:
- before upgrading read the following section of the documentation:
2.4.17.2
- before upgrading make backups of your databases including the mysql
database
- incompatible changes
- if running on Windows see the following .. [I'm on Linux]
- if you are using replication ... [we don't use replication]
- if you are are upgrading from RPM installed... [we didn't use the
RPM previously, don't want to this time]
- info re: mysql-max [we don't have this]
- info re: user defined function [we don't have this]
- info re: moving mysql files between versions [nice to know]
- info re: renaming mysqld [will do this]
- info re: if after the upgrade you experience problems with
recompiled client programs [ok, but when did I DO the upgrade - I
just went from prep to after the upgrade with no "how-to" in between]
- info re: old versions of my.cnf [good to know]
- info re: rebuilding/reinstall Perl dbd:: mysql ... [doesn't apply
to my situation]

2.4.17.2 talks about the following:
- before upgrading please read section 2.4.17 ... [I just read that
section]
- check the items in the change list [did that]
- changes to structure of grant tables & suggestion to use
mysql_upgrade to fix [will do]
- read the change history [did that]
- if you are running on Windows see section ... [not running on
Windows]
- 5.0 adds support for stored procedures [good]
- 5.0 adds support for views [good]
- if you are using replication ... [not using replication]
- then there is a long list of incompatible changes [ good info]
and then I'm at section "2.4.17.3 Copying MySQL databases to another
machine"

Where, please tell me, where, are the instructions for doing the
actual upgrade of the software? I really really really tried to
figure this out by looking at the manual and without asking in this
forum but I cannot find the step by step explanation of how to do it.
Lots of info about prep and aftermath, cannot find a single reference
to explain how the software is physically upgraded. I'm *guessing*
it's just a matter of extracting the tar.gz file over the existing
MySQL direcories but it would be nice if the Upgrade instructions
actually said something to indicate that it's that simple. VERY
grateful if someone could please advise me - if the instructions are
right under my nose I apologize for being so dense and stupid.
Thanks.

Sarah