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,431 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,439 views
0 votes
1 answer
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,528 views
0 votes
1 answer
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
686 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,243 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
813 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,971 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,968 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