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 MariaDB to one that is running MySQL?

Answer

The Transfer Tool allows the transferring of accounts between servers with differing MariaDB and MySQL installations. 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.

Note

Please note, that 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.

More info for your developers can be found on the following MySQL and MariaDB official documentation pages:

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