The Ultimate Guide to High Availability with MariaDB

How do I import MYSQL DB into Maria DB

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'

Answer Answered by John Zapf in this comment.

I solved my issue.

I used a WordPress plugin called "All in one wp migration" and it worked perfectly.

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.