#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’

Have same problem. HEEEEELLLLLP

some solution https://stackoverflow.com/questions/29916610/1273-unknown-collation-utf8mb4-unicode-ci-cpanel/29939906#29939906

i use script

but this script do not change сoalition in table wp_term_relationships.
Use notepad or something for edit *.sql file

find this
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

and change
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

This solution worked for me

1) Click the “Export” tab for the database

2) Click the “Custom” radio button

3) Go the section titled “Format-specific options” and change the dropdown for “Database system or older MySQL server to maximize output compatibility with:” from NONE to MYSQL40.

4) Scroll to the bottom and click “GO”.

If it’s related to wordpress, more info on why it is happening.

——

https://stackoverflow.com/questions/21190523/phpmysql-error-1273-1273-unknown-collation-utf8mb4-general-ci

Thanks @alfatihg80, thats works for me ??

Thanks @alfatihg80, that also worked for me. Awesome!

Just an added note, this did work for me in the sense that I was able to import all my data and got the site up and running, but there are unforeseen problems. I can’t save any of the theme specific options for my site, and I believe this is the issue.

I think I’ve narrowed it down to this being an issue with trying to import a database file from a server after 5.5.3 to a server before 5.5.3.

Thanks @alfatihg80, that also worked for me. Awesome!

Hi,

Thats works also for me!
Awesome!

thanks You!

The better way is to update the server database environment to MySQL 5.6

On Ubuntu 14.04 for example you can do it like this

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install mysql-server-5.6

But before doing any manipulations with existing databases don’t forget to make backup!

mysqldump --lock-all-tables -u root -p --all-databases > dump.sql

• This reply was modified 7 years, 9 months ago by almone.
• This reply was modified 7 years, 9 months ago by almone.

Thanks for all @alfatihg80.
Works perfectly…

Thanks a lot alfatihg80! You saved the day ?? !

Thanks a lot man …was breaking the head…same format option should be kept for export and import …works fine …

Also worked for me, thanks!

This is due to WP using the newer optimized MySQL 4.6+ collation.

ServerPress has provided a nifty plugin that will revert any tables from utf8mb4_unicode_520_ci to utf8mb4_unicode_ci automatically and if kept activated will check for any new tables that may have been added by another plugin or process every 24 hours and update them as well.

This way you can migrate to a server running a lower MySQL version without having to edit and export file manually.

https://github.com/ServerPress/databasecollationfix