I was trying to import a very old mysql database to latest 8.3 mysql database and got following error –
1273 – Unknown collation: ‘utf8mb4_0900_ai_ci’
to overcome this issue, you need to replace the data char set from utf8mb4_0900_ai_ci to utf8mb4_unicode_ci.
You can do this by opening the sql backup file in text editor and replace it.
once done try to import the backup and it should go fine.
