RT migration to different OS

Hi All,

I am in the process to migrate our RT from solaris 10 to ubuntu precise lts
64bit.

Ubuntu precise only offers 5.5.x (
Ubuntu – Package Search Results -- mysql)

I am planning to migrate from RT 3.8.2 with mysql 5.0.75 to the latest.

What would be recommended path to import the dump from mysql 5.0.75 into
5.5.x ?

The other option would be to install the linux 64bit binary for mysql
5.0.77
instead of depending on ubuntu/debian pkg for mysql.

So what is the recommended approach?

Thanks

Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?

Hi All,

I am in the process to migrate our RT from solaris 10 to ubuntu precise
lts 64bit.

Ubuntu precise only offers 5.5.x
(http://packages.ubuntu.com/search?keywords=mysql)

I am planning to migrate from RT 3.8.2 with mysql 5.0.75 to the latest.

What would be recommended path to import the dump from mysql 5.0.75 into
5.5.x ?

The other option would be to install the linux 64bit binary for mysql
5.0.77
instead of depending on ubuntu/debian pkg for mysql.

So what is the recommended approach?

The MySQL documentation seems to cover this pretty well:

http://dev.mysql.com/doc/refman/5.5/en/upgrading.html

You’d want to update RT to the latest patch release to make sure your
version is compatible with the newer MySQL of course.

I’d advise that you follow up on http://dba.stackexchange.com/ if you’re
stuck with the MySQL side of things.

Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services