List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:November 22 2010 2:25pm
Subject:Re: Upgrading of mysql database
View as plain text  
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 <machielr@stripped>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

Thread
Upgrading of mysql databaseMachiel Richards22 Nov
  • Re: Upgrading of mysql databaseJohan De Meersman22 Nov
    • Re: Upgrading of mysql databaseMachiel Richards22 Nov
Re: Upgrading of mysql databaseJohan De Meersman22 Nov