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.
