A MariaDB 11.4 dump failed on every CREATE when I loaded it into MySQL 8.4. So I had Schemity write the MySQL version instead.
Schemity is the desktop database design software I build. In the next release it reads MariaDB as its own database and writes its schema for MySQL: UUID…
Commit
4a0da65
if you use rust for the backend, take a look at sql-splitter.dev, might help on some of that stuff and is very heavily stress tested on this kind of conversion stuff (although its never really done), available as a crate.

sql-splitter.devsql-splitter - High-Performance SQL Dump Toolkit in RustHigh-performance SQL dump toolkit. Split, merge, convert, validate, sample, shard, diff, redact, query, and generate synthetic data from SQL files at ~1 GB/s.
commit 4a0da65