Comments - Migrate from MySQL 8 to MariaDB 10.3.24 - HowTo?
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I now installed mariadb 10_3_24 and opened the db with the mysql workbench tool
There i tried to import my previous exported db and content from mysql 8 (tried it for only one table and also for the whole database with all tables)
I got this error messages when i tried to im port the db:
19:00:21 Restoring C:\DOWNLOAD\stock_main.sql Running: mysql.exe --defaults-file="c:\users\polzi\appdata\local\temp\tmpdp427k.cnf" --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=stockdb < "C:
DOWNLOAD
stock_main.sql" ERROR 1253 (42000) at line 1: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4'
Operation failed with exitcode 1 19:00:21 Import of C:\DOWNLOAD\stock_main.sql has finished with 1 errors
19:01:42 Restoring C:\TEMP\all-databases.sql Running: mysql.exe --defaults-file="c:\users\polzi\appdata\local\temp\tmphwlsvz.cnf" --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=stockdb < "C:
TEMP
all-databases.sql" ERROR 1273 (HY000) at line 24: Unknown collation: 'utf8mb4_0900_ai_ci'
Operation failed with exitcode 1 19:01:42 Import of C:\TEMP\all-databases.sql has finished with 1 errors