How to fix Unknown collation utf8mb4_unicode_520_ci error while importing data from an sql dump
Error:
ERROR 1273 (HY000) at line 849: Unknown collation: ‘utf8mb4_unicode_520_ci’
To fix simply replace utf8mb4_unicode_520_ci to utf8mb4_unicode_ci inside your SQL dump
Example:
sed -i 's/utf8mb4_unicode_520_ci/utf8mb4_unicode_ci/g' yoursqldumphere.sql
or
replace 'utf8mb4_unicode_520_ci' 'utf8mb4_unicode_ci' -- yoursqldumphere.sql… Read the rest