[rt-users] Upgrading mysql a safe way?

[Michael Bochynski]

Then I'd suggest having a separate MySQL instance and "just" migrate the
db as any other regular db. Then point RT to the new db. If you can, you
might want to shut down the RT for the migration time, just to make sure
that everything will be nicely migrated, however it's not a requirement.

In case smth goes wrong, which I highly doubt, you will always have
"old" 3.X instance fully functional, while with the RPM upgrade it's not
always the case :)

Michael


On Mon, 2004-11-29 at 13:23, Derrick, Justin wrote:
> Yes, I am not planning any upgrade of RT at this time, just the db
> behind it. 
> 
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Michael
> Bochynski
> Sent: Monday, November 29, 2004 10:20 AM
> To: RT
> Subject: Re: [rt-users] Upgrading mysql a safe way?
> 
> I just installed a separate instance of MySQL, not using RPMs. Then just
> a regular mysqldump, since you will be using the same version of RT. You
> will use the same version, right? :)
> 
> Michael
> On Mon, 2004-11-29 at 12:45, Derrick, Justin wrote:
> > What would be the easiest and safest way to take a current rt 3.0.10
> > system running against mysql 3.23.58 on fedora core2 to a new version
> > of just mysql if possible>?
> > 
> > We are not looking for increased functionality out of RT, just the db
> > behind it in order to get replication functionality for easier/better
> > backups.
> > 
> > I am guessing that simply using rpm to upgrade the mysql package is a
> > bad idea.
> > 
> > Any suggestions or wiki links I may have overlooked?
> > 
> >  
> > 
> > justin
> > 
> >