Re: migration from 5.0/5.1

[Peter Brawley]

Much has changed in the 15 years or so of MySQL development since 5.0, for a list of significant incompatibilities your apps and their dbs can run into see https://www.artfulsoftware.com/infotree/mysql_incompat.html ... you'll need to review such lists against your apps & dbs in detail to find out what needs to be done, set up regression testing &c.

Be aware too that MySQL only supports upgrade to adjacent major versions, so if you follow MySQL guidelines you're looking at a step-by-step process, 5.0->5.1->5.5->5.6->5.7->8.0.

So all in all, a simple 1-step isn't possible.

Note there are also incompatibilities between MySQL and MariaDB.