Upgrading mysql a safe way?

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

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? :slight_smile:

MichaelOn 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



http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

Yes, I am not planning any upgrade of RT at this time, just the db
behind it.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@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? :slight_smile:

Michael

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 :slight_smile:

MichaelOn 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@lists.bestpractical.com
[mailto:rt-users-bounces@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? :slight_smile:

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