Lapicher · July 17, 2018 22:19 · Aug 23, 2017 · Jul 10, 2017 · Jul 10, 2017 · Jul 10, 2017
diff --git a/migrate-django.md b/migrate-django.md
@@ -5,7 +5,8 @@ Dump existing data:
 python3 manage.py dumpdata > datadump.json
 ```
 
-Change settings.py to your mysql.
+Change settings.py to Postgres backend.
+
 Make sure you can connect on PostgreSQL. Then:
 ```
 python3 manage.py migrate --run-syncdb

diff --git a/migrate-django.md b/migrate-django.md
@@ -26,4 +26,4 @@ Finally:
 python3 manage.py loaddata datadump.json
 ```
 
-> Source https://stackoverflow.com/questions/3034910/whats-the-best-way-to-migrate-a-django-db-from-sqlite-to-mysql
+> Source: https://stackoverflow.com/questions/3034910/whats-the-best-way-to-migrate-a-django-db-from-sqlite-to-mysql
diff --git a/migrate-django.md b/migrate-django.md
@@ -1,3 +1,5 @@
+# How to migrate Django from SQLite to PostgreSQL
+
 Dump existing data:
 ```
 python3 manage.py dumpdata > datadump.json

diff --git a/migrate-django.md b/migrate-django.md
@@ -0,0 +1,27 @@
+Dump existing data:
+```
+python3 manage.py dumpdata > datadump.json
+```
+
+Change settings.py to your mysql.
+Make sure you can connect on PostgreSQL. Then:
+```
+python3 manage.py migrate --run-syncdb
+```
+
+Run this on Django shell to exclude contentype data
+```
+python3 manage.py shell
+```
+```
+>>> from django.contrib.contenttypes.models import ContentType
+>>> ContentType.objects.all().delete()
+>>> quit()
+````
+
+Finally:
+```
+python3 manage.py loaddata datadump.json
+```
+
+> Source https://stackoverflow.com/questions/3034910/whats-the-best-way-to-migrate-a-django-db-from-sqlite-to-mysql
No results found