I made an import of the same file in local MAMP and its working.
So I guess it is something related to the server permissions?
Plugin Author
Yani
(@yaniiliev)
@troglos
What is your hosting provider?
We have a hotfix that might address this issue.
Could you email support at servmask.com and we will try with the hotfix version?
Thanks!
I just found out that it’s the hosting’s MySql version – MariaDB 5.5.41 – and that they cannot upgrade it.
I had to use Duplicator and manually import the dump, but still having big problems.
It does not support “utf8mb4_unicode_520_ci” collation (error #1273), so I had to modify the dump.
After that it gave me also “Incorrect table definition; there can be only one auto column and it must be defined as a key” (error #1075).
And then “The used table type doesn’t support FULLTEXT indexes” (error #1214).
But I still don’t understand why this is happening, I’ve migrated dozens of sites from my localhost to that provider using All-in-One WP Migration with no glitch.
I am NOT happy with the provider at this moment.
Do you think – after the details – that your fix could work?