#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

I have a WordPress website on my local WAMP server. But when I upload its database to live server, I get error

#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

Any help would be appreciated!

I believe this error is caused because the local server and live server are running different versions of MySQL. To solve this:

1. Open the sql file in your text editor
2. Find and replace all utf8mb4_unicode_520_ci with utf8mb4_unicode_ci
3. Save and upload to a fresh mySql db

Hope that helps

You can solve this by finding

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

in your .sql file, and swapping it with

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;