0 votes
1 view
in AWS by (19.2k points)

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?

1 Answer

0 votes
by (44.6k points)

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
Welcome to Intellipaat Community. Get your technical queries answered by top developers !