The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Transfer of a website on a MySQL8.0.27 server onto a MariaDB 10.4 server

Hi,

I have a website designed on a localserver using MySQL8.0.27, functionning well there. I would like to transfer this website to my provider (infomaniak), who only provides MariaDB 10.4. Unfortunately, my website isn't working on their server and according to their support this is due to the incompatibility between MySQL8.0 and MariaDB10.4.

I searched a lot on the internet to try to find a solution but couldn't find relevant information. Do you know if there is a way I could "translate" the files of my MySQL database into files compatibles with MariaDB (like a software automatically translating the files)?

Or are there other solutions to this problem?

Thank you very much for your help,

Julie Baumer

Answer Answered by Daniel Black in this comment.

Start looking at the errors in the application log. Most are probably syntax errors. Then look for a relevant knowledge base page along the the difference documentation Ian linked to.

Sqlines has this page on MySQL to MariaDB migration, not as comprehensive as the above referenced links, however it does have some automation.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.