Back

Explore Courses Blog Tutorials Interview Questions

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

0 votes
2 views
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 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.4k 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

Related questions

Want to get 50% Hike on your Salary?

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

0 votes
1 answer
How do I get access to the mysql logs from a RDS instance
asked Jul 18, 2019 in AWS by yuvraj (19.1k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...