• 1

Failed to copy content of database 'move3afs_wp' Migration tools tried to perform operation in 1 attempts: Restoration of MySQL database failed. Most probable reason:

Target MySQL server does not contain necessary character set. Most likely it is required to have at least MySQL 5.5 to restore such database.

Proposed solutions: *) Obtain another target server which has OS providing appropriate MySQL server version. For example, CentOS 6 provides MySQL 5.1 by default, while CentOS 7 provides MySQL 5.5 by default. *) Connect another external MySQL server to the target server with appropriate MySQL version. Configure that server as default, or specify it in service plan to which subscriptions are assigned to. Remove migrated subscription from the target server and start migration once more. *) Upgrade MySQL server on the target server to appropriate version, then run migration once more (no need to remove subscriptions from target - just run migration over existing domains). For example, for CentOS you could use packages provided by EPEL repositories. This way is not recommended for servers already running in production.

Here is the original error message reported by MySQL client when restoring the database: ERROR 1273 (HY000) at line 25: Unknown collation: 'utf8mb4_unicode_520_ci'

How to solve the problem?

• 4

  Are you moving this database between two servers or copying it on the same server?

importing from other server cpanel but My friend Told me Database encoding error See the photo

• data.PNG 14.5 KB · Views: 12

• 5

• sssss.png 49.4 KB · Views: 18

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Getting collation error

1273 - Unknown collation: 'utf8mb4\_unicode\_520\_ci' is caused by the difference of the MySQL version from which you export and our MySQL server to which you import.

Basically the Wordpress library for newer version checks to see what version of SQL your site is running on. If it uses MySQL version 5.6 or more, it assumes the use of a new and improved Unicode Collation Algorithm (UCA) called “utf8mb4\_unicode\_520\_ci”. This is great, unless you end up moving your WordPress site from a newer 5.6 version of MySQL to an older, pre 5.6 version of MySQL.

To resolve this you will either have to edit your SQL export file and do a search and replace, changing all instances of ‘utf8mb4\_unicode\_520\_ci’ to ‘utf8mb4\_unicode\_ci’. Or follow the steps below if you have a PHPMyAdmin:

1. Click the Export tab for the database.

1. Click the Custom radio button.

Go the section titled Format-specific options and change the drop-down for Database system or older MySQL server to maximize output compatibility with: from NONE to MYSQL40.

When I'm using localhost/phpmyadmin, it displays, "

1273 - Unknown collation: 'utf8mb4_unicode_ci' ". How can I solve the problem?

SolidBlock (talkcontribs)

I only found the problem in localhost/phpmyadmin. I didn't find any questions in installing wamp5 1.7.4. But using localhost/phpmyadmin is important.

87.123.19.121 (talkcontribs)

Error 1273 means that your database is using a collation, which the MySQL server does not understand. This can happen, when you use a database, which has been created with a newer version of MySQL, with an older MySQL server version. This problem can be solved by converting the wrong collations from utf8mb4_unicode_ci to utf8_general_ci. There is a script on stackoverflow, which does exactly that.

SolidBlock (talkcontribs)

I found sth in other sites:"方法一：替换编码：使用代码编辑器打开导出的sql数据文件，先查找：utf8mb4_unicode_ci，替换为：utf8_general_ci，再查找，utf8mb4，替换为，utf8。方法二：把网站要用的mysql数据库升级到5.5.3以上版本。" But do you know what "sql数据文件"(maybe means "sql data file") means?

1. //www.boke8.net/wordpress-mysql-1273-error.html

175.106.45.205 (talkcontribs)

hello i am amin to fix this error replace all of utf8mb4_unicode_520_ci to utf8mb4_general_ci

This post was hidden by 83.135.226.11 (history)

This post was hidden by 1.23.156.56 (history)

103.68.21.240 (talkcontribs)

yes its works fine.thanks

180.94.84.248 (talkcontribs)

MySQL said:

`

1273 - Unknown collation: 'utf8mb4_persian_ci'`

i have this problem when i want to go to phpmyadmin in localhost server i couldn't solve that, can you help me to solve it?