Can I transfer an account between servers from MariaDB SQL service to a server that has MySQL SQL service using Transfer Tool?

Question

Can I use the Transfer Tool to migrate an account from a cPanel server running different database servers? (MariaDB vs. MySQL)

Answer

While this is possible, we recommend matching the SQL versions to avoid potential complications between the database contents(E.g. Collation) and/or potential issues generated by differences in datatypes and functions between the two servers. The Transfer Tool will facilitate the transferring of accounts between servers with differing MariaDB and MySQL installations.

Warning: Migrating from MariaDB to MySQL using Transfer Tool may end with errors due to various reasons, even after a successful migration. There can be issues at the application level due to a lot of differences between MariaDB and MySQL in storing data, different default values for fields and even missing functions.

Additional Information

MySQL -- How to Migrate from MariaDB to MySQL 8.0

MariaDB -- Incompatibilities and Feature Differences Between MariaDB 10.6 and MySQL 8.0

MariaDB -- Function Differences Between MariaDB 10.6 and MySQL 8.0