If the Apache service starts successfully, the page will show it works!Ĭlose the Apache service by entering the following command in the terminal In the browser, enter the following URL to check whether the Apache service started successfully The Apache service is already installed on the MAC system and we just need to launch it directly using the following methodĮnter the following command in the terminal to launch the Apache serviceĮnter the following command in the terminal to view the Apache service version Hope this is solution helped you to resolve “ Unknown collation: ‘utf8mb4_0900_ai_ci’” issue.The OSX system is very friendly to PHP, we only need simple configuration to start using, this article will step by step to explain the installation and configuration of Apache, PHP and MySQL, paving the way for the start of development after the above changes, the database was successfully restored! 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. 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 kommentar(er)
