ERROR 1273 (HY000) at line 1116: Unknown collation: 'utf8mb4_0900_ai_ci'
MYSQL import issues
Error: ERROR 1273 (HY000) at line 1116: Unknown collation: 'utf8mb4_0900_ai_ci'
1. Export DB:
mysqldump -u root -p DB_NAME > 18_06_21.sql
sed -i 's/utf8mb4/utf8/g' 18_06_21.sql
sed -i 's/utf8_unicode_ci/utf8_general_ci/g' 18_06_21.sql
sed -i 's/utf8_unicode_520_ci/utf8_general_ci/g' 18_06_21.sql
sed -i 's/utf8_0900_ai_ci/utf8_general_ci/g' 18_06_21.sql
2. import DB:
mysql -u root -h HOST_IP -p DB_NAME < 18_06_21.sql
Are there any code examples left?
New code examples in category Other
-
Other 2023-03-27 22:50:10 how to select the whole line in vscode with keyboard shortcut
-
Other 2022-03-27 22:45:24 income of a web developer
-
Other 2022-03-27 22:35:01 \pyrcc_main.py: File does not exist 'resources.qrc'
-
Other 2022-03-27 22:30:45 rick roll embed code
-
Other 2022-03-27 22:20:08 Circuit_04_Potentiometer
-
Other 2022-03-27 22:20:05 iterative power
-
Other 2022-03-27 22:15:11 flutter run all
-
Other 2022-03-27 22:10:05 when is karlson release
-
Other 2022-03-27 22:10:02 wp .htaccess example
-
Other 2022-03-27 22:00:08 bash pause in file read line by line