Commit

4a0da65

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…
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