![]() ![]() With: ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ![]() Replace the below string: ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci Edit the database backup file in text editor and replace “ utf8mb4_0900_ai_ci” with “ utf8mb4_general_ci” and “ CHARSET=utf8mb4” with “ CHARSET=utf8“. Then we do a little tweak in the backup file to resolve this. So we got that the destination server doesn’t contain the required database collation. See the error screenshot during database restoration.Īfter a little investigation, I found that the MySQL server running on the destination is an older version than the source. ![]() The collation id may differ based on the MySQL version.Įrror message: Error 1273 (HY000) at line 25 Unknown collation: 'utf8mb4_0900_ai_ci' Let’s see the problem and solution to the issue faced recently: Problemĭuring the migration of a web application, I got the below error while restoring a database on another server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |