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 in Others by Soham
• 8,730 points
37 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 by Rahul
• 8,980 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,720 points
1,028 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,850 points
279 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 in Database by Vaani
• 5,040 points
29 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
8,498 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
271 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
2,000 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
1,834 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP