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 https://dev.mysql.com/doc/refman/5.5/en/upgrading.html#upgrade-paths, 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


Subject
Written By
Posted
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, 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.