Re: migration from 5.0/5.1
Posted by: Peter Brawley
Date: June 06, 2020 12:44PM

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.

Options: ReplyQuote


Subject
Written By
Posted
June 06, 2020 11:08AM
Re: migration from 5.0/5.1
June 06, 2020 12:44PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.