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 <machielr@stripped>wrote:
> How would I do an inplace upgrade?
>
>
>
> -----Original Message-----
> *From*: Johan De Meersman
> <vegivamp@stripped<Johan%20De%20Meersman%20%3cvegivamp@stripped%3e>
> >
> *To*: Machiel Richards
> <machielr@stripped<Machiel%20Richards%20%3cmachielr@stripped%3e>
> >
> *Cc*: mysql mailing list
> <mysql@stripped<mysql%20mailing%20list%20%3cmysql@stripped%3e>
> >
> *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 <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
>
>
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
