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. |
>>: Migrate WHM/cPanel data to DA (DirectAdmin)
Recommend
ChangeIP: High-security VPS monthly payment starts at $2.39, unlimited traffic VPS annual payment starts at $19.2, optional Los Angeles/Denver/Chicago/Netherlands data centers
ChangeIP is a site under Sharktech's data cen...
Is 5G not the only option for the Internet of Things?
While the Internet of Things has the potential to...
Aruba changes the rules of the game to drive three major changes in network management
When the first iPhone was released in 2007, Steve...
How does network automation simplify network operations?
In today's rapidly evolving digital environme...
What’s next after the first 5G standard is released?
On June 14, Beijing time, the International Mobil...
How low-code platforms enable machine learning
【51CTO.com Quick Translation】 [[425497]] Low-code...
Aruba SD-WAN and cloud security products are now available on AWS Marketplace (China), building secure edge-to-cloud connections
In the cloud-first era, the relationship between ...
Gigsgigscloud's new Singapore cloud starts from $9.8/month, 1G memory, 10G SSD, 500GB/1Gbps monthly traffic
Gigsgigscloud has launched a new Singapore cloud ...
Huawei Galaxy AI Network: Across the entire chain of the intelligent era, enabling transformation in thousands of industries
With the emergence of ChatGPT, we have entered a ...
5G is here, how far is 6G?
"In the 6G era, hundreds of high-definition ...
China Academy of Information and Communications Technology: In November, domestic 5G mobile phone shipments reached 20.136 million units, accounting for 68.1%
On December 10, the China Academy of Information ...
Megalayer Summer Promotion: VPS hosting starts at 189 yuan per year, with optional data centers in San Jose, US, Hong Kong, China, and Singapore
Megalayer's summer special offer is in progre...
What is the value of 5G at the edge?
A lot of people have been questioning the value o...
HostXen offers 50 yuan for new users, starting from 70 yuan per month for 6G memory in the United States/Singapore/Japan/Hong Kong
HostXen is a domestic hosting merchant founded in...
Yunhai: A complete cloud server management system developed based on JAVA+NET
As we know, Standard Interconnect is a business t...