I see your point. My naive snap reaction was just “well, Version 8 + MySQL/XtraBackup just shouldn’t be a supported thing” and there should be a defined migration/upgrade script to take a db dump from “Version 7 + MySQL/XtraBackup” and ingest into “Version 8 + MariaDB/MariaBackup”.
However, that means that the issue is more fundamental and probably not yours to fix:
I don’t think that MySQL is actually supported in the latest versions of OpenEMR. It’s not running on any of the demos, and is not included in any of the suggested compose files for the latest official docker images. Given that, how is it being tested? Is it part of someone’s CI/CD pipeline?
I already identified one issue (thankfully mitigated) related to MariaDB/MySQL divergence. The likelihood of there being more undiscovered has prevented me from upgrading my AWS instances, and it’s a problem that will only get worse as the two DBMS continue to evolve.