Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
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.3k 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
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.7k users

Browse Categories

...