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

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

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

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.

Submit an Answer