Focus on cloud service provider activities
Notes on website operation and maintenance

Resolve the MySQL database import prompt "utf8mb4_unicode_520_ci" error

Today, I met a netizen who told Lao Zuo that when he backed up the website database and imported it to another VPS host environment site, he was prompted that the database could not be imported. So Lao Zuo helped to solve this problem. According to the database information provided by netizens, I directly tried to import it with the MySQL command, and was prompted with "ERROR 1273 (HY000) at line 93: Unknown collaboration: ' utf8mb4 _Unicode_520_ci '"Error prompt.

Then I backed up the database on his original server again, and this problem still occurred after importing. This should be caused by the database compatibility problem. The original version of the server's MYSQL is 5.6, but the current version of the server is 5.5. This should be a compatibility problem. Open the SQL database file directly with an editor, and you need to replace the code.

 Resolve the MySQL database import prompt "utf8mb4_unicode_520_ci" error

Lao Zuo also shared two articles about database import coding before:

1、 Resolve the "Unknown character set: 'utf8mb4'" error when importing MySQL database

2、 Resolve the "Unknown collation:'utf8mb4_unicode_ci" error in the WordPress import database

This time I met utf8mb4 _The unicode_520_ci prompts an error. Here we use this method to solve the problem.


Replace all the "utf8mb4_unicode_520_ci" characters in the database with "utf8mb4_unicode_ci" characters, and then import them again so that there are no errors.

PS: Before replacement, we remember to back up a copy to avoid recovery after an error.

Domain name host preferential information push QQ group: six hundred and twenty-seven million seven hundred and seventy-five thousand four hundred and seventy-seven Get preferential promotion from merchants.
Like( one )
Do not reprint without permission: Lao Zuo's Notes » Resolve the MySQL database import prompt "utf8mb4_unicode_520_ci" error

Scan the code to follow the official account

Get more news about webmaster circle!
Entrepreneurship, operation and new knowledge