Dump existing data:
python3 manage.py dumpdata > datadump.json
Change settings.py to Postgres backend.
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
Not working for me. I am getting this error
django.db.models.fields.related_descriptors.RelatedObjectDoesNotExist: Problem installing fixture '/home/ubuntu/news-manifest-master/datadump.json': Comment has no content_type.
Thanks a bunch. I followed this and it worked perfectly
Thank YOU SO MUUUUUUUCH
Indeed thank you for this post!
😍🤩🥳👍
👏👏👏👏👏........................
Hello @sirodoht ! I have a question. If you remove ContentTypes then what else remains in the database?
I have created many pages in my website in db.sqlite3 database itself and I don't want to recreate everything again. So I need to include ContentTypes in the migration which is causing problems for me and returning ProgrammingError.
Hello @sirodoht ! I have a question. If you remove ContentTypes then what else remains in the database?
I have created many pages in my website in db.sqlite3 database itself and I don't want to recreate everything again. So I need to include ContentTypes in the migration which is causing problems for me and returning ProgrammingError.
You will add the backed up data after removing contenttypes.. so it won't be lost.
Guys I am getting django.db.utils.IntegrityError can anyone please help.
Hey, @AhtishamChishti I am getting also this error..Any solution to this?
it is asking for login to enter in project.
could plz tell me its username and passward?
tables created, ok, but data were not inserted!
because datadump.json have no data user data
How did you resolve the issue. I carried out the instructions successfully, and it showed [Installed 156 objects from 1 fixture]. But there is no data when i see in the web-app or in the pgadmin4. Any help is appreciated.
Error migrating from MySQL to MSSQL
To not found error when use
loaddatato load fixture, excludecontenttypeandauth.Permissionmodules. So the dump line will be:
python manage.py dumpdata --exclude=contenttypes --exclude=auth.Permission > datadump.jsonI found this help on: https://coderwall.com/p/kogbla/django-fixture-dumpdata-loaddata-and-integrity-error
This worked for me. Thanks
Error migrating from MySQL to MSSQL
Try this:
> python manage.py shell
from django.contrib.contenttypes.models import ContentType
ContentType.objects.all().delete()
To not found error when use
loaddatato load fixture, excludecontenttypeandauth.Permissionmodules. So the dump line will be:
python manage.py dumpdata --exclude=contenttypes --exclude=auth.Permission > datadump.json
I found this help on: https://coderwall.com/p/kogbla/django-fixture-dumpdata-loaddata-and-integrity-errorThis worked for me. Thanks
This works for me also. I was not able to go back and do the data dump in the proper way as most of the web suggests.
I needed to have the loaddata adjusted to work.
Why does every assume you have the original data to do the dump again away?
If you have loaddata issues try the the suggestion at https://coderwall.com/p/kogbla/django-fixture-dumpdata-loaddata-and-integrity-error as stated above.
For those with django.db.utils.IntegrityError duplicate entry.
Check if you have any signal creating content post_save, etc.. Comment those and run the process again.
It worked well for me to migrate database models and data from sqlite3 to PostgreSQL as promised.
Thank you, @scarabeo7 !
It is not working for me, when I run python3 manage.py migrate --run-syncdb, after change settings.py to Postgresql, I get the following Error: django.db.utils.ProgrammingError: relation "etl_categories" does not exist Am I making a mistake? SOLVED: Yes I was making a mistake. Since some views and forms in my app use some Models, when I run "python manage.py migrate" the ERROR above appear. If you are having the same problem just delete or comment all your views, forms and urls that uses any model. Then Follow the steps (migrate, load again your data) and finally uncomment/restore your files.
@gamonsalve, thanks!!
In case anyone runs into issues like
object has no attribute '_something_cache': if you're using custompre_saveorpost_savehandlers you need to handle theraw=Truecase in them: https://stackoverflow.com/a/19600001 https://docs.djangoproject.com/en/2.0/ref/django-admin/#what-s-a-fixture