1

I have full access to both databases, but clearly a MySQL dump file isn't going to import cleanly into Postgres. Are there any good step-by-steps for migrating from MySQL to Postgres?

Chris R
  • 533
  • 1
  • 5
  • 20

2 Answers2

1

There are a few MySQL -> PostgreSQL migration resources linked from the PostgreSQL wiki. I've never tried migration with Redmine though.

PostgreSQL 8.2 is quite old now, is it provided by a hosting provider, or can you use a more recent version?

hmallett
  • 2,455
  • 14
  • 26
0

I've used SQL::Translator to do mysql to postgres conversions in the past. Worked pretty well for me.

James
  • 7,643
  • 2
  • 24
  • 33