Hello PythonAnywhere, I'm looking to migrate my current database to MySql for performance reasons, but I keep getting some errors in the bash console. I changed this in settings.py
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'username$database_name',
'USER': 'username',
'PASSWORD': 'mysql_password',
'HOST': 'mysql_hostname',
}
Then I ran:
python manage.py dumpdata > datadump.json
Then:
python manage.py migrate --run-syncdb
Then:
python manage.py loaddata datadump.json
which gives me the following error:
django.db.utils.ProgrammingError: (1146, "Table 'hradutiu$default.django_session' doesn't exist")
Any ideas what I did wrong, have I missed a step in migrating from sqlite to mysql? Any help would be appreciated, you have my permission to look into the files if that could help you in finding a solution. Thank you very much!