[Fixed]-Can't migrate django databases on MySQL after upgrading to ubuntu 16.04

by

29👍

✅

After struggling with this issue I’ve found that the problem was a change on MySQL 5.7 version.

With MySQL 5.7 the command SET storage_engine=MyISAM won’t work, so that was the problem!

As spotted on the MySQL 5.7 documentation use default_storage_engine instead! My configuration became:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'license_portal',
        'USER': '****',
        'PASSWORD': '****',
        'HOST': '127.0.0.1',
        'PORT': '3306',
        'OPTIONS': {
            "init_command": "SET default_storage_engine=MyISAM",
        },
    },
}
👤charles.fg

Leave a comment