Question

How to migrate MySQL Django website to Postgres Django website?

Posted November 23, 2019 564 views
MySQLPostgreSQLDjangoUbuntu 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

Add a comment
9c700632 0bf0 40a1 ac5a 70d7f8ef4fb9
By:
bengaltiger
Add a comment

These 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.

×
2 answers
frankmascarell November 23, 2019

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

Reply Report
bengaltiger November 23, 2019

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.

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help