ERROR 1273 (HY000): Unknown collation: 'utf8mb4_unicode_520

ERROR 1273 (HY000): Unknown collation: 'utf8mb4_unicode_520_ci'

Today, when importing a MySQL database, I encountered an error message: ERROR 1273 (HY000) at line 129: Unknown collation: 'utf8mb4_unicode_520_ci'. I looked and it seemed that other people had encountered the same problem, so I wrote it down for my reference next time I encounter it. If other readers encounter it, they can also refer to it.

The VPS host installed the LNMP1.8 one-click package, and an error occurred when trying to import the database:

 [root@Server ~]# mysql -u -p.net < blog.sql
ERROR 1273 (HY000) at line 129: Unknown collation: 'utf8mb4_unicode_520_ci'

The solution is also very simple. Open the database with an editor and replace all the "utf8mb4_unicode_520_ci" characters in the database with "utf8mb4_unicode_ci", then import it again and there will be no problem.

HostDare: Los Angeles VPS with 10% off monthly payment and 30% off annual payment starting at $18/year, annual payment gives double memory + double traffic

Blog

ERROR 1273 (HY000): Unknown collation: 'utf8mb4_unicode_520_ci'

HostDare: Los Angeles VPS with 10% off monthly payment and 30% off annual payment starting at $18/year, annual payment gives double memory + double traffic

Spinservers promotion: 256GB memory high-end server 10Gbps bandwidth $199/month, San Jose China Telecom network $179/month

What are the future trends of mobile phone connections?

How the Network Supports Zero Trust

Seven steps to easy network segmentation

How will Yang Jie take the helm of China Mobile when the net profits of the two operators differ by 5 times?

HTTP/[0.9 | 1.0 | 1.1 | 2 | 3]

5G can be unleashed through chip innovation

UFOVPS limited 30% off, Japan/Hong Kong CN2 GIA/US high-defense VPS monthly payment starts from 26 yuan, top up 200 yuan and get 20 yuan

Kvmla: VPS hosts are 20% off, old users can get 100 yuan for 500 yuan, Singapore dedicated servers start from 350 yuan/month

Recommend

Facing these possible accidents, is your operation and maintenance team ready?

DiyVM 50% off in October, Hong Kong/Japan/US VPS-2G memory package monthly payment starts from 50 yuan, CN2 line

Before the 5G feast, the operators' tight restrictions have been booked

Countries are competing to deploy 6G commercial services, and South Korea is ahead of the United States and Japan to seize the opportunity

Private 5G is key to improving safety, efficiency and productivity in the mining industry

South Korea: 14 6G communication satellites will be launched before 2031

The Internet of Identity is coming, and IAM will undergo a major change

The number of IoT users of the three major operators exceeds 1.1 billion, and the Internet of Everything brings trillions of connection value

API Gateway Selection: I use OpenResty!

Interview: ZooKeeper 23 questions, see if you can answer them

Moving forward amid challenges: A review of the top ten events in the 5G field in 2020

I heard that the client will disappear within three years.

DirectAdmin (DA) latest installation tutorial (2020)

Neusoft Security - A "practical" company in the field of in-vehicle information security

How can enterprises fully leverage the potential of private 5G networks?