Navicat macos5/24/2023 ![]() 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. |