Explore Courses Blog Tutorials Interview Questions
0 votes
in AWS by (19.1k 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, 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.4k points)

dumpdata and loaddata commands are available in Django too and it will be in 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

Related questions

Want to get 50% Hike on your Salary?

Learn how we helped 50,000+ professionals like you !

0 votes
1 answer

Browse Categories