1273 Unknown collation utf8mb4 unicode 520 ci

Question

I have a WordPress website on my local WAMP server  But when I upload its database to live server  I get error    1273     Unknown collation     utf8mb4 unicode 520 ci      Any help would be appreciated

User · Answer

I just opened the dump sql file in Notepad   and hit CTRL H to find and replace the string  utf8mb4 0900 ai ci  and replaced it with  utf8mb4 general ci    Source link https   www freakyjolly com resolved-when-i-faced-1273-unknown-collation-utf8mb4 0900 ai ci-error

User · Answer

easy replace  sed -i  s utf8mb4 unicode 520 ci utf8mb4 unicode ci g  your sql file sql

User · Answer

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    Click the Export tab for the database 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  Scroll to the bottom and click GO

User · Answer

find and replace   utf8mb4 unicode 520 ci   with  utf8 general ci   in whole sql file

User · Answer

Open the sql file in your text editor   1  Search  utf8mb4 unicode ci  Replace  utf8 general ci  Replace All   2  Search  utf8mb4 unicode 520 ci Replace  utf8 general ci  Replace All   3  Search  utf8mb4  Replace  utf8  Replace All   Save and upload

User · Answer

In my case I substitute it with utf8 general ci with sed like this   sed -i  s utf8 0900 ai ci utf8 general ci g  MY DB sql  sed -i  s utf8mb4 unicode 520 ci utf8 general ci g  MY DB sql    After that  I can import it without any issue

User · Answer

You can solve this by finding  ENGINE InnoDB DEFAULT CHARSET utf8mb4 COLLATE utf8mb4 unicode 520 ci    in your  sql file  and swapping it with   ENGINE InnoDB DEFAULT CHARSET utf8 COLLATE utf8 general ci

User · Answer

I solved it this way  I opened the  sql file in a Notepad and clicked CTRL   H to find and replace the string  quot utf8mb4 0900 ai ci quot  and replaced it with  quot utf8mb4 general ci quot

User · Answer

In my case it turns out my new server was running MySQL 5 5  old server was running MySQL 5 6  So I got this error when trying to import the  sql file I d exported from my old server   MySQL 5 5 does not support utf8mb4 unicode 520 ci   but MySQL 5 6 does   Updating to MySQL 5 6 on the new server solved collation the error    If you want to retain MySQL 5 5  you can  - make a copy of your exported  sql file - replace instances of utf8mb4unicode520 ci and utf8mb4 unicode 520 ci    with utf8mb4 unicode ci - import your updated  sql file

User · Answer

just remove  520   utf8mb4 unicode 520 ci   utf8mb4 unicode ci

User · Answer

I believe this error is caused because the local server and live server are running different versions of MySQL  To solve this    Open the sql file in your text editor  Find and replace all utf8mb4 unicode 520 ci with utf8mb4 unicode ci Save and upload to a fresh mySql db   Hope that helps

User · Answer

Late to the party  but in case this happens with a WORDPRESS installation     1273 - Unknown collation   utf8mb4 unicode 520 ci  In phpmyadmin  under export method   Format-specific options  custom export    Set to   MYSQL40  If you will try to import now  you now might get another error message     1064 - You have an error in your SQL syntax         That is because The older TYPE option that was synonymous with ENGINE was removed in MySQL 5 5   Open your  sql file   search and replace all instances  from TYPE  to ENGINE   Now the import should go smoothly

[mysql] #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

Examples related to mysql

Examples related to sql

Examples related to wordpress

Examples related to collation