[FIXED]SQL - Import / Export error

Discussion in 'Linux Beginners' started by Taxick, May 26, 2023.

  1. Taxick

    Taxick Member

    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

    -- --------------------------------------------------------
    -- 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..


    I'm a noob, and my nohow about SQL i very limit


    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


    The server i try to export its from is:
    mysql Ver 8.0.33-0ubuntu0.22.04.2 for Linux on x86_64 ((Ubuntu))
    Last edited: May 26, 2023
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    You can find answers on how to import the database and/or how to fix the collation mismatch using Internet Search Engines, with
    MySQL said: Documentation
    Unknown collation: 'utf8mb4_0900_ai_ci'

Share This Page