#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

mysql sql wordpress collation
Shishil Patel picture Shishil Patel · Feb 22, 2017 · Viewed 299.6k times · Source

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!

Answer

Sabba Keynejad picture Sabba Keynejad · May 22, 2017

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 helpsenter image description here

Related questions

meta_query, how to search using both relation OR & AND?

Resolved: See answer below. I have a custom post type called BOOKS. It has several custom fields, named: TITLE, AUTHOR, GENRE, RATING. How do I fix my meta_query code below so that only books that have the search word …

Read More
SQL query to extract all WordPress posts with categories

I need to extract all posts from my WordPress DB along with the associated categories and not sure how to write this query. I've taken a couple of stabs at it already with no joy and would appreciate the help? …

Read More
Improving a query using a lot of inner joins to wp_postmeta, a key/value table

am working with a wordpress website that is performing the following query, but I see this query is doing many inner joins and the website takes long to load and goes down a lot, and I have been trying to …

Read More