mariadb unknown collation: 'utf8mb4_0900_ai_ci'
I just opened the dump.sql file in Notepad++ and
hit CTRL+H to find and replace the string
"utf8mb4_0900_ai_ci" and replace with "utf8mb4_general_ci"mariadb unknown collation: 'utf8mb4_0900_ai_ci'
I just opened the dump.sql file in Notepad++ and
hit CTRL+H to find and replace the string
"utf8mb4_0900_ai_ci" and replace with "utf8mb4_general_ci"#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
find:
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
replace with:
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
in your .sql fileERROR 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.sqlCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
