Question
How to migrate MySQL Django website to Postgres Django website?
- Posted November 23, 2019
- DjangoMySQLPostgreSQLUbuntu 18.04
Hi,
We have our Django based website running in our local windows box with MySQL database. We plan to deploy our site on Ubuntu, Postgress, Gunicorn and Nginx stack server that can be run on DigitalOcean droplet. I’m looking for a way to achieve this even with the manual intervention? I appreciate if someone can point me the right direction with appropriate documentation.
Thanks
Subscribe
Share
Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Sign in to AnswerThese answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
hello Frank, yes I’m aware of BD Engine parameters but I need to know the steps for actual migration for Django project and not for any other applications.
Changing the type of Database in a Django project is easy, you need to change the BD engine and its parameters in settings.py and then do the migrations from the beginning. In Digital Ocean there is extensive documentation on this subject, you can also consult my video tutorials (subtitles in English) of initiation:
https://www.youtube.com/channel/UCwH_HDL-Ii5NDnYp1EZVvYw?view_as=subscriber