'Migrating from SQLite to MySQL error: django.db.utils.OperationalError: Problem installing fixture

I've migrated to MySQL from SQLite in my Django project. I've changed the DB settings in settings.py, I've exported my data to a JSON file and I've ran migrations to change to the MYSQL DB. I am at the stage to load the data into the new MYSQL DB I used: python manage.py loaddata datadump.json but it came up with the following error:

django.db.utils.OperationalError: Problem installing fixture '/home/myuser/djangoproject/djangoproject/datadump.json': Could not load userfiles.File(pk=61): (1054, "Unknown column 'data' in 'field list'")

Any ideas on how I can resolve this?

mysqldjangosqlite


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions