Will format later:
[root@cp ~]# mysql -u admin_ewano -p admin_ewano < elevvysk_wp.sql
Enter password:
ERROR 1273 (HY000) at line 220: Unknown collation: 'utf8mb4_unicode_520_ci'
[root@cp ~]# sed -i 's/utf8mb4/utf8/g' elevvysk_wp.sql
[root@cp ~]# sed -i 's/utf8_unicode_ci/utf8_general_ci/g' elevvysk_wp.sql
[root@cp ~]# sed -i 's/utf8_unicode_520_ci/utf8_general_ci/g' elevvysk_wp.sql
Credit to: https://www.osradar.com/mysql-error-error-1273-hy000-unknown-collation-utf8mb4_unicode_520_ci-solved/
Copyright © 2020
Lingonberry by Anders Noren — Proudly Powered by Bludit — Up ↑
MySQL: Unknown collation while restoring wordpress database.
Will format later:
[root@cp ~]# mysql -u admin_ewano -p admin_ewano < elevvysk_wp.sql
Enter password:
ERROR 1273 (HY000) at line 220: Unknown collation: 'utf8mb4_unicode_520_ci'
[root@cp ~]# sed -i 's/utf8mb4/utf8/g' elevvysk_wp.sql
[root@cp ~]# sed -i 's/utf8_unicode_ci/utf8_general_ci/g' elevvysk_wp.sql
[root@cp ~]# sed -i 's/utf8_unicode_520_ci/utf8_general_ci/g' elevvysk_wp.sql
Credit to: https://www.osradar.com/mysql-error-error-1273-hy000-unknown-collation-utf8mb4_unicode_520_ci-solved/