Categories: Wordpress

#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’ – Solved

Are you changing your Web Hosting Server?

Are you facing this problem while importing your database to another hosting?

Are you seeing this error?

Reason for this error

If your new server is running on Old MySQL 5.5 

And Old server is running on Above MySQL 5.6 server

You may get this error. 
I am giving you two solutions for the same, you may try any of these. 

Solution 1

Download the Old MySQL database and change this instance 

utf8mb4_unicode_520_ci

To 

utf8mb4_unicode_ci

Upload directly to MySQL 

Solution 2

The solution to this error 

Step 1 – First export the database 

Step 2 – Click on Custom 

Step 3 – Then select the output compatibility with MYSQL40

Step 4 – Download the SQL file 

Step 5 – Import it to new Hosting Database. 

If you get a solution to this problem, please comment me, and if you are getting additional errors, write in the comment box.

Avinash Sharma

Since 2009, I am a Writer. Writing is not just giving information and knowledge. It's about teaching to the reader by content.

Recent Posts

Yoga for Writers

Yoga for Writers

Yoga for Writers Being a writer, you have to always think out of the box. Here, Yoga helps you to…

4 months ago
Lead Generation Strategies 2019; Get 1-2 Leads Per Day

Lead Generation Strategies 2019; Get 1-2 Leads Per Day

You are here to know about lead generation strategies in 2019. I am glad to share my experiences with you.…

7 months ago
How to increase page load speed of wordpress website?

How to increase page load speed of wordpress website?

After checking hundreds of plugins, I found that if you put just 2 plugins into your website. Your page speed…

1 year ago
E commerce Marketing 2019 – 10 Digital Marketing Steps to Increase Sales

E commerce Marketing 2019 – 10 Digital Marketing Steps to Increase Sales

Only making ecommerce website is not enough to get sales. You need to work on it. I am sharing you…

1 year ago
Contact Now
close slider