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’
Solution:
sed -i 's/utf8mb4_unicode_520_ci/utf8mb4_unicode_ci/g' file.sql
Copy/Paste Information
mysql -u username -ppassword databasename < databasename.sql