List:General Discussion« Previous MessageNext Message »
From:Machiel Richards Date:November 22 2010 2:56pm
Subject:Re: Upgrading of mysql database
View as plain text  
How would I do an inplace upgrade?


-----Original Message-----
From: Johan De Meersman <vegivamp@stripped>
To: Machiel Richards <machielr@stripped>
Cc: mysql mailing list <mysql@stripped>
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


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