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


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:

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

Leave a comment