1273 Unknown collation utf8mb4 unicode 520 ci

0 votes

I have been using a  WordPress website on my local WAMP server but everytime I upload its database to live server, I get error

#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

What can be done to avoid this ERROR? Any help would be appreciated!

Feb 10, 2022 in Others by Soham
 • 9,710 points • 1,440 views

1 answer to this question.

0 votes

This ERROR which is occurring will definitely be caused due to the versions running of the MySQL being different which are being run by the local and live server. To solve this ERROR, start with opening the SQL file in the text editor following which, please locate and replicate all utf8mb4_unicode_520_ci with utf8mb4_unicode_ci. Then Save and upload to a fresh mySql db. This should hopefully help you solve the ERROR. 

image

answered Feb 10, 2022 by Rahul
 • 9,680 points

Related Questions In Others

0 votes
1 answer

Different types of Collation Sensitivity

Following are the different types of collation ...READ MORE

answered Oct 10, 2018 in Others by CodingByHeart77
 • 3,750 points • 3,443 views
0 votes
1 answer

Best way to get average values within a specific set of time(say, date or year) using MySQL or Rails

I don't think post-process is what you ...READ MORE

answered Nov 8, 2018 in Others by DataKing99
 • 8,250 points • 3,086 views
0 votes
1 answer

How to change the default value and to alter a column in sql?

Hi, You can try this: ALTER TABLE foobar_data CHANGE ...READ MORE

answered Jun 24, 2019 in Big Data Hadoop by Gitika
 • 65,770 points • 1,535 views
0 votes
1 answer

How to deploy a WordPress site and a MySQL database using Minikube

Create a deployment of the mysql. Use ...READ MORE

answered Oct 23, 2019 in Kubernetes by Eric
 • 1,671 views
0 votes
1 answer

What is an index in SQL?

An index is used to speed up ...READ MORE

answered Feb 3, 2022 in Database by Vaani
 • 7,070 points • 690 views
0 votes
2 answers

Selenium Webdriver Error: org.openqa.selenium.WebDriverException: unknown error: call function result missing 'value'

Facing Error Exception in thread "main" org.openqa.selenium .WebDriverException: unknown ...READ MORE

answered Mar 5, 2020 in Selenium by anonymous
 • 10,248 views
0 votes
1 answer

Unknown MSP DEFAULT error query chaincode

./byfn.sh -m up After running the above command, ...READ MORE

answered Jun 8, 2018 in Blockchain by Christine
 • 15,790 points • 818 views
0 votes
1 answer

Unable to Pull image from quay.io: ERROR x509: certificate signed by unknown authority

Download necessary CA certificate. "/etc/ssl/certs/ca-certificates.crt", -> Debian/Ubuntu "/etc/pki/tls/certs/ca-bundle.crt", ...READ MORE

answered Jul 3, 2018 in Other DevOps Questions by Kalgi
 • 52,350 points • 3,991 views
0 votes
1 answer

How to solve “network state unknown. Review successful transactions manually” error?

There seems to be error in the ...READ MORE

answered Jul 27, 2018 in Blockchain by digger
 • 26,740 points • 1,232 views
0 votes
1 answer

docker login unknown shorthand flag: 'e'

add this to your call --no-include-email here is the ...READ MORE

answered Jul 27, 2018 in Docker by Kalgi
 • 52,350 points • 2,982 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.