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
