[FIXED]SQL - Import / Export error

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'