CODEWITHSUNDEEP
mysqlmysql-workbenchcollation
igneous spark
igneous spark

Reputation: 47

(mysql workbench)ERROR 1273 (HY000) at line 25: Unknown collation: 'utf8mb4_0900_ai_ci' --user=root --port=3306 --default-character-set=utf8

i an importing sql dump file in my database but getting this error

     11:29:12 Restoring E:\ews project\dumps\Dump20230525.sql
 Running: mysql.exe --defaults-file="C:\Users\INP\AppData\Local\Temp\tmpz8kesn1f.cnf"  - 
 -protocol=tcp --host=164.164.32.6 --user=root --port=3306 --default-character-set=utf8 
 --comments --database=practice  < "E:\\ews project\\dumps\\Dump20230525.sql"
 ERROR 1273 (HY000) at line 25: Unknown collation: 'utf8mb4_0900_ai_ci'

 Operation failed with exitcode 1
 11:29:14 Import of E:\ews project\dumps\Dump20230525.sql has finished with 1 errors

i have also tried as per this link that change the COLLATE=utf8mb4_general_ci; from COLLATE=utf8mb4_ai_ci;

ERROR 1273 (HY000) at line 1520: Unknown collation: 'utf8mb4_0900_ai_ci'

but still same error occuring. these are the version of MYSQL dump file and platform

MySQL dump 10.13 Distrib 8.0.33, for Linux (x86_64)

-- Host: 127.0.0.1 Database: practice

-- Server version 8.0.32-0ubuntu0.22.04.2

these are the version of MYSQL importing mysql workwench and platform

MySQL workwench 8.0.03 Distrib 8.0.33, for windows (x86_64)

-- Host: 127.0.0.1 Database: practice

-- Server version 8.0.3-windows 11

Upvotes: 0

Views: 652

Answers (1)

igneous spark
igneous spark

Reputation: 47

MYSQL server workbench version mismatch . so uninstall workbench and install again. and configure connection then import dump file

Upvotes: 0

Related Questions