How do I move data from Postgres to MySQL running on Amazon's RDS?

Question

I need to move a database with a Django schema from Postgres to MySQL, running on Amazon's RDS. I can re-generate the tables using manage.py, but I'm still looking for a way to migrate over all of the raw data. Does anyone know a clean way of moving it over? Are there any gotchas to watch out for with Amazon's RDS?

Answer 1

dumpdata and loaddata commands are available in Django too and it will be in manage.py. This would be the process:

• use syncdb in MySQL to prepare the tables
• use dumpdata from PostgreSQL
• Into the new MySQL instance, do loaddata from the previous command