I believe this is an error that is caused because the local server and live server are running different version of MySQL. To solve this. Open the sql fine in your text editor Find and replace all utf8mb4_unicode_520_ci with utf8mb4_unicode_ci Save and upload to a fresh mySql db Hope that helps