Try to import with phpmyadmin, and it’ll tell you exactly what the error is.
In my case, it was the collation. I did a find+replace in the entire sql file, which allowed the import to proceed.
I replaced
utf8mb4_unicode_520_ci
with
utf8mb4_unicode_ci