MySQL Forums
Forum List  »  Newbie

Re: Upgrading Versions
Posted by: Peter Brawley
Date: September 11, 2017 02:28PM

Upgrades are supported between major releases, and must go stepwise, eg 5.1->5.5->5.6->5.7.

Your path would have had to start 4.0->4.1->5.0, but 5.0 is no longer available except as a archived release. 5.1 is obsolete.

If you look at, you'll see that even upgrades from 5.0 to 5.5 aren't now supported.

So long story short, I think your best bet is to do a complete mysqldump from the version 4.0 database, then install the desired present version, 5.7 for production, 8.0 if you're content with pre-prelease software, ensuring that the new datadir differs fro the old, then review incompatibility lists to touch up the dump for 4.0 such that the new mysql installation accepts the old data.

Options: ReplyQuote

Written By
September 11, 2017 12:59PM
Re: Upgrading Versions
September 11, 2017 02:28PM
September 12, 2017 10:02AM
September 12, 2017 10:40AM
September 19, 2017 03:21PM

Sorry, you can't reply to this topic. It has been closed.

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.