[rt-users] migrating from RT 2.0.11/PostgreSQL to RT 2.0.11/MySQL?

[Vivek Khera]

>>>>> "BC" == Bruce Campbell <bruce_campbell at ripe.net> writes:

BC> On Wed, 13 Mar 2002, Seth Gordon wrote:
>> problem?  Do I have to massage the dump file in some way to make it
>> conform to MySQL syntax or to match some configuration detail in the
>> other system?

BC> General advice would be to not attempt to import the complete dump in one
BC> sitting.  If the dump is indeed solely SQL commands, containing no
BC> psql-specific items, go for it.

I think if you use the mysql schema file from the source tree and then
import the data you should be ok.  Just make sure sequence numbers are
set to work properly after the import.

Usually, it makes more sense to add the indexes after the data, but
that depends on your data set size.