Re: Upgrading of mysql database
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
Re: Upgrading of mysql database
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
Re: Upgrading of mysql database
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
Upgrading of mysql database
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