Comments - Transfer of a website on a MySQL8.0.27 server onto a MariaDB 10.4 server
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.
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.
Thank you Daniel for your answer and for the link. If I correct my database so that it becomes MariaDB syntax, do you know if Joomla4 will accept/recognize my new MariaDB database file (i.e. how good is the compatibility between Joomla4 and a MariaDB database)?
I could also install joomla directly on my online server and then re-create there my website (I would have to recreate the structure with the menus, articles and modules, but could copy/paste all the texts and custom css). Maybe this would be easier (for me, as I'm not a programmer :-) ) than learning to re-write MySQL in MariaDB language.
As Joomla4 supports https://downloads.joomla.org/technical-requirements MySQL-5.6+ there should be no code changes required. Do test in a test environment.
https://issues.joomla.org/ shows an attention to fixing MariaDB related incompatibilities.
Finally, I recreated my website using a MariaDB database, and now everything is working.