The Ultimate Guide to High Availability with MariaDB

How do I import MYSQL DB into Maria DB

You are viewing an old version of this article. View the current version here.

I am moving trying to move my website from Windows Server running IIS 10, PHP and MYSQL 8 to CentOS using a Maria DB.

I am have exported the DB with the MYSSQL Workbench to a elf contained file but I cant get it to import in MyPHPAdimin. I get this error: Does anyone know the best way to to this?

Error SQL query:

CREATE TABLE `wp_commentmeta` ( `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT, `comment_id` bigint unsigned NOT NULL DEFAULT '0', `meta_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `meta_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci, PRIMARY KEY (`meta_id`), KEY `comment_id` (`comment_id`), KEY `meta_key` (`meta_key`(191)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; MySQL said: Documentation

  1. 1273 - Unknown collation: 'utf8mb4_unicode_520_ci'

Comments

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