More

    How to fix Unknown collation: ‘utf8mb4_unicode_520_ci’

    Unknown collation is probably caused because your local and live server are running different versions of MySQL. This problem mostly comes when you migrate websites between servers. The error message looks like this:

    **ERROR** database error write Unknown collation: 'utf8mb4_unicode_520_ci'
    #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
    

    How to solve the problem?

    You can solve the problem with a few different ways. An easy way is updating your MySQL on the new server but not everyone can do that.

    The second solution is in the SQL file. Open the sql file in your text editor and follow these steps:

    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)

    The third solution is working with SQL file as well. Find in your .sql file this row:

    ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
    

    and replace it with

    ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
    

    If you have a PHPMyAdmin, you can follow steps below:

    1. Click the Export tab for the database
    2. Click the Custom radio button.
    3. Go the section titled Format-specific options and set the dropdown button to MYSQL40.
    4. Scroll to the bottom and click GO.

     

    Is it your unknown collation problem solved now? Write down your comment on which solution works for you.

    Recent Articles

    How to remove category & tag base from WordPress URL

    Would you like to remove the category & tag base from WordPress URL? Do you need custom URL's? It's a super simple!...

    How to Disable Right Click on WordPress

    Are you worried about having your images stolen from your WordPress website? Then you need to know how to disable right click on...

    How to redirect HTTP to HTTPs in .htaccess

    Today's standard is to have an https certificate. Google will love you if your sites are secured. So https is not standard,...

    How to fix TypeError: $ is not a function in WordPress

    We can guess. You purchased a theme or plugin and a console shown a message "TypeError: $ is not a function"? Ok,...

    How to fix Unknown collation: ‘utf8mb4_unicode_520_ci’

    Unknown collation is probably caused because your local and live server are running different versions of MySQL. This problem mostly comes when...

    Related Stories

    Leave A Reply

    Please enter your comment!
    Please enter your name here

    Stay on op - Get the daily news in your inbox