How to resolve
When you export database from PHPmyadmin and try to import it to PHPmyadmin of another server or using any other database management tool, if you get the error #1273 - Unknown collation regarding any collation format. That simply indicates server where you are importing database doesn't support same collation where you are importing database from.
To resolve this problem quickly and get error #1273 fixed for Unknown collation
Just edit your .sql file in any text or code editor find COLLATE=utf8mb4_0900_ai_ci; and remove it , so your import can select default database collation while its creating the tables on new server.
For details please check our tutorial on how to fix #1273 - unknown collation
https://www.webfulcreations.com/how-t...