Upgrading of mysql database

--=-rkCNhhYEziNXV6Rf+RJx
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

Hi All

Sorry for all my posts today but this one client is keeping me
busy.

the version of MySQL installed on the ubuntu server is
5.0.51a-3ubuntu5.8-log as this was the latest one available in the
repository.

We will need to upgrade this to version 5.1.53.

Am I correct in assuming the following steps?

1. setup version 5.1.53 on the machine (different port)
2. shutdown the current database.
3. create backup file
4. restore backup
5. change port to 3306
6. startup new database.
7. disable the old database so that it would not start
up during reboot.

Regards
Machiel

--=-rkCNhhYEziNXV6Rf+RJx--

Re: Upgrading of mysql database

--00221532cd101c4d970495a50826
Content-Type: text/plain; charset=ISO-8859-1

That would work, yes.

You could also try to upgrade in place - the upgrade scripts *should* take
care of everything between those versions, I think. Make sure you have a
backup in any case :-)



On Mon, Nov 22, 2010 at 12:57 PM, Machiel Richards wrote:

> Hi All
>
> Sorry for all my posts today but this one client is keeping me
> busy.
>
> the version of MySQL installed on the ubuntu server is
> 5.0.51a-3ubuntu5.8-log as this was the latest one available in the
> repository.
>
> We will need to upgrade this to version 5.1.53.
>
> Am I correct in assuming the following steps?
>
> 1. setup version 5.1.53 on the machine (different port)
> 2. shutdown the current database.
> 3. create backup file
> 4. restore backup
> 5. change port to 3306
> 6. startup new database.
> 7. disable the old database so that it would not start
> up during reboot.
>
> Regards
> Machiel
>



--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--00221532cd101c4d970495a50826--

Re: Upgrading of mysql database

--=-L6CNGB3DOY+eawDl8DZn
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

How would I do an inplace upgrade?


-----Original Message-----
From: Johan De Meersman
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: Upgrading of mysql database
Date: Mon, 22 Nov 2010 15:25:44 +0100

That would work, yes.

You could also try to upgrade in place - the upgrade scripts *should*
take care of everything between those versions, I think. Make sure you
have a backup in any case :-)



On Mon, Nov 22, 2010 at 12:57 PM, Machiel Richards
wrote:

Hi All

Sorry for all my posts today but this one client is
keeping me
busy.

the version of MySQL installed on the ubuntu server is
5.0.51a-3ubuntu5.8-log as this was the latest one available in
the
repository.

We will need to upgrade this to version 5.1.53.

Am I correct in assuming the following steps?

1. setup version 5.1.53 on the machine (different
port)
2. shutdown the current database.
3. create backup file
4. restore backup
5. change port to 3306
6. startup new database.
7. disable the old database so that it would not
start
up during reboot.

Regards
Machiel



--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel


--=-L6CNGB3DOY+eawDl8DZn--

Re: Upgrading of mysql database

--00032557364a9a91f80495a5d38e
Content-Type: text/plain; charset=ISO-8859-1

Replace the software - if you're using packaged versions, they should take
care of most anything. If not, there's mysql-upgrade or some script. See the
online docs for specifics.

On Mon, Nov 22, 2010 at 3:56 PM, Machiel Richards wrote:

> How would I do an inplace upgrade?
>
>
>
> -----Original Message-----
> *From*: Johan De Meersman
> >
> *To*: Machiel Richards
> >
> *Cc*: mysql mailing list
> >
> *Subject*: Re: Upgrading of mysql database
> *Date*: Mon, 22 Nov 2010 15:25:44 +0100
>
> That would work, yes.
>
> You could also try to upgrade in place - the upgrade scripts *should* take
> care of everything between those versions, I think. Make sure you have a
> backup in any case :-)
>
>
>
> On Mon, Nov 22, 2010 at 12:57 PM, Machiel Richards
> wrote:
>
> Hi All
>
> Sorry for all my posts today but this one client is keeping me
> busy.
>
> the version of MySQL installed on the ubuntu server is
> 5.0.51a-3ubuntu5.8-log as this was the latest one available in the
> repository.
>
> We will need to upgrade this to version 5.1.53.
>
> Am I correct in assuming the following steps?
>
> 1. setup version 5.1.53 on the machine (different port)
> 2. shutdown the current database.
> 3. create backup file
> 4. restore backup
> 5. change port to 3306
> 6. startup new database.
> 7. disable the old database so that it would not start
> up during reboot.
>
> Regards
> Machiel
>
>
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
>


--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--00032557364a9a91f80495a5d38e--