Hi I have just installed ISPConfig on my other server. I have then tried to export my SQL database from my old server MYSQL 8, and then I try to import it to the MariaDB server on the ISPConfig server But when I try to import the database I get this error Code: -- -------------------------------------------------------- -- -- Struktur-dump for tabellen `wp2k_gdpr_cc_options` -- CREATE TABLE `wp2k_gdpr_cc_options` ( `id` int NOT NULL, `option_key` varchar(255) NOT NULL DEFAULT '1', `option_value` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci, `site_id` int DEFAULT NULL, `extras` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; MySQL said: Documentation #1273 - Unknown collation: 'utf8mb4_0900_ai_ci' I really hope someone can help me, so I can import the database.. EDIT1: I'm a noob, and my nohow about SQL i very limit EDIT2: The server i try to import the database to is: Your MariaDB connection id is 2215 Server version: 10.6.12-MariaDB-0ubuntu0.22.04.1 Ubuntu 22.04 And The server i try to export its from is: mysql Ver 8.0.33-0ubuntu0.22.04.2 for Linux on x86_64 ((Ubuntu))
You can find answers on how to import the database and/or how to fix the collation mismatch using Internet Search Engines, with Code: MySQL said: Documentation #1273 or Code: Unknown collation: 'utf8mb4_0900_ai_ci'