Hi I have a quick question... I am trying to migrate my Wordpress site from SiteGround to HostGator. I am using the plugin MigrateGuru to simplify things. At the end of the migrate process I get the error message:
Error while creating the table wpb7_wpns_malware_hash_file. The key was too long, MAX key length is 767 bytes.
Apparently HostGator only uses MySQL version 5.6.x and thus can't support prefix lengths greater than 767 bytes in InnoDB tables (see here). Is there an easy fix to this problem? I have a background in comp sci and coincidentally am reading a book right now on Database Processing so I have a general idea of what's going on. Thanks!