Unknown collation: ‘utf8mb4_unicode_520_ci’« Back to Questions List

I have a WordPress website on my 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!

Posted by Quest
Asked on March 31, 2022 5:34 am
▲
1
▼
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. For Linux users: sed -i s/utf8mb4_unicode_520_ci/utf8mb4_unicode_ci/ file.sql
Posted by darkfire
Answered On March 31, 2022 5:36 am