
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/