![]() sed -i 's/utf8mb4_0900_ai_ci/utf8_general_ci/g' backup.sql sed -i 's/CHARSET=utf8mb4/CHARSET=utf8/g' backup.sql The Linux system users can use the sed command to replace text in files directly. Here we are changing the CHARSET to utf8, that is the older version and have limitation, Read the implications at the end of this article before making the changes in database. 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.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |