MariaDB understand MySQL JSON. * Change the JSON column to type TEXT in MySQL. After this, MariaDB can directly use the table without any need for a dump and restore. * Use mysqldump to copy the table. Differences Between MySQL JSON Strings and MariaDB JSON Strings --------------------------------------------------------------- * In MySQL, JSON is an object and is compared according to json values. In MariaDB JSON strings are normal strings and compared as strings. One exception is when using JSON_EXTRACT() in which case strings are unescaped before comparison. URL: https://mariadb.com/kb/en/json-data-type/https://mariadb.com/kb/en/json-data-type/